Senior Data Analyst – Claims Reconciliation
Role Type: Senior Data Analyst
Duration: 5+ months
Location: U.S.-based; candidates must be available for meetings between 8:00 a.m. and 5:00 p.m. Eastern Time.
Position Summary
We are seeking a Senior Data Analyst to support the development of a Claims Reconciliation Hub. This role will focus on defining and analyzing matching criteria between pre-service member- and provider-facing cost estimates and actual medical claims submitted and adjudicated across multiple lines of business.
The ideal candidate brings extensive healthcare claims data experience, strong Snowflake and data warehousing capabilities, and a working knowledge of health plan claims processing. This individual will partner closely with business analytics stakeholders to identify relevant data sources, interpret complex claims data elements, trace claim activity through the adjudication lifecycle, and uncover patterns that support accurate estimate-to-claim matching.
Key Responsibilities
- Support the Reconciliation Hub initiative by defining matching criteria between pre-service estimates and final adjudicated medical claims.
- Analyze claims data across major healthcare platforms to identify patterns, relationships, and reconciliation opportunities.
- Trace claims from initial receipt and pre-adjudication through final adjudication, payment, and reporting.
- Partner with business analytics teams to identify the appropriate data tables, attributes, identifiers, and source-system relationships needed for reconciliation analysis.
- Explain and document how key membership, provider, benefit, pricing, and claims-processing data elements should be interpreted and applied.
- Analyze claim changes occurring throughout the processing lifecycle, including edits, benefit determination, prior authorization matching, documentation requests, contract-based pricing, accumulators, and payment batching.
- Develop insights that improve the ability to match member- and provider-facing estimates with actual submitted and adjudicated claims.
- Perform data exploration and analysis using Snowflake and enterprise healthcare data warehouse assets.
- Document data logic, source-to-target relationships, matching rules, assumptions, findings, and identified data gaps.
- Communicate complex analytical findings clearly to technical and nontechnical stakeholders.
- Support reconciliation design across multiple lines of business and healthcare claims platforms.