Analytics Engineer

Innovu

Analytics Engineer at Innovu maintaining and extending data mart builds and SQL templates. Focused on data reliability and transforming healthcare data for analytics.

Posted 6/5/2026full-timeRemote • Pennsylvania • 🇺🇸 United StatesMid-LevelSenior💰 $90,000 - $100,000 per yearWebsite

Tech Stack

Tools & technologies

Amazon RedshiftPandasPostgresPythonSQL

About the role

Key responsibilities & impact

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

Requirements

What you’ll need

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

Benefits

Comp & perks

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
Mission-driven culture where your contributions have real impact
Flexible work arrangements
Collaborative work environment
Growth and advancement opportunities

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

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

Hard Skills & Tools

SQLPythondata pipelinesdata validationdata profilinganalytical deliverablesmetric definitionsdata transformationpandasMPP warehouse

Soft Skills

clear written communicationteam collaborationproblem-solvingattention to detaildocumentation skills