Rightway
Analytics Engineer
New York, NY or Remote
Sponsorship not specifiedDetected 7 days ago
PythonSQLSnowflakeRedshiftAWSCloud PlatformsMachine LearningdbtFinancial AnalysisForecastingProblem SolvingPublic SpeakingActuarial ScienceUnderwriting
About the role
- This role is ideal for someone who is strong in dbt and analytics engineering and who enjoys working at the intersection of healthcare economics, PBM operations and data modeling.
- Apply hands on analytics and data expertise to solve complex, fast moving financial and operational problems using PBM data.
- 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.
Responsibilities
- 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).
- 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.
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 modeling large scale claims data and translating contractual or financial rules into clear, testable data logic.
- Ability to understand, tackle, and solve problems from both technical and business perspectives.
Nice to have
- 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.
Skills
- Experience in cloud platforms (preferably in AWS) and hands-on experience in cloud data warehouses (Redshift or Snowflake).
- Strong analytical and problem-solving skills.
Compensation
- $140,000 annually, in addition to bonus and equity
- Compensation offered will be determined by geographic location, experience, and qualifications.
Benefits
- Rightway is on a mission to harmonize healthcare for everyone, everywhere.
- Our clients rely on us to transform the healthcare experience, improve outcomes for their teams, and decrease their healthcare costs.
- We're seeking those with passion for healthcare and relentless devotion to our goal.
Apply directly at Rightway →Create a free account for alerts like thisView Rightway immigration profile
This listing is sourced directly from Rightway's careers page and normalized into a canonical job model.