Lead Data Engineer

As a Lead Data Engineer II on Deloitte’s AI & Data team, you will help shape the way data is modeled, governed, and delivered across the enterprise. This onsite role in Baltimore, MD focuses on defining data architecture, standardizing canonical models, and guiding migrations while partnering with data scientists and stakeholders to ensure the architecture supports both operational needs and analytics.

You will own the technical direction for data engineering delivery, from pipeline and schema decisions to code review and quality controls, ensuring architectural approvals and smooth execution during cutovers.

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.
• 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 current operational requirements and future analytical needs.

Requirements

• Ability to work independently and collaborate as part of a team.
• Effective written and verbal communication skills.
• Meticulous attention to detail and quality of work product.
• Ability to build and sustain professional relationships.
• Ability to lead projects or workstreams.
• Ability to manage and prioritize multiple tasks in a fast-paced and dynamic environment.
• Strong interpersonal skills and professional demeanor.
• Ability to meet deadlines.
• Ability to mentor and provide clear guidance to others.
• Bachelor’s degree.
• 5+ years of experience designing database architectures, including recursive and hierarchical data structures.
• 4+ years of experience with SQL and data modeling, including relational, dimensional, and graph-oriented models.
• 4+ years of experience with PySpark and ETL tools, including extract, transform, load (ETL) pipeline development.
• Must be able to obtain and maintain the required clearance for this role.
• Ability to travel 25% on average, depending on client and industry needs.
• Must be legally authorized to work in the United States without employer sponsorship, now or in the future.

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.

Technologies

• SQL
• PySpark

Compensation: The estimated wage range for this role is USD 110,700 to 174,600 per year. You may also be eligible to participate in a discretionary annual incentive program, subject to applicable program rules, including factors such as individual and organizational performance.