Senior Data Analyst

HaloMD; Dallas (TX); On-site; USD 90,000 - 130,000; Full time

Job summary

HaloMD is seeking a Senior Data Analyst for NSA Informal Operations to support Open Negotiation Notices, Payor Mapping and Settlements. You will build dashboards, investigate data discrepancies, and partner with multiple teams to surface trends and ensure timely, accurate insights.

You will design scalable reporting and work with IT/data teams to improve data quality and inform capacity planning across ONN, Payor Mapping, and Payor Responses.

Qualifications

• Proficient in advanced Excel features and data modeling.
• Experience building dashboards and reports in BI tools.
• StrongSQL querying and data warehouse understanding (Snowflake preferred).
• Analytical skills to identify trends and anomalies in operational data.

Responsibilities

• Design, build, and maintain dashboards and reports tracking task volume, aging, throughput, and capacity across NSA processes.
• Investigate data discrepancies to determine root causes and inform decisions.
• Identify recurring issues and surface emerging trends to leadership.
• Support capacity planning and staffing models using historical data.
• Document reporting logic and data definitions for continuity.

Skills

Advanced Excel

Analytical thinking

Communication

Adaptability

Cross-team coordination

Attention to detail

NSA/IDR knowledge

Tools

Power BI

SQL

Snowflake

SharePoint Lists

Job description

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 are seeking a Senior Data Analyst, NSA Informal Operations to support Open Negotiation Notice (ONN), Payor Mapping, Payor Responses, and Settlements. This role investigates flagged data and timing discrepancies to establish root cause, builds and maintains dashboards and reports tracking task volume and turnaround, and surfaces trends before they become operational issues. Priorities are set through a shared intake process reflecting impact and urgency across teams, not by a single manager. The ideal candidate combines strong analytical instincts with hands-on reporting skills and is comfortable coordinating with multiple teams and stakeholders to close the loop on what was found.

Essential Job Duties and Responsibilities:

• Design, build, and maintain dashboards and reports tracking task volume, aging, throughput, and team capacity across ONN, Payor Mapping, Payor Responses, and Settlements.
• Dig into flagged data and timing discrepancies (e.g., CPT code mismatches, EOB/ingestion date misalignment, missing or duplicated claim data) to establish root cause before a decision can be made.
• Identify the pattern behind recurring issues rather than resolving them one at a time, surfacing emerging trends to team leadership before they become operational risk.
• Support root-cause analysis connecting issue trends back to source systems (Arbit, payor remittance data, shared inbox activity) using historical claims and inbox data.
• Monitor the Payor Mapping inbox and other shared queues to identify incoming volume patterns, payor-specific trends, and recurring issue types.
• Build monitoring tools giving leadership real-time or near-real-time visibility into task volume, queue depth, and staffing utilization.
• Partner with Team Leads and Supervisors to validate that reported data matches on-the-ground operational reality.
• Support capacity planning by modeling projected volume against current throughput and staffing levels.
• Support Settlement Tracker and other data integrity reviews, including surfacing QA flags not currently visible in standard views.
• Communicate findings back to both the ONN/Payor Mapping and Payor Responses/Settlements teams so root cause and resolution are shared rather than siloed.
• Own cross-department escalations end to end, including issues that root-cause into IT, Formal Operations, Client Success, or Shared Services systems, staying on them through to resolution rather than handing them off.
• Increase visibility into issue status and impact so leadership is not manually pulling it together to understand where things stand.
• Work with Team Leads and Directors to prioritize reporting and investigation needs based on impact and urgency.
• Partner with IT/Data teams on data quality, source-of-truth issues, and automation opportunities.
• Support broader NSA/IDR initiatives (e.g., regulatory changes) by modeling anticipated volume or workflow impacts.
• Support the Payor MDM design and build effort as a data quality stakeholder.
• Document reporting logic, data definitions, and dashboard maintenance procedures for team continuity.

Skills/Specialized Knowledge:

• Advanced Excel skills, including pivot tables and formulas.
• Experience building dashboards or reports in Power BI (or a comparable BI tool).
• Experience writing SQL queries or working in Snowflake (or a similar cloud data warehouse), preferred, to support ad hoc reporting requests.
• Strong analytical skills with the ability to identify trends and anomalies in operational data.
• Excellent written and verbal communication skills, with the ability to summarize data for non-technical audiences.
• High attention to detail and comfort working with large, sometimes messy datasets.
• Comfort navigating ambiguity and coordinating across multiple teams and stakeholders, since priorities are set through a shared intake process rather than a single reporting line.
• Familiarity with the No Surprises Act (NSA), IDR (Independent Dispute Resolution), or healthcare payor/claims operations, preferred.
• Experience working with SharePoint Lists or similar structured tracking tools,