DeveloperJobs.io
← Back to all jobs
Deloitte

Lead Data Engineer

Deloitte
McLean, VA $111k - $175k/yr Full time Posted 6h ago
Manager Big Data Data Data Analysis Data Architecture Data Engineer Data Governance Data Integration Data Management Data Migration Data Modeling Data Pipeline Data Platform Data Processing Data Quality Data Security Database Databases ETL Informatica Lead Data Engineering SQL
Apply Now

Job Description

Deloitte’s AI & Data team is building and operating enterprise data foundations that enable consistent analytics and scalable engineering delivery. As a Lead Data Engineer II based in McLean, VA (onsite), you will set direction for enterprise data architecture, standardize canonical data models, and provide technical oversight across data engineering execution. The role also includes directing data migration planning and cutover support while partnering closely with data scientists, analysts, and business stakeholders.

This position offers a salary range of USD 110,700 to 174,600 per year and requires 5+ years of relevant experience and a 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 and oversee canonical data models, including ontology structures and platform data standards that support consistency, scalability, and system performance.
  • Provide technical oversight of data engineering delivery through pipeline design, schema change reviews, code review, quality controls, and architectural approvals.
  • Direct data migration planning and execution by managing 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 across relational, dimensional, and graph-oriented models.
  • 4+ years with PySpark and extract, transform, load (ETL) and extract, load, transform (ELT) pipeline tooling.
  • Ability to obtain and maintain the required clearance for this role.
  • Travel up to 25% on average, based on work with clients and industry/sectors served.
  • Must be legally authorized to work in the United States without employer sponsorship, now or at any time in the future.

Technologies

  • Structured Query Language (SQL)
  • PySpark
  • Extract, transform, load (ETL)
  • Extract, load, transform (ELT)

Additional Skills for Success

  • Ability to work independently while collaborating 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.
  • Capability to lead projects or workstreams.
  • Manage and prioritize multiple tasks in a fast-paced environment.
  • Strong interpersonal skills and professional demeanor.
  • Ability to meet deadlines.
  • Ability to mentor and provide clear guidance to others.

Preferred Qualifications

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

Similar Jobs