Lead Data Engineer II

Deloitte’s AI & Data team is hiring a Lead Data Engineer II in Rosslyn, VA (onsite). In this role, you’ll help shape and govern enterprise data architecture while providing technical oversight for data engineering delivery, migrations, and platform standards. You’ll also collaborate across data science, analytics, and business stakeholders to ensure architectural decisions support both operational needs and analytical goals.

Salary: USD 110,700 - 174,600 per yearly. Experience: 5+ years. Education: Bachelor’s degree.

What you’ll do

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

What you’ll bring

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

Tools and technologies

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

Compensation and incentive eligibility

You may also be eligible to participate in a discretionary annual incentive program, subject to the rules governing the program, where any award depends on factors including individual and organizational performance.

Preferred experience

• 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.