Senior Business and Data Analyst

About Us

Abacus Insights is transforming how data and AI work for health plans. Our mission is simple: make healthcare data usable, so the people responsible for care and cost decisions can act faster, with confidence.

As the AI and Data Platform for Payer Intelligence, we help health plans break down data silos to create a single, trusted data foundation. That foundation powers better decisions—so plans can improve outcomes, reduce waste, and deliver better experiences for members and providers alike. Backed by $100M from top investors, we're tackling big challenges in an industry that's ready for change. Our platform enables GenAI use cases by delivering clean, connected, and reliable healthcare data to support automation, prioritization, and decision workflows—and it's why we are leading the way.

Our innovation begins with people. We are bold, curious, and collaborative—because the best ideas come from working together. We embrace the thoughtful use of AI and automation to drive innovation and efficiency, and we look for individuals who are curious and adaptable—those excited to leverage emerging technologies to enhance how we work—while keeping human insight, connection, and our clients at the center of every decision.

Ready to make an impact? Join us and let's build the future together.

About the Role

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.

Your day to day

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.

Drive Requirements and Design for Your Use Cases

• Lead discovery sessions for your use cases, and support broader engagement-level sessions alongside the Business Solution Manager, to understand the why and what behind each use case: the business context, pain points, expected outcomes, and success criteria, rather than just the surface-level data ask.

• Translate each use case into clear, testable requirements, including success criteria and non-functional requirements, and maintain traceability from business need to requirement to design to test.

• Use data analysis to sharpen and challenge requirements: confirm that what the client is asking for is supported by the data they have, and surface gaps early.

• Document source-to-target mappings, transformation logic, and business rules that developers can build from, and define the test conditions and expected results QA will use to validate them.

• Recommend the appropriate grain and structure of a dataset given the business context, and analyze how that grain decision ripples into the downstream reports, models, or programs that consume the data.

• Identify dependencies before a design is finalized: which other workstreams, reports, or client use cases touch this same data, and how a change here could break or benefit them, escalating cross-workstream impacts to the Business Solution Manager.

• Apply systems thinking: recognize when a design built for one client, state, or use case can become a reusable pattern, and raise and shape that reuse rather than discovering it in hindsight.

Be a Trusted Client-Facing Partner

• Drive requirements-gathering and clarification conversations with client SMEs for your use cases, since incomplete or poorly elicited requirements undermine everything built downstream.

• Present analysis results, data quality findings, and recommendations to client stakeholders with clarity and confidence, and guide decisions with evidence.

• Represent client intent for your use cases through delivery and serve as a day-to-day point of contact, with the Business Solution Manager owning the overall client relationship.

• Translate fluently between business and technical audiences, so both sides share the same understanding.

Collaborate Across Delivery

• Connect the client and the internal team on your workstreams, holding the business context, data findings, and design drivers that shape the build.

• Act as the business and data analysis SME for Solution Architects, Product, QA, Account Management, and Program Management, giving them clean hand-offs with the context, business rules, and analysis they need to execute without rework or reinterpretation.

• Support QA and UAT by supplying validation queries, expected results, and variance analysis, and by helping triage defects to business rule, mapping, or source data causes.

• Maintain awareness of the wider engagement: understand how a decision made for one workstream affects the others, and flag those ripple effects before they surface as rework.

What you bring to the team

• Bachelor's degree, or equivalent relevant experience.

• 5+ years working in the US healthcare domain and with healthcare data (claims, provider, membership/eligibility, benefits, prior authorization, or PBM).

• Payer experience required: direct experience working with or for a US health plan (Medicare, Medicaid, or Commercial), whether in-house or through healthcare consulting.

• Working command of core payer concepts such as membership/enrollment, provider, claims, and autho