The Senior Data Analyst will support the development of a Claims Reconciliation Hub by defining matching criteria between pre-service estimates and actual medical claims. They will analyze complex claims data across multiple platforms to identify patterns, relationships, and reconciliation opportunities.
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.
Required Qualifications
5+ years of experience as a Data Analyst supporting data warehousing, enterprise data, and healthcare data initiatives.
3+ years of internal experience analyzing healthcare claims data and core healthcare data assets, including enterprise data warehouse environments such as UDW.
Experience working with healthcare claims platforms, including CSP Facets, UNET, COSMOS, and USP.
Strong understanding of medical claims coding, billing, processing, adjudication, and payment workflows.
Familiarity with member, subscriber, provider, and plan identifiers and their use across claims data.
Knowledge of core claims processing capabilities, including:
Benefit determination
Claims editing
Prior authorization matching
Documentation or medical-record requests
Contract-based pricing
Deductible and out-of-pocket accumulators
Payment and batching processes
Experience using Snowflake for data analysis, data exploration, and querying healthcare data.
Strong analytical and problem-solving skills, with the ability to identify patterns across complex claims-processing data.
Excellent communication, collaboration, and stakeholder-management skills.
Ability to work independently and effectively in a fast-paced, dynamic project environment.
Must be U.S.-based and available for meetings between 8:00 a.m. and 5:00 p.m. ET.
Preferred Qualifications
Experience using AI/ML tools, models, or analytical techniques to support data analysis, pattern identification, reconciliation, or healthcare analytics.
Experience supporting healthcare cost-estimation, price-transparency, member financial responsibility, or claims reconciliation initiatives.
Experience designing or documenting data-matching logic, reconciliation rules, or cross-platform data lineage.
“I was the first applicant for a remote marketing position that got listed on the company website the same day I applied. Had an interview within 48 hours!”
— Sarah J.
·
Marketing Manager
★★★★★
Verified
