[Remote] Data Engineer (Senior Consultant)

Note: The job is a remote job and is open to candidates in USA. Guidehouse is a consulting firm seeking a Data Engineer (Senior Consultant) to support the Centers for Medicare & Medicaid Services (CMS) data modernization initiative. The role involves building and maintaining modern data pipelines and lakehouse architectures to enable secure processing of federal health data.ResponsibilitiesDesign, develop, and maintain end-to-end ETL/ELT pipelines within Databricks-based environmentsImplement 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 dataCollaborate with cross-functional teams (data scientists, analysts, SMEs, and CMS stakeholders) to translate business requirements into technical solutionsEnsure data quality, lineage, and governance through validation, monitoring, and documentationOptimize performance and efficiency of data processing workflows in cloud-based environmentsSupport data integration and modernization efforts aligned with CMS EIPM objectivesParticipate in Agile development practices, including sprint planning and backlog managementSkillsU.S. Citizenship and ability to obtain a Public Trust clearanceBachelor's degree in Computer Science, Data Science, Information Systems, or related fieldA minimum of FOUR (4) years of experience in data engineering, software engineering, or related technical rolesProficiency in Python and SQL for data engineering and transformation workloadsHands-on experience with Databricks and large-scale data processing environmentsExperience developing and maintaining ETL/ELT data pipelinesExperience working with medallion/lakehouse architectures (bronze, silver, gold)Experience working with relational and/or distributed data systems, including data modelingExperience with CI/CD practices and tools (e.g., Git-based workflows)Familiarity with version control and collaboration tools, including Git, Jira, and ConfluenceExperience working in Agile development environmentsAbility to work independently in a fast-paced environmentStrong analytical and troubleshooting skillsExcellent verbal and written communication skills, with the ability to clearly communicate complex technical concepts to diverse audiencesExperience working with healthcare data, such as claims, eligibility, or clinical datasetsExperience supporting CMS, HHS, or other federal health programsExperience working with state government data programsFamiliarity with data governance, privacy, and compliance frameworks (e.g., HIPAA)Experience supporting data modernization or cloud migration initiativesBenefitsMedical, Rx, Dental & Vision InsurancePersonal and Family Sick Time & Company Paid HolidaysPosition may be eligible for a discretionary variable incentive bonusParental Leave and Adoption Assistance401(k) Retirement PlanBasic Life & Supplemental LifeHealth Savings Account, Dental/Vision & Dependent Care Flexible Spending AccountsShort-Term & Long-Term DisabilityStudent Loan PayDownTuition Reimbursement, Personal Development & Learning OpportunitiesSkills Development & CertificationsEmployee Referral ProgramCorporate Sponsored Events & Community OutreachEmergency Back-Up Childcare ProgramMobility StipendCompany OverviewGuidehouse offers consulting services for public and commercial markets with expertise in management, technology, and risk consulting. It was founded in 2018, and is headquartered in Washington, District of Columbia, USA, with a workforce of 10001+ employees. Its website is https://guidehouse.com.