Data Engineer - Data Engineer III

Deloitte•Washington, DC

22h•$107,700 - $179,500•Onsite

About The Position

Our Deloitte AI & Engineering team transforms technology platforms, drives innovation, and helps make a significant impact on our clients’ success. You’ll work alongside talented professionals reimagining and reengineering operations and processes that are critical to businesses. Your contributions can help clients improve financial performance, accelerate new digital ventures, and fuel growth through innovation.

Requirements

Bachelor’s degree
Ability to obtain and maintain the required clearance for this role
7+ years of experience designing and coding databases for big data and administering cloud-based relational and analytical database platforms, including role-based access control and schema management
Experience designing databases for performance, scalability, security, and system integration; building and maintaining data pipeline orchestration workflows using Apache Airflow or Dagster; and developing Structured Query Language (SQL), Python, and dbt transformation logic
Experience using infrastructure-as-code, configuration-management, and containerization tools, including Terraform, Ansible, and Docker; building version-controlled continuous integration and continuous deployment (CI/CD) workflows; and supporting backup, recovery, and disaster-recovery planning for production database environments
Ability to travel 10–15%, on average, based on the work you do and the clients and industries/sectors you serve
Must be legally authorized to work in the United States without the need for employer sponsorship, now or at any time in the future

Nice To Haves

Experience using Amazon Web Services (AWS) GovCloud database and analytics services, including Amazon Aurora, Snowflake, and Amazon SageMaker
Experience implementing governed data sources and calculation logic for Tableau or business intelligence and data visualization platforms
Experience supporting database platforms in a federal environment governed by the Federal Information Security Modernization Act (FISMA), National Institute of Standards and Technology (NIST) requirements, or Federal Risk and Authorization Management Program (FedRAMP) requirements

Responsibilities

Design, code, test, debug, and document relational and analytical database solutions that address performance, scalability, security, and system-integration requirements
Administer cloud-based database platforms using role-based access controls, schema management, performance tuning, capacity planning, and backup, recovery, and disaster-recovery practices
Extract, parse, validate, and transform structured and unstructured data using parameterized SQL, Python, and dbt; build and maintain data pipeline orchestration workflows with tools such as Airflow and Dagster; and maintain data dictionaries, metadata, and data lineage
Implement governed data sources and calculation logic for dashboard and reporting tools, including Tableau, and test filters, parameters, and user interactions
Develop infrastructure-as-code, configuration-management, containerized deployment, and version-controlled continuous integration and continuous deployment (CI/CD) practices using tools such as Terraform, Ansible, and Docker
Perform platform design evaluations and develop program plans and implementation approaches; design access models that support auditability and separation of duties; communicate cost, performance, scalability, and reliability tradeoffs; and train client personnel on data platforms and workflows