Analytics Engineer

Who We Are:

HaloMD specializes in Independent Dispute Resolution (IDR) through The No Surprises Act and state regulations for out-of-network healthcare providers, leveraging advanced technology and deep industry expertise to secure optimized reimbursements.

Job Summary

We're looking for an Analytics / Reporting Engineer to join our Enterprise Reporting team. You'll build and maintain the data pipelines, dashboards, and reporting infrastructure that drive decision-making across healthcare claims, arbitration, and dispute resolution workflows. This is a hands-on role — you'll write SQL, build models, design reports, and work directly with stakeholders who depend on accurate, timely data.

Essential Job Duties and Responsibilities

• Design, build, and maintain reporting pipelines using dbt and Snowflake, transforming raw claims and operational data into clean, modeled datasets ready for analysis
• Develop and publish interactive dashboards and reports in Power BI and Omni, translating complex business questions into clear visual answers
• Write performant, well-structured SQL across both Snowflake and SQL Server environments
• Partner with finance, operations, and compliance teams to define metrics, build scorecards, and deliver ad-hoc analyses
• Own data quality — implement tests, validations, and monitoring to catch issues before stakeholders do
• Document data models, business logic, and metric definitions so the team can scale without tribal knowledge
• Contribute to the evolution of our analytics stack, tooling, and engineering practices

Education and/or Experience

• 3+ years of experience in analytics engineering, BI development, or a similar data-focused role
• Strong SQL skills — you can write complex queries with CTEs, window functions, and set-based logic without leaning on cursors or temp tables
• Hands-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 tools
• Comfort working with healthcare data concepts (claims, CPT codes, payer/provider relationships) or willingness to learn quickly
• Clear communicator who can explain data findings to non-technical stakeholders without jargon

Preferred

• Experience with Claude (Anthropic's AI assistant) for accelerating analytics workflows — prompt engineering, code generation, document analysis, or building AI-augmented reporting tools
• Familiarity with MCP (Model Context Protocol) integrations or AI-assisted development environments
• Background in healthcare dispute resolution, arbitration, or insurance claims processing
• Experience with Azure DevOps for version control and project management
• Exposure to Python for data transformation, automation, or scripting
• Understanding of revenue cycle, regulatory reporting, or compliance analytics

What You'll Work With

• Data Warehouse: Snowflake (CORE.REPORTING schema and related layers)
• Databases: SQL Server (multiple environments)
• Modeling: dbt (Cloud or Core)
• BI & Visualization: Power BI, Omni
• AI Tooling: Claude Desktop, Claude Code, MCP server integrations
• Project Management: Azure DevOps
• Domain: No Surprises Act (NSA), Independent Dispute Resolution (IDR), healthcare claims analytics

Why This Role

You won't be maintaining dashboards someone else designed three years ago. You'll be building the reporting infrastructure for a fast-moving healthcare analytics operation, working with modern tools, and integrating AI into real workflows — not as a gimmick, but as a daily productivity multiplier. If you like solving hard data problems and shipping things that people actually use, this is the role.

Perks & Benefits:

• Fully Remote – Work from anywhere within the United States with reliable high-speed internet
• Multiple medical plan options
• Health Savings Account with company contributions
• Dental & vision coverage for you and your dependents
• 401k with Company match
• Vacation, sick time & Company paid holidays
• Company wellbeing program with health insurance incentives