[Remote] Analytics Engineer
Note: The job is a remote job and is open to candidates in USA. HaloMD specializes in Independent Dispute Resolution through The No Surprises Act and state regulations for out-of-network healthcare providers. They are seeking an Analytics Engineer to join their Enterprise Reporting team, where you will build and maintain data pipelines, dashboards, and reporting infrastructure to support decision-making across healthcare claims and dispute resolution workflows.ResponsibilitiesDesign, build, and maintain reporting pipelines using dbt and Snowflake, transforming raw claims and operational data into clean, modeled datasets ready for analysisDevelop and publish interactive dashboards and reports in Power BI and Omni, translating complex business questions into clear visual answersWrite performant, well-structured SQL across both Snowflake and SQL Server environmentsPartner with finance, operations, and compliance teams to define metrics, build scorecards, and deliver ad-hoc analysesOwn data quality — implement tests, validations, and monitoring to catch issues before stakeholders doDocument data models, business logic, and metric definitions so the team can scale without tribal knowledgeContribute to the evolution of our analytics stack, tooling, and engineering practicesSkills3+ years of experience in analytics engineering, BI development, or a similar data-focused roleStrong SQL skills — you can write complex queries with CTEs, window functions, and set-based logic without leaning on cursors or temp tablesHands-on experience with Snowflake (warehousing, performance tuning, schema design)Experience building and maintaining dbt models (staging, intermediate, mart layers; tests; documentation)Proficiency with Power BI (data modeling, DAX measures, report design, publishing)Experience with Omni or similar modern BI/semantic layer toolsComfort working with healthcare data concepts (claims, CPT codes, payer/provider relationships) or willingness to learn quicklyClear communicator who can explain data findings to non-technical stakeholders without jargonExperience with Claude (Anthropic's AI assistant) for accelerating analytics workflows — prompt engineering, code generation, document analysis, or building AI-augmented reporting toolsFamiliarity with MCP (Model Context Protocol) integrations or AI-assisted development environmentsBackground in healthcare dispute resolution, arbitration, or insurance claims processingExperience with Azure DevOps for version control and project managementExposure to Python for data transformation, automation, or scriptingUnderstanding of revenue cycle, regulatory reporting, or compliance analyticsBenefitsFully Remote – Work from anywhere within the United States with reliable high-speed internetMultiple medical plan optionsHealth Savings Account with company contributionsDental & vision coverage for you and your dependents401k with Company matchVacation, sick time & Company paid holidaysCompany wellbeing program with health insurance incentivesCompany OverviewExperts in Independent Dispute Resolution under The No Surprises Act and State Balance Billing Prohibition, powered by Advanced Technology It was founded in 2021, and is headquartered in Addison, Texas, USA, with a workforce of 501-1000 employees. Its website is http://www.halomd.com.