Data Engineer II

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.

About Personify Health

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.

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.

View all legitimate openings at personifyhealth.com/careers.

Responsibilities

• Ready To Build the Data Pipelines That Keep Healthcare Operations Running at Scale?
• Bad data doesn't just slow things down — in healthcare, it affects member eligibility, claims accuracy, and client trust.
• The work is technical and precise, and the downstream impact is real.
• 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.
• Develop transformation configurations, ad-hoc reports, and automated scripts — including pivots, window functions, and complex date calculations in Microsoft SQL Server.
• Track execution, identify failures, and work collaboratively to fix problems before they reach clients or downstream systems.
• Build and enforce quality controls that keep data consistent and accurate across the pipeline from source to destination.
• Analyze incoming data sources, parse flat file structures and EDI X12 formats, and document findings to support integration and ongoing operations.
• Move data transformation logic and pipeline architecture from legacy systems to modern stacks — maintaining fidelity and functionality through the transition.

Requirements

• 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
• 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.

Preferred

• Git experience preferred

Benefits

• 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].