[Remote] Data Engineer – Healthcare Analytics Platform

Note: The job is a remote job and is open to candidates in USA. Guidehouse is a consulting firm that specializes in data engineering and analytics solutions for various sectors, including healthcare. They are seeking a Data Engineer to support the design and development of an enterprise Contract Performance Analytics platform, focusing on data architecture, pipeline development, and integration of healthcare data.ResponsibilitiesDesign, develop, and maintain robust ETL/ELT pipelines to ingest, transform, and load healthcare data from diverse structured and unstructured sourcesDevelop pipelines to process data from CMS and payer files (CCLF, paid claims, PUG) as well as Epic (Caboodle, Clarity) data models and extractsBuild and optimize data models to support analytics, reporting, and operational use cases, including BI and downstream analytics consumptionTransform raw data into standardized, analytics-ready canonical data models and curated data martsBuild lakehouse/medallion architecture, data ingestion patterns, and orchestration frameworksImplement and maintain CI/CD pipelines for data engineering workflows, including pipelines and scheduled jobs, using version control and automation toolsCollaborate with database administrators, analysts, and application teams to integrate data sources, design schemas, and support downstream data consumersEnsure data quality, integrity, and accuracy through validation, monitoring, logging, and alertingSupport data migration, integration, and modernization initiatives, including legacy system upgrades, optimization of large-scale ETL pipelines, query performance, and cloud adoption effortsTroubleshoot and resolve issues in development and production environments to maintain stable and reliable data pipelinesDocument data flows, pipelines, test cases, and technical solutions to support knowledge sharing and compliance requirementsStay current with emerging tools, technologies, and best practices in data engineering and cloud platformsSkillsUS Citizenship or a Green Card is requiredBachelor's degree in Computer Science, Data Analytics, Software Engineering, Information Systems, or related fieldsA minimum of FIVE (5) years of experience in data engineering, ETL/ELT development, or data platform engineering in a healthcare settingExperience working with healthcare data, including claims, clinical, payer, or population health datasetsExperience working with healthcare data interoperability standards (e.g., FHIR, HL7)Proficiency in Python and SQL for data engineering and transformation workloadsHands-on experience designing and building ETL/ELT pipelines and data ingestion frameworksExperience 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 platformsStrong 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 modelingExperience working in a cloud environment (AWS or Azure) supporting data solutionsExperience with CI/CD practices and version control tools (e.g., Git)Experience using monitoring and logging tools to support data pipeline reliabilityExperience working with PHI and healthcare data privacy/security requirementsAbility to work effectively in an Agile development environmentStrong analytical and troubleshooting skills, and the ability to communicate technical concepts clearly to clients, engineers, and business stakeholdersAbility to work independently in a fast-paced, client-facing environmentPrevious experience working with Epic and/or Athena in a healthcare setting for data engineeringPrevious experience with Exasol or similar analytics platformAWS, Azure, Databricks, Snowflake or other data engineering–related certificationsExperience with data visualization or analytics tools (e.g., Tableau, Power BI)Exposure to microservices-based architectures or AI/ML-enabled data pipelinesPrior consulting experienceBenefitsMedical, 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.