betterteam
Senior Data Analyst
HaloMD
Remote, USA
Full-time
Senior · 3+ years experience
Remote
USD 100000-135000 yearly / year
Discovered 3 weeks ago
Power BISQLSnowflakeSharePoint
Key Skills for This Role
Power BISQLSnowflakeSharePoint
Full Job Posting
- 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.
- 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, preferred.
- Exposure to payor/claims data (e.g., EOBs, claim-level data, payor routing/mapping), preferred.
- Experience monitoring shared mailboxes or inboxes as a data source for operational reporting, preferred.
- Familiarity with claim resubmission or appeal deadlines and the operational risk of issues aging past them, preferred.
- Bachelor's degree preferred, but not required with equivalent professional experience.
- 3-5 years of experience in a reporting, business analyst, or operations analyst role, ideally in healthcare, revenue cycle, or claims-adjacent operations.
- Ability to manage multiple recurring reporting deliverables and shifting priorities independently
- 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.
About HaloMD
Software & SaaS800 employeesFounded 2022
Privately held healthcare technology firm helping out-of-network providers secure fair reimbursement through Independent Dispute Resolution.
Visit company websiteJobs and hiring trendsApply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at HaloMD
Senior Data Analyst or Data Analyst - Informal No Surprises Act
, USA
SeniorFull-time
Discovered 1 months agoView →
NSA Refund Compliance Supervisor
, USA
Discovered 1 months agoFull-time
Senior Data Analyst or Data Analyst - Informal No Surprises Act
, USA
Discovered 1 months agoFull-time
Client Success Manager
, USA
Discovered 1 months agoFull-time
Director, Strategic Communications
, USA
Discovered 1 months agoFull-time
Arbitration Supervisor - Formal No Suprises Act
, USA
Discovered 1 months agoFull-time
Accounts Receivable Director
Dallas, USA
Discovered 1 months agoFull-time
NSA Refund Compliance Supervisor
, USA
Discovered 1 months agoFull-time