Lead Data Engineer (secret clearance required)

Relha LLC; McLean, Richmond, Baltimore (VA, VA, MD); On-site; USD 111,000 - 175,000; Full time

Job summary

Deloitte’s AI & Data team seeks a Lead Data Engineer II to define and govern enterprise data architecture, oversee canonical models, and lead data engineering delivery across pipelines and migrations.

Successful candidates will possess 5+ years in database architectures, 4+ years in SQL/data modeling and PySpark, and the ability to lead cross-functional data projects while maintaining required security clearances. Travel up to 25% is expected.

Qualifications

• 5+ years designing database architectures including recursive and hierarchical data structures.
• 4+ years SQL and data modeling (relational, dimensional, graph).
• 4+ years PySpark and ETL pipeline tooling.
• Must be able to obtain and maintain the required clearance for this role.
• Ability to travel 25%, on average, based on the work you do and the clients served.
• Must be legally authorized to work in the United States without sponsorship now or in the future.

Responsibilities

• Define and govern enterprise data architecture, including models, schemas, and data structures.
• Design canonical data models and platform data standards for consistency and performance.
• Lead data engineering delivery, including pipeline design, code reviews, and architectural approvals.
• Direct data migration planning and execution during cutover processes.
• Collaborate with data scientists, analysts, and stakeholders to align architecture with requirements.

Skills

Database architectures

SQL & data modeling

PySpark

ETL pipelines

Leadership

Data migration

Communication

Collaboration

Project management

Tools

PySpark

ETL tools

Job description

Lead Data Engineer (secret clearance required)

Our Deloitte AI & Engineering team to transform technology platforms, drive innovation, and help make a significant impact on our clients’ success. You’ll work alongside talented professionals reimagining and reengineering operations and processes that are critical to businesses. Your contributions can help clients improve financial performance, accelerate new digital ventures, and fuel growth through innovation.

Work You’ll Do

As a Lead Data Engineer II on the AI & Data team, you will be responsible for:

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.

Lead technical oversight of data engineering delivery, including pipeline design, schema changes, code reviews, quality controls, and architectural approvals.

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

A successful candidate would possess these skills:

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

The Team

Deloitte’s Government & Public Services (GPS) practice – our people, ideas, technology and outcomes – is designed for impact. Serving federal, state, & local government clients as well as public higher education institutions, our team of professionals brings fresh perspective to help clients anticipate disruption, reimagine the possible, and fulfill their mission promise.

Our AI & Data offering provides a full spectrum of solutions for designing, developing, and operating cutting-edge Data and AI platforms, products, insights, and services. Our offerings help clients innovate, enhance and operate their data, AI, and analytics capabilities, ensuring they can mature and scale effectively.

The Project Delivery Talent Model is designed for professionals with specialized skills that align to a current client need. Team members focus on delivering services to clients, without additional expectations related to business development or promotion. Their employment is tied to their role on a project, and they are eligible for a benefits package that is competitive for project delivery-focused professionals.

Qualifications

Required:

5+ years of experience designing database architectures, including recursive and hierarchical data structures

4+ years of experience with Structured Query Language and data modeling, including relational, dimensional, and graph-oriented models

4+ years of experience with PySpark and extract, transform, load/extract, load, transform pipeline tools

Must be able to obtain and maintain the required clearance for this role

Ability to travel 25%, on average, based on the work you do and the clients and industries/sectors you serve.

Must be legally authorized to work in the United States without the need for employer sponsorship, now or at any time 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

The wage range for this role takes into account the wide range of factors that are considered in making compensation decisions including but not limited to skill sets; experience and training; licensure and certifications; and other business and organizational needs. The disclosed range estimate has not been adjusted for the applicable geographic differential associated with the location at which the position may be filled. At Deloitte, it is not typical for an individual to be hired at or near the top of the range for their role and compensation decisions are dependent on the facts and circumstances of each case. A reasonable estimate of the current range is $110,700 to $174,600.

You may also be eligible to participate in a discretionary annual incentive program, subject to the rules governing the program, whereby an award, if any, depends on various factors, including, without limitation, individual and organizational performance.

hich is needed.

Deloitte is committed to providing reasonable accommodations for people with disabilities. If you require a reasonable accommodation to participate in the recruiting process, please direct your inquiries to the Global Call Center (GCC) at [emailprotected] .

Recruiting tips

From developing a stand out resume to putting your best foot forward in the interview, we want you to feel prepared and confident as you explore opportunities at Deloitte. Check out recruiting tips from Deloitte recruiters.

At Deloitte, we know that great people make a great organization. We value our people and offer employees a broad range of benefits. Learn more about what working at Deloitte can mean for you.

Our people and culture

Our inclusive culture empowers our people to be who they are, contribute their unique perspectives, and make a difference individually and collectively. It enables us to leverage different ways of thinking, ideas, and perspectives, and bring more creativity and innovation to help solve our clients' most complex challenges. This makes Deloitte one of the most rewarding places to work.

Our purpose

Deloitte’s purpose is to make an impact that matters for our people, clients, and communities. At Deloitte, purpose is synonymous with how we work every day. It defines who we are. Our purpose comes through in our work with clients that enables impact and value in their organizations, as well as through our own investments, commitments, and actions across areas that help drive positive outcomes for our communities. Learn more.

From entry-level employees to senior leaders, we believe there’s always room to learn. We offer opportunities to build new skills, take on leadership opportunities and connect and grow through mentorship. From on-the-job learning experiences to formal development programs, our professionals have a variety of opportunities to continue to grow throughout their career.

As used in this posting, ""Deloitte"" means Deloitte Consulting LLP, a subsidiary of Deloitte LLP. Please see https://www.deloitte.com/us/about for a detailed description of the legal structure of Deloitte LLP and its subsidiaries.

All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability or protected veteran status, or any other legally protected basis, in accordance with applicable law.