Lead Data Engineer II

Deloitte’s AI and Data team is seeking a Lead Data Engineer II to help shape enterprise data architecture and ensure engineering delivery aligns with operational and analytical priorities. Based in Rosslyn, VA (onsite), this role provides technical leadership across pipeline and schema changes, with ownership of migration planning and cutover execution details.

In this position, you will define governance for enterprise data architecture, guide data engineering execution through code and quality controls, and partner with stakeholders across the organization to keep architecture decisions grounded in both current needs and future use cases.

Key Responsibilities

• Define and govern enterprise data architecture, including logical and physical data models, database schemas, and hierarchical and recursive data structures.
• Design and oversee canonical data models, ontology structures, and platform data standards to support consistency, scalability, and system performance.
• Provide technical oversight of data engineering delivery, including pipeline design, schema changes, code reviews, quality controls, and architectural approvals.
• Lead data migration planning and execution, including sequencing, mapping, validation, reconciliation, rollback planning, and issue resolution during cutover.
• Collaborate with data scientists, analysts, and business stakeholders to align architecture decisions with operational requirements and future analytical needs.

Required Qualifications

• Bachelor’s degree.
• 5+ years designing database architectures, including recursive and hierarchical data structures.
• 4+ years with Structured Query Language (SQL) and data modeling, including relational, dimensional, and graph-oriented models.
• 4+ years with PySpark and extract, transform, load (ETL) pipeline tools.
• Ability to obtain and maintain the required clearance for this role.
• Travel 25% on average, based on work needs and the clients and industries/sectors served.
• Must be legally authorized to work in the United States without employer sponsorship, now or in the future.

Technologies

• Structured Query Language (SQL)
• PySpark
• Extract, transform, load / extract, load, transform pipeline tools

Additional Incentive Information

You may also be eligible to participate in a discretionary annual incentive program, subject to program rules, where awards (if any) depend on factors including individual and organizational performance.

Compensation: USD 110,700 - 174,600 per year.

Preferred Qualifications

• Experience leading enterprise data migration efforts from legacy systems to target-state platforms.
• Experience leading data engineering teams or technical workstreams.
• Experience translating business requirements into technical data architecture designs.