Dimensional Modeling

Dimensional Modeling Developer Jobs

2 jobs found

2d ago

Lead Data Engineer

Deloitte Richmond, VA

Richmond, VA

2d ago

$111k - $175k/yr Full time Manager Analytics Business Intelligence

Apply Now

Job Description

As a Lead Data Engineer on Deloitte’s AI and Data team in Richmond, VA, you will help set the direction for enterprise data architecture while guiding delivery of data engineering work and overseeing migration efforts. The role partners closely with data scientists, analysts, and business stakeholders to ensure architectural decisions meet operational and analytical needs.

Role Focus

You will define and govern enterprise data architecture, including both the models and standards that enable consistent, scalable data use. You will also provide technical leadership across data engineering delivery and coordinate data migration planning and execution.

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

Required Skills and Qualifications

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, dynamic environment.
Strong interpersonal skills and professional demeanor.
Ability to meet deadlines.
Ability to mentor and provide clear guidance to others.

Education and Experience

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/ELT pipeline tools (extract, transform, load and extract, load, transform).

Security, Authorization, and Travel

Ability to obtain and maintain the required clearance for this role.
Travel of 25% on average, based on work with clients and industries/sectors served.
Must be legally authorized to work in the United States without employer sponsorship, now or at any time in the future.

Technologies

SQL
PySpark
ETL (extract, transform, load)
ELT (extract, load, transform)
Relational models
Dimensional models
Graph-oriented models

Preferred Qualifications

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.

Location and Compensation

Location: Richmond, VA (onsite)

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

The wage range estimate for this role is $110,700 to $174,600 annually.

View full job page →

1mo ago

Data Engineer – Power BI

Intone Networks Remote 🌍 Remote

Remote

1mo ago Closed

Full time Analytics Business Analytics Business Intelligence

This position is no longer accepting applications (closed Aug 20, 2026).