Data Engineer - Data Engineer III

About This Role

This Data Engineer III role within the Deloitte AI & Engineering team focuses on transforming technology platforms and driving innovation for clients. You will be responsible for reimagining and reengineering critical operations and processes, contributing to improved financial performance, accelerated digital ventures, and growth through innovation.

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
• 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
• 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
• Experience building and maintaining data pipeline orchestration workflows using Apache Airflow or Dagster
• Experience 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
• Experience building version-controlled continuous integration and continuous deployment (CI/CD) workflows
• Experience 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
• Ability to work independently and collaborate as part of a team
• Effective written and verbal communication skills
• 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 and dynamic environment
• Strong interpersonal skills and professional demeanor
• Ability to meet deadlines
• Ability to provide clear guidance to others

Nice to have:

• 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

Benefits

• Eligible to participate in a discretionary annual incentive program, subject to the rules governing the program, whereby an award, if any, depends on various factors, including, without limitation, individual and organizational performance.

About the Company

Deloitte's Government & Public Services (GPS) practice is designed for impact, serving federal, state, and local government clients as well as public higher education institutions. Its AI & Data offering provides a full spectrum of solutions for designing, developing, and operating cutting-edge Data and AI platforms, products, insights, and services, helping clients innovate, enhance, and operate their data, AI, and analytics capabilities to mature and scale effectively.