Data Engineer (Senior Consultant)

About this role

Job Family:

Data Engineering & Architecture Consulting

Travel Required:

Up to 10%

Clearance Required:

Ability to Obtain Public Trust

What You Will Do:

Guidehouse is seeking a Data Engineer (Senior Consultant) to support a Centers for Medicare & Medicaid Services (CMS) data modernization initiative. This role will focus on building and maintaining modern, scalable data pipelines and lakehouse architectures that enable secure, compliant, and high-performance processing of federal health data.

Key Responsibilities

• Design, develop, and maintain end-to-end ETL/ELT pipelines within Databricks-based environments
• Implement and manage medallion (multi-layered lakehouse) data architectures (bronze, silver, gold)
• Build scalable data pipelines to process large, complex datasets, including structured and semi-structured data
• Collaborate with cross-functional teams (data scientists, analysts, SMEs, and CMS stakeholders) to translate business requirements into technical solutions
• Ensure data quality, lineage, and governance through validation, monitoring, and documentation
• Optimize performance and efficiency of data processing workflows in cloud-based environments
• Support data integration and modernization efforts aligned with CMS EIPM objectives
• Participate in Agile development practices, including sprint planning and backlog management

What You Will Need:

• U.S. Citizenship and ability to obtain a Public Trust clearance
• Bachelor’s degree in Computer Science, Data Science, Information Systems, or related field
• A minimum of FOUR (4) years of experience in data engineering, software engineering, or related technical roles
• **Proficiency in Python and SQL for data engineering and transformation workloads**
• **Hands-on experience with Databricks and large-scale data processing environments**
• Experience developing and maintaining ETL/ELT data pipelines
• Experience working with medallion/lakehouse archi...