Senior Business and Data Analyst

Abacus Insights; United States; On-site; USD 90,000 - 150,000; Full time

Benefits offered by this job

401k plan

Unlimited vacation

Ownership stake

Health insurance

Team events

Job summary

Abacus Insights is seeking an experienced Business and Data Analyst to bridge client needs and data solutions in the US healthcare space. You will translate complex healthcare questions into testable requirements, profile and validate data, and draft design specs grounded in evidence.

You will work with Business Solution Managers who own the broader engagement. You'll translate findings into actionable recommendations, write SQL daily to profile data, and quantify data quality.

Qualifications

• 5+ years in business/data analysis within US healthcare environments.
• Proven ability to translate business needs into rigorous data requirements.
• Experience profiling data quality and validating data-driven findings.
• Strong SQL skills and experience with BI/Visualization tools.

Responsibilities

• Translate use cases into clear, testable requirements with success criteria.
• Document mappings, transformation logic, and business rules for build teams.
• Lead discovery sessions and ensure traceability from needs to design.
• Present analyses and data quality findings to stakeholders with confidence.
• Write and execute SQL to profile data and prototype logic before build.

Skills

SQL proficiency

Data profiling

Requirements gathering

Stakeholder communication

Healthcare domain knowledge

Education

Bachelor's degree or equivalent

Tools

Databricks

Snowflake

Job description

• 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
• 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

Benefits

• 401k: Save for your retirement with confidence, leveraging our company-sponsored plan
• Vacation: Recharge with unlimited paid time off
• Ownership: Become not only an employee but an owner of a company on a mission to imrpvoe healthcare
• Health Insurance: From Day 1, maintain peace of mind with our healthcare insurance coverage for you and your family
• Fun: Bond with your fellow teammates during company-sponsored social events

Responsibilities and Qualifications

• 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
• 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
• 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
• 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
• 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
• 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
• Present analysis results, data quality findings, and recommendations to client stakeholders with clarity and confidence, and guide decisions with evidence
• Drive requirements-gathering and clarification conversations with client SMEs for your use cases, since incomplete or poorly elicited requirements undermine everything built downstream
• Translate fluently between business and technical audiences, so both sides share the same understanding
• 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
• 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
• 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
• 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
• Strong, hands-on SQL: comfortable with joins across large, multi-table datasets, window functions, CTEs, aggregations, and date/span logic, used regularly to profile, validate, reconcile, and analyze data. Exposure to Databricks or Snowflake is desirable. This is distinct from a software or data engineering background
• Confident client-facing communication; able to drive a conversation, elicit requirements clearly, and present analytical findings to technical and non-technical audiences
• 5+ years working in the US healthcare domain and with healthcare data (claims, provider, membership/eligibility, benefits, prior authorization, or PBM)
• Experience defining metrics, mentoring junior analysts, and eliciting and authoring business requirements in complex, data-driven environments
• Demonstrated analytical rigor: a track record of profiling data, assessing data quality, investigating anomalies to root cause, and communicating quantified findings that drove a decision
• Comfort operating with ambiguity and re-prioritizing frequently while managing multiple use cases within a larger engagement
• Bachelor’s degree, or equivalent relevant experience
• 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 authorizations, enough to reason about business context rather than specialize narrowly in any one area
• Developing systems thinking: experience designing for reuse and scale across states, clients, or use cases rather than solving each case in isolation, and the ability to trace how a requirement or data model decision affects other parts of a larger data ecosystem
• Background that already blends business analysis with hands-on data work, such as a Business Analyst, Data Analyst, or Business Data Analyst role, with exposure to client-facing delivery
• Experience with BI and visualization tools (e.g., Tableau, Power BI, or similar) to communicate analysis
• Familiarity with HEDIS and Stars quality reporting, risk adjustment, payment integrity, value-based care analytics, provider data management, or CMS interoperability (CMS-0057)
• Working knowledge of data modeling concepts, including how the grain and structure of a dataset shape its downstream use
• Familiarity with Python or similar for analysis and automation
• Familiarity with Medicaid data or PBM platforms