Lead Data Engineer II
Job Description
Work on Deloitte’s AI & Data team in Rosslyn, VA (onsite) as a Lead Data Engineer II. This role supports enterprise impact by guiding how data is modeled, governed, and delivered across operational and analytical needs. You will set the direction for data architecture, provide technical oversight of data engineering delivery, and lead critical migration and cutover activities.
Salary range: USD 110,700 to 174,600 per year. Location: Rosslyn, VA (onsite). Experience: 5+ years. Education: Bachelor’s degree.
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, including ontology structures and platform data standards to improve consistency, scalability, and system performance.
- Provide technical oversight for data engineering delivery, covering 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.
- Partner with data scientists, analysts, and business stakeholders to align architecture decisions with both current operational requirements and future analytical needs.
Requirements
- Bachelor’s degree
- 5+ years designing database architectures, including recursive and hierarchical data structures
- 4+ years with SQL and data modeling across relational, dimensional, and graph-oriented models
- 4+ years with PySpark and extract, transform, load pipeline tooling (ETL)
- Ability to obtain and maintain required clearance for this role
- Travel 25% on average based on work, clients, and industries/sectors served
- Legally authorized to work in the United States without employer sponsorship, now or in the future
Technologies
- SQL
- PySpark
- Extract, transform, load (ETL) tooling
Benefits
You may also be eligible to participate in a discretionary annual incentive program, subject to program rules. Awards, if any, depend on factors including individual and organizational performance.
Preferred
- 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