Data Engineer III

Deloitte’s Data Engineer III role sits within the AI & Engineering team and focuses on designing, coding, and administering relational and analytical database solutions. You will help build and orchestrate data pipelines, implement infrastructure and governance for data platforms, and work with clients through platform design evaluations and training.

This position is based in Washington, DC and is onsite, supporting Deloitte’s Government & Public Services (GPS) practice and its work with federal, state, local, and public higher education clients.

What you’ll do

• Design, code, test, debug, and document relational and analytical database solutions with a focus on performance, scalability, security, and system integration
• 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 pipeline orchestration workflows with 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 CI/CD practices using Terraform, Ansible, and Docker
• Conduct platform design evaluations, develop program plans and implementation approaches, design access models that support auditability and separation of duties, and communicate cost, performance, scalability, and reliability tradeoffs; train client personnel on data platforms and workflows

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 transformation logic with SQL, Python, and dbt
• Experience with infrastructure-as-code, configuration management, and containerization using Terraform, Ansible, and Docker; building version-controlled CI/CD workflows; and supporting backup, recovery, and disaster-recovery planning for production database environments
• Ability to travel 10-15%, on average
• Must be legally authorized to work in the United States without employer sponsorship, now or in the future

Technologies you may use

• SQL, Python, dbt
• Airflow, Dagster, Tableau
• Terraform, Ansible, Docker
• CI/CD
• Amazon Aurora, Snowflake, Amazon SageMaker, AWS GovCloud

Skills a successful candidate will demonstrate

• Ability to work independently and collaborate as part of a team
• Effective written and verbal communication
• Meticulous attention to detail and quality of work product
• Ability to build and sustain professional relationships
• Ability to lead projects or workstreams
• Ability to manage and prioritize multiple tasks in a fast-paced, dynamic environment
• Strong interpersonal skills and professional demeanor
• Ability to meet deadlines
• Ability to provide clear guidance to others

Team context

• Deloitte’s Government & Public Services (GPS) practice focuses on impact through people, ideas, technology, and outcomes
• Work spans federal, state, and local government clients as well as public higher education institutions
• The AI & Data offering provides a full spectrum of solutions for designing, developing, and operating data and AI platforms, products, insights, and services
• Offerings help clients innovate, enhance, and operate their data, AI, and analytics capabilities so they can mature and scale effectively

Preferred

• Experience using 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 FISMA, NIST requirements, or FedRAMP requirements

Salary: USD 107,700 - 179,500 per year