Data Engineer II

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 That Keep Healthcare Operations Running at Scale?

Why This Role Matters

Bad data doesn't just slow things down — in healthcare, it affects member eligibility, claims accuracy, and client trust. As a Data Engineer on the TPA DataOps team, you build and maintain the pipelines, transformations, and quality checks that keep data moving accurately across clients, vendors, and internal systems. The work is technical and precise, and the downstream impact is real.

What You'll Actually Do

Build and maintain data pipelines: Design and implement pipelines using SQL, Kafka, and related technologies — extracting, cleansing, and loading data across systems with accuracy and scale in mind.

Write and automate complex SQL: Develop transformation configurations, ad-hoc reports, and automated scripts — including pivots, window functions, and complex date calculations in Microsoft SQL Server.

Monitor pipeline performance and resolve issues: Track execution, identify failures, and work collaboratively to fix problems before they reach clients or downstream systems.

Implement data quality checks: Build and enforce quality controls that keep data consistent and accurate across the pipeline from source to destination.

Investigate and document new data sets: Analyze incoming data sources, parse flat file structures and EDI X12 formats, and document findings to support integration and ongoing operations.

Translate across tech stacks: Move data transformation logic and pipeline architecture from legacy systems to modern stacks — maintaining fidelity and functionality through the transition.

Qualifications

What You Bring to Our Team

Education & Experience

• 4+ years of experience in data engineering
• Degree or certification in IT, Computer Science, or a related field
• ETL experience preferred
• Git experience preferred

Technical Skills

• Expert-level SQL in Microsoft SQL Server, including pivots, window functions, and complex date calculations
• Strong expertise in Microsoft SQL Server Management Studio
• SSIS package builds through Visual Studio
• Proficiency in EDI X12 formats related to healthcare claims processing
• Expert ability to analyze and parse flat file data structures
• Familiarity with API usage for healthcare data integration including data parsing and conversion
• Familiarity with EFT file movement principles, tools, and encryption
• Solid understanding of modern relational and non-relational data models
• Proficiency in Excel and familiarity with analytical tools including Tableau, MicroStrategy, and Power BI

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 talent@personifyhealth.com. View all legitimate openings at personifyhealth.com/careers.