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:

• Bachelor's degree
• 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