Data Engineer - Analytics

Overview

Who We Are

Because health is personal. That's why Personify Health created the first and only personalized health platform—bringing health plan administration, holistic wellbeing solutions, and comprehensive care navigation together in one place. We serve employers, health plans, and health systems with data-driven solutions that reduce costs while actually improving health outcomes. Together, our team is on a mission to empower people to lead healthier lives.

Learn even more about the work that drives us at personifyhealth.com.

Responsibilities

Ready To Build the Data Pipelines and Models That Power Analytics Across a Complex Healthcare TPA Platform?

Why This Role Matters

Healthcare TPA data is messy, high-stakes, and consequential — claims, enrollment, provider, and finance data that has to be accurate, timely, and compliant before it can power any meaningful analytics. This role designs and builds the pipelines, data models, and infrastructure that make that possible for the Enterprise Reporting and Analytics team. You work end-to-end: from ingestion through transformation, stakeholder collaboration, and automated reporting — owning projects from start to finish.

What You'll Actually Do

Design and build scalable ETL/ELT pipelines: Develop pipelines that ingest and transform data from claims, enrollment, provider, finance, and other sources into analytics-ready formats.

Build data models and data marts: Partner with Data Analysts, Data Scientists, and business stakeholders to implement dimensional models and data marts that support BI, reporting, and machine learning initiatives.

Ensure data quality and integrity: Build automated validation, auditing, and monitoring processes that catch data issues before they reach stakeholders.

Optimize warehouse infrastructure: Maintain and improve the enterprise analytics data warehouse — tuning pipeline and compute performance and managing storage efficiency.

Support data integration projects: Manage data exchanges with clients, carriers, vendors, and regulatory bodies — ensuring accuracy, timeliness, and compliance with healthcare regulations.

Write production SQL and Python: Develop SQL and Python programs to access, clean, and transform data prior to analysis and reporting.

Build reporting automation: Develop automation solutions for operational workflows and reporting that reduce manual effort and improve consistency.

Conduct ad hoc analysis: Support cross-functional partners in Product, Reporting, Analytics, and Account Management with targeted data analysis and findings communicated in formats aligned to client reporting standards.

Manage project workflows: Use Smartsheet, Microsoft, and Atlassian toolsets to keep projects, milestones, and documentation organized and on schedule.

Qualifications

What You Bring to Our Team

Education & Experience

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field — or equivalent experience; advanced degree a plus
• 3+ years of experience in data engineering or analytics engineering, ideally within a TPA, healthcare, insurance, or claims processing environment
• Experience working with large healthcare claims datasets including medical, pharmacy, and dental claims
• Awareness of healthcare regulations including HIPAA, ACA, and CMS rules
• Knowledge of TPA operations, self-funded insurance models, and employer-sponsored health plans a plus
• Knowledge of population health analytics and clinical care management programs a plus

Technical Skills

• Strong SQL proficiency and experience in Python, Scala, or Java
• Hands-on experience with modern data warehouse platforms: Snowflake, Redshift, BigQuery, or Synapse
• Experience with cloud platforms and cloud-native data tools: AWS Glue, Azure Data Factory, Databricks, or equivalent
• Experience with data modeling concepts including star and snowflake schemas and dimensional modeling
• Experience with BI and dashboard/visualization tools
• Familiarity with Smartsheet, Microsoft Office Suite, and Atlassian toolsets for project and documentation management

Our Commitment: Personify Health is an equal opportunity employer committed to diversity, equity, inclusion, and belonging. We cultivate a work environment where differences are celebrated, and employees of all backgrounds are empowered to thrive—because diversity is core to who we are and critical to our work in health and wellbeing.

Stay Safe: Personify Health will never ask for payment or sensitive personal information like social security numbers during hiring. All official communication comes from verified company email addresses and or our secure applicant tracking system. Suspicious requests? Report them to [email protected]. View all legitimate openings at personifyhealth.com/careers.