Data Engineer – Healthcare Analytics Platform

Job Family:

Travel Required:

Clearance Required:

What You Will Do:

We are seeking a Data Engineer to support the design and development of an enterprise Contract Performance Analytics platform for a large healthcare system. This role will focus on data architecture ELT/ETL pipeline development and integration of clinical claims and operational data into a scalable analytics ecosystem.

The Data Engineer will play a key role in building a unified data system that enables insights across value-based care contracts (MSSP Medicare Advantage Commercial and Employer Health Plans). This platform integrates EHR cloud-based data processing and an enterprise data warehouse to support analytics and reporting.

Design develop and maintain robust ETL/ELT pipelines to ingest transform and load healthcare data from diverse structured and unstructured sources
Develop pipelines to process data from CMS and payer files (CCLF paid claims PUG) as well as Epic (Caboodle Clarity) data models and extracts
Build and optimize data models to support analytics reporting and operational use cases including BI and downstream analytics consumption
Transform raw data into standardized analytics-ready canonical data models and curated data marts
Build lakehouse/medallion architecture data ingestion patterns and orchestration frameworks
Implement and maintain CI/CD pipelines for data engineering workflows including pipelines and scheduled jobs using version control and automation tools
Collaborate with database administrators analysts and application teams to integrate data sources design schemas and support downstream data consumers
Ensure data quality integrity and accuracy through validation monitoring logging and alerting
Support data migration integration and modernization initiatives including legacy system upgrades optimization of large-scale ETL pipelines query performance and cloud adoption efforts
Troubleshoot and resolve issues in development and production environments to maintain stable and reliable data pipelines
Document data flows pipelines test cases and technical solutions to support knowledge sharing and compliance requirements
Stay current with emerging tools technologies and best practices in data engineering and cloud platforms

What You Will Need:

US Citizenship or a Green Card is required
Bachelors degree in Computer Science Data Analytics Software Engineering Information Systems or related fields
A minimum of FIVE (5) years of experience in data engineering ETL/ELT development or data platform engineering in a healthcare setting
Experience working with healthcare data including claims clinical payer or population health datasets
Experience working with healthcare data interoperability standards (e.g. FHIR HL7)
Proficiency in Python and SQL for data engineering and transformation workloads
Hands-on experience designing and building ETL/ELT pipelines and data ingestion frameworks
Experience working with modern cloud data platforms or ETL/ELT tools (e.g. Databricks Azure Data Factory AWS Glue)
Experience working with lakehouse or medallion-style architectures for analytics platforms
Strong knowledge of relational database design data warehouses and/or data lakes (e.g. star/snowflake schemas)
Experience working with relational and/or distributed data systems including data modeling
Experience working in a cloud environment (AWS or Azure) supporting data solutions
Experience with CI/CD practices and version control tools (e.g. Git)
Experience using monitoring and logging tools to support data pipeline reliability
Experience working with PHI and healthcare data privacy/security requirements
Ability to work effectively in an Agile development environment
Strong analytical and troubleshooting skills and the ability to communicate technical concepts clearly to clients engineers and business stakeholders
Ability to work independently in a fast-paced client-facing environment

What Would Be Nice To Have:

Previous experience working with Epic and/or Athena in a healthcare setting for data engineering

Previous experience with Exasol or similar analytics platform
AWS Azure Databricks Snowflake or other data engineeringrelated certifications
Experience with data visualization or analytics tools (e.g. Tableau Power BI)
Exposure to microservices-based architectures or AI/ML-enabled data pipelines
Prior consulting experience

What We Offer:

Guidehouse offers a comprehensive total rewards package that includes competitive compensation and a flexible benefits package that reflects our commitment to creating a diverse and supportive workplace.

Benefits include:

• Medical Rx Dental & Vision Insurance

• Personal and Family Sick Time & Company Paid Holidays

• Position may be eligible for a discretionary variable incentive bonus

• Parental Leave and Adoption Assistance

• 401(k) Retirement Plan

• Basic Life & Supplemental Life

• Health Savings Account Dental/Vision & Dependent Care Flexible Spending Accounts

• Short-Term & Long-Term Disability

• Student Loan PayDown

• Tuition Reimbursement Personal Development & Learning Opportunities

• Skills Development & Certifications

• Employee Referral Program

• Corporate Sponsored Events & Community Outreach

• Emergency Back-Up Childcare Program

• Mobility Stipend

About Guidehouse

Guidehouse is an Equal Opportunity EmployerProtected Veterans Individuals with Disabilities or any other basis protected by law ordinance or regulation.

Guidehouse will consider for employment qualified applicants with criminal histories in a manner consistent with the requirements of applicable law or ordinance including the Fair Chance Ordinance of Los Angeles and San Francisco.

If you have visited our website for information about employment opportunities or to apply for a position and you require an accommodation please contact Guidehouse Recruiting at 1- or via email at . All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodation.

All communication regarding recruitment for a Guidehouse position will be sent from Guidehouse email domains including @ or . Correspondence received by an applicant from any other domain should be considered unauthorized and will not be honored by Guidehouse. Note that Guidehouse will never charge a fee or require a money transfer at any stage of the recruitment process and does not collect fees from educational institutions for participation in a recruitment event. Never provide your banking information to a third party purporting to need that information to proceed in the hiring process.

If any person or organization demands money related to a job opportunity with Guidehouse please report the matter to Guidehouses Ethics Hotline. If you want to check the validity of correspondence you have received please contact . Guidehouse is not responsible for losses incurred (monetary or otherwise) from an applicants dealings with unauthorized third parties.

Guidehouse does not accept unsolicited resumes through or from search firms or staffing agencies. All unsolicited resumes will be considered the property of Guidehouse and Guidehouse will not be obligated to pay a placement fee.