EngineerJobs.io
← Back to all jobs
Deloitte

Lead Data Engineer

Deloitte
McLean, VA $111k - $175k/yr Full time Posted 8h 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

Join Deloitte’s AI & Data team in McLean, VA (onsite) as a Lead Data Engineer. In this role, you will help shape enterprise data architecture and establish canonical data models and platform standards that support consistent, scalable delivery. You’ll also lead technical oversight of data engineering execution, guide migration planning through cutover, and partner closely with data scientists, analysts, and business stakeholders to connect architecture decisions to operational needs and future analytics.

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 improve consistency, scalability, and system performance.
  • Provide technical oversight of data engineering delivery, including pipeline design, schema changes, code reviews, quality controls, and architectural approvals.
  • Direct data migration planning and execution, covering sequencing, mapping, validation, reconciliation, rollback planning, and issue resolution during cutover.
  • Collaborate with data scientists, analysts, and business stakeholders to align architecture decisions with current operations and future analytical requirements.

Requirements

  • 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 ETL/ELT pipeline tools (extract, transform, load; extract, load, transform).
  • Ability to obtain and maintain the required clearance for this role.
  • Ability to travel 25% on average based on work with clients and industries or 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
  • ETL (extract, transform, load)
  • ELT (extract, load, transform)

What a Strong Candidate Brings

  • Ability to work independently and collaborate as part of a team.
  • Effective written and verbal communication skills.
  • Meticulous attention to detail and quality-focused delivery.
  • Ability to build and sustain professional relationships.
  • Capability to lead projects or workstreams.
  • Ability to manage and prioritize multiple tasks in a fast-paced, dynamic environment.
  • Strong interpersonal skills and professional demeanor.
  • Ability to meet deadlines.
  • Ability to mentor and provide clear guidance to others.

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.

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

Similar Jobs