Note: The job is a remote job and is open to candidates in USA. Innovu is a growing Pittsburgh, PA-based data analytics company providing comprehensive solutions that enable advisors and their employer clients to optimize their benefits strategy, human capital risk management, and health benefit design. The role involves owning the metric build pipeline, defining metrics, writing SQL, and ensuring data reliability for healthcare analytics.
Responsibilities
- Maintain and extend existing data mart builds: claims aggregation, financial metrics, clinical metrics, and curated analytical tables that power Innovu’s SaaS platform
- Author, test, and maintain metric SQL templates against Innovu’s canonical data model (medical claims, pharmacy claims, eligibility, provider, plan design)
- Build and maintain data pipelines in Python and SQL (Redshift, PostgreSQL, S3-based integrations)
- Profile and validate third-party data feeds during vendor onboarding (new data sources land regularly)
- Investigate data quality issues from warehouse transformation logic through final output
- Produce analytical deliverables for clients and internal stakeholders (PMPM trending, cohort analysis, cost drivers)
- Write clear documentation for metric definitions, data lineage, assumptions, and known limitations
- Participate in monthly rotation for support triage (incoming tickets), release management, and mart build monitoring
- Participate in code reviews and contribute to team standards
Skills
- 3-5 years in analytics engineering, data engineering, or a quantitative analyst role where you owned metric definitions
- Strong SQL (window functions, CTEs, complex multi-table joins across large datasets; MPP warehouse experience preferred)
- Python for data work (pandas, scripting, automation, testing; not just notebooks)
- Experience building metrics from raw transactional data and validating them against business expectations
- Comfort working across the stack: you'll touch transformation logic, warehouse tables, and documentation
- Clear written communication; you'll document metrics for both engineers and business stakeholders
- Git-based development workflow; pull requests and code review
- Healthcare analytics background: medical/pharmacy claims, eligibility data, employer-sponsored health plans, or adjacent domains (insurance, benefits, actuarial)
- Familiarity with healthcare data concepts (PMPM, allowed amounts, service categories, plan design, enrollment periods)
- Experience with SQL-based transformation frameworks or structured mart build processes
- Exposure to data quality tooling or systematic data profiling
Benefits
- Mission-driven culture where your contributions have real impact
- Flexible work arrangements
- Collaborative work environment
- Growth and advancement opportunities
- Low cost medical, dental, and vision insurance
- 401(k) plan with an employer match
- Company paid life insurance, short-term disability, and long-term disability coverage
- Paid time off
- Paid parental leave
- And more!
Company Overview