Analytics Engineer

Innovu, LLC • Pittsburgh, PA

7h • Hybrid

About The Position

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. Innovu is building a semantic layer that makes our healthcare data platform queryable through structured, trustworthy metric definitions. We need someone who can own the metric build pipeline: define what a metric means, write the SQL that produces it, validate it against real claims data, and document it clearly enough that a machine or a human can trust the result. This is not a modeling or ML role. The work is precise, methodical, and high-leverage: you are building the measurement layer that everything else depends on. If you like making data reliable and correct more than making it flashy, this is your role.

Requirements

• 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

Nice To Haves

• 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
• Experience with AI-assisted development tools (Claude Code, Copilot, or similar)
• Familiarity with Parquet, Iceberg, or lakehouse file formats
• Statistical literacy (can interpret a regression, knows when a sample size is too small, understands variance)
• Visualization experience (Tableau, Looker, or similar)

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

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed