Apply hands on analytics and data expertise to solve complex, fast moving financial and operational problems using PBM data.
Design, develop and maintain scalable, analytics ready data models (primarily in dbt) that power a PBM financial risk engine, leveraging claims, eligibility, pricing, rebates, guarantees and contract data in our Unified Data Warehouse (UDW).
Translate complex PBM contract and pricing structures (e.g plan paid vs. member paid, rebates, guarantees, caps, fees, exclusions) into transparent, auditable data models that enable financial analysis and risk assessment.
Partner closely with underwriting, finance, client success and PBM operations teams to understand financial assumptions, risk drivers and reporting requirements and convert them into reliable metrics and models.
Build curated financial and risk data marts and semantic layers that enable self service analysis for forecasting, scenario modeling and executive reporting among other things.
Own core financial KPIs and risk metrics E2E from raw claims and contract inputs through production grade models, ensuring consistency and traceability.
Implement automated data quality checks, reconciliations and controls to validate financial outputs and ensure alignment with source systems and contractual logic.
Continuously optimize data models and warehouse performance to support large scale claims volumes and time-sensitive financial analysis.
Contribute to data governance by establishing modeling standards, documentation and guardrails that support auditability, explainability and long term maintainability.
Communicate complex financial insights clearly through data memos, documentation and presentations for both technical and non technical stakeholders.
Explore advanced analytics and predictive modeling use cases (e.g utilization forecasting, trend analysis, risk stratification, margin sensitivity) to enhance financial planning and decision making. Experience operationalizing ML models is a plus.

Requirements

Expert level proficiency in SQL and statistical programming (Python, R).
3 to 4 years working experience with data modeling, dbt and analytics engineering best practices (testing, documentation, incremental models, semantic layers).
Experience in cloud platforms (preferably in AWS) and hands-on experience in cloud data warehouses (Redshift or Snowflake).
Business acumen with exposure to PBM, healthcare finance, underwriting or actuarial concepts.
Experience modeling large scale claims data and translating contractual or financial rules into clear, testable data logic.
Strong analytical and problem-solving skills.
Ability to understand, tackle, and solve problems from both technical and business perspectives.
Comfortable partnering closely with finance, underwriting and operations stakeholders to align data models with real world financial decisions.
High attention to detail and a bias toward accuracy, transparency and explainability in financial reporting.

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

SQLPythonRdata modelingdbtanalytics engineeringcloud platformsRedshiftSnowflakepredictive modeling

Soft Skills

analytical skillsproblem-solving skillsbusiness acumenattention to detailcommunication skillscollaborationtransparencyexplainability