Abacusinsights The Senior Business and Data Analyst at Abacus Insights translates healthcare business needs into precise data solutions. This client-facing role uses SQL and analytical skills to validate assumptions and shape data designs.
Responsibilities
We are seeking an experienced Business and Data Analyst to join our team. In this role, you'll be the analytical engine between a client's business need and the data solution that delivers it. You'll turn business questions into precise, testable requirements, then use the data itself to prove out what's possible: profiling sources, validating assumptions, and shaping designs that are clean, buildable, and grounded in evidence rather than opinion. You'll own the requirements and analysis for your use cases and workstreams, working in close partnership with Business Solution Managers who hold the broader engagement.
Doing that well takes two things at once: command of healthcare business context, and deep, hands-on fluency in the data. This is a client-facing role. You'll translate complex healthcare challenges into rigorous requirements, and you'll use SQL and analytical judgment to show clients and delivery teams what the data actually says, where it falls short, and what that means for the design.
No engagement lives in isolation. A data model built for one client's use case can share structure with a completely different client's need; a transformation rule written for one state's requirements often anticipates the next state's. You'll learn to see each requirement as part of a larger system of clients, states, use cases, and data flows, and to flag where a design can be reused or where it could collide with other work.
Our clients are US health plans and the partners who serve them, and the engagements span everything it takes to make their data usable. That can mean standardizing and migrating data onto a new platform, meeting evolving regulatory and compliance mandates, or powering the broader analytics and reporting programs that drive payer performance across Medicare, Medicaid, and Commercial lines of business.
Note: This role is based in the US and requires current authorization to work in the United States without the need for employer sponsorship.
Analyze the Data and Build the Evidence
Write and execute SQL daily to profile source data, test assumptions, quantify data quality (completeness, validity, uniqueness, consistency, timeliness), and prototype logic before it reaches the build team.
Analyze source data to establish what is actually available and reliable: field population and distributions, key integrity, duplicates, outliers, and gaps against what the business use case needs.
Reconcile and validate outputs against source systems and client-provided benchmarks (claim counts, member months, paid amounts, enrollment spans, provider rosters), investigating variances to root cause and documenting findings.
Define and document business metrics and KPIs precisely: numerator, denominator, inclusion and exclusion logic, time basis, and grain, so every consumer of the data calculates and reads them the same way.
Perform exploratory and root-cause analysis on client questions and data anomalies, and turn findings into clear, quantified recommendations for client and internal audiences.
Summarize findings through data profiling reports, analysis readouts, and visualizations that make the story clear to non-technical stakeholders.