Lead Data Engineer

SHR Consulting Group; United States; On-site; USD 180,000 - 230,000; Full time

Benefits offered by this job

Medical, dental, vision

401(k) with company contribution

Paid time off and federal holidays

Certification reimbursement and培训 支援

Life and disability insurance

Job summary

SHR Consulting Group, LLC is seeking a senior Lead Data Engineer to spearhead data pipeline engineering for a FEMA enterprise effort. The role focuses on batch and streaming pipelines, metadata-driven ingestion, schema evolution, and reliable data processing in a regulated environment.

Lead technical delivery and mentor other engineers, while ensuring scalable, cost-efficient solutions and robust testing and deployment practices. Contingent upon contract award.

Qualifications

• Extensive hands-on experience designing and developing enterprise data pipelines.
• Demonstrated experience with Databricks or comparable cloud-based Lakehouse/data engineering platforms.
• Strong experience with metadata-driven data ingestion frameworks.
• Strong knowledge of schema evolution and enterprise data-processing patterns.
• Demonstrated ability to troubleshoot live production pipeline failures.
• Experience debugging complex data-storage and processing structures.
• Experience designing batch and streaming pipelines.
• Experience with cloud-based data engineering in Federal or similarly regulated environments.
• Strong understanding of CI/CD, automated testing, data-quality validation, and deployment automation.
• Experience with scalable data architectures and high-volume enterprise data environments.
• Ability to provide hands-on technical leadership to engineering teams.

Responsibilities

• Lead technical delivery for FEMA pipeline engineering, operations, performance, and migration.
• Design, construct, test, deploy, and maintain scalable batch and streaming data pipelines.
• Build and maintain metadata-driven ingestion pipelines.
• Implement robust schema evolution and data-processing patterns.
• Diagnose and resolve production pipeline failures and complex data-storage issues.
• Design pipelines consistent with FEMA's multi-zone/Medallion architecture.
• Develop modular, parameterized, and reusable pipeline patterns.
• Implement scalable ingestion and transformation solutions supporting increasing data volume, velocity, and concurrency.
• Implement engineering practices for reliability and cost efficiency, including: Incremental processing; Idempotent and restartable jobs; Partitioning; Storage/file-layout optimization; Compute right-sizing.
• Develop automated testing, data-quality validation, and deployment automation.
• Diagnose schema drift, missing or late data, checkpoint/watermark failures, orchestration faults, and performance degradation.
• Conduct root-cause analysis of significant or recurring production issues.
• Support migration of legacy data, pipelines, reporting workloads, and dependencies.
• Support source-system onboarding and integration using APIs, connectors, batch/file transfers, CDC, and custom integration patterns.
• Provide technical leadership and mentoring to Senior Data Engineers and other engineering staff.

Skills

Enterprise data pipelines

Databricks

Metadata ingestion

Schema evolution

CI/CD

Python

SQL

Streaming pipelines

Cloud data platforms

Leadership

Troubleshooting

Tools

Databricks

REST APIs

Git

Job description

SHR Consulting Group, LLC is a small business delivering enterprise IT, cybersecurity, and program management services to the Department of Defense and federal civilian agencies. We support mission-critical infrastructure at the Pentagon and across the National Capital Region, and we invest in our people through competitive compensation, professional certification support, and long-term career growth on stable, multi-year programs.

We are seeking a senior Lead Data Engineeras a Key Personnel for a bid opportunity to lead data pipeline engineering, operations, performance, migration, and integration activities supporting an enterprise FEMA effort.

This position is CONTINGENT UPON CONTRACT AWARD. Candidates selected for consideration must be willing to authorize the submission of their resume and qualifications in support of our proposal response.

Key Responsibilities

• Lead technical delivery for FEMA pipeline engineering, operations, performance, and migration.
• Design, construct, test, deploy, and maintain scalable batch and streaming data pipelines.
• Build and maintain metadata-driven ingestion pipelines.
• Implement robust schema evolution and data-processing patterns.
• Diagnose and resolve production pipeline failures and complex data-storage issues.
• Design pipelines consistent with FEMA's multi-zone/Medallion architecture.
• Develop modular, parameterized, and reusable pipeline patterns.
• Implement scalable ingestion and transformation solutions supporting increasing data volume, velocity, and concurrency.
• Implement engineering practices for reliability and cost efficiency, including:
  
  
  
  • Incremental processing
  
  
  • Idempotent and restartable jobs
  
  
  • Partitioning
  
  
  • Storage/file-layout optimization
  
  
  • Compute right-sizing
  
  
• Develop automated testing, data-quality validation, and deployment automation.
• Diagnose schema drift, missing or late data, checkpoint/watermark failures, orchestration faults, and performance degradation.
• Conduct root-cause analysis of significant or recurring production issues.
• Support migration of legacy data, pipelines, reporting workloads, and dependencies.
• Support source-system onboarding and integration using APIs, connectors, batch/file transfers, CDC, and custom integration patterns.
• Provide technical leadership and mentoring to Senior Data Engineers and other engineering staff.

Required Qualifications

• Extensive hands-on experience designing and developing enterprise data pipelines.
• Demonstrated experience with Databricks or comparable cloud-based Lakehouse/data engineering platforms.
• Strong experience with metadata-driven data ingestion frameworks.
• Strong knowledge of schema evolution and enterprise data-processing patterns.
• Demonstrated ability to troubleshoot live production pipeline failures.
• Experience debugging complex data-storage and processing structures.
• Experience designing batch and streaming pipelines.
• Experience with cloud-based data engineering in Federal or similarly regulated environments.
• Strong understanding of CI/CD, automated testing, data-quality validation, and deployment automation.
• Experience with scalable data architectures and high-volume enterprise data environments.
• Ability to provide hands-on technical leadership to engineering teams.

Highly Desired Technical Experience

• Databricks
• SQL
• Python
• Medallion/Lakehouse architectures
• Structured Streaming or comparable streaming technologies
• REST APIs and source-system integration
• Change Data Capture (CDC)
• CI/CD and Infrastructure/Deployment Automation
• Data quality and observability tooling
• Git/version control
• FinOps and cloud performance optimization

Preferred Qualifications

• Prior FEMA or DHS experience.
• Experience migrating legacy Federal data environments to modern cloud data platforms.
• Experience supporting data platforms used for AI/ML and Retrieval-Augmented Generation (RAG).
• Experience engineering feature pipelines, curated AI datasets, vector/embedding data stores, or AI data products.
• Experience with Federal security requirements including NIST, FISMA, FedRAMP, and DHS 4300A.

Clearance Requirements

• Must be able to obtain and maintain the Government-required suitability/fitness determination and IT access authorization.
• Competitive salary commensurate with experience.
• Comprehensive medical, dental, and vision coverage.
• 401(k) with company contribution.
• Paid time off and eleven federal holidays.
• Certification reimbursement and training support.
• Life and disability insurance.

SHR Consulting Group, LLC is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected veteran status.