Senior Data Engineer

Personify Health; Town of Montana (WI); On-site; USD 101,000 - 115,000; Full time

Benefits offered by this job

Competitive salary

Unlimited PTO

Comprehensive benefits

Professional development

Job summary

Personify Health in Wisconsin is seeking a Senior Data Engineer to join the analytics and reporting team. You will build data pipelines, improve data models, and mentor junior engineers while collaborating with account management, ETL, data warehouse, BI, and reporting teams to resolve issues.

The role requires deep SQL expertise, Python fluency, and experience with modern data architectures. Competitive salary and full benefits on day one.

Qualifications

• 4 years of experience in data engineering.
• SW certification or degree in IT related field.
• Deep understanding of relational and non-relational models.
• Expert in writing complex SQL with pivots, window functions, and date calculations.
• Fluent in Python programming language.
• Proficient with Excel and BI tools (Tableau, MicroStrategy, Power BI).
• Experience with REST API and JSON for data integration.
• Ability to lead and mentor junior data engineers.

Responsibilities

• Examining, extracting, cleansing, and loading data.
• Building data pipelines using SQL and other technologies.
• Triage complex bugs and incidents and resolve them.
• Perform technical operations tasks.
• Investigate data pipeline issues and optimize performance.
• Support sprint planning and estimation for data work.
• Develop and enforce data quality rules and tooling.

Skills

SQL proficiency

Python

Data modeling

Mentoring

ETL

AWS Lambda

Git

Excel/BI tools

Education

IT-related degree or IT certification

Tools

Tableau

MicroStrategy

Power BI

AWS Lambda

Git

Job description

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

What You'll Do

Senior Data Engineers perform development activities within the analytics and reporting team and provide mentorship, guidance, onboarding, and training of other Data Engineers. You will work closely with account management, ETL, data warehouse, business intelligence, and reporting teams as you develop data pipelines and enhancements and investigate and troubleshoot issues, create data models, set up and investigate new technologies, and research complex data. You have a deep understanding of data modeling, structures, and data pipelines.

Essential Functions/Responsibilities/Duties

• Examining, extracting, cleansing, and loading data.
• Building data pipelines using SQL, and other technologies.
• Triage complex incoming bugs and incidents and resolving them.
• Perform technical operation tasks.
• Investigate and troubleshoot issues with data and data pipelines.
• Participation in sprint refinement, planning, and kick-off to help estimate stories, raise awareness and additional implementation details.
• Help monitor, maintain, and improve performance of the data pipeline.
• Performing, maintaining, and implementing new quality assurance rules, methods, and tools to maintain consistent and accurate data.

Qualifications

What You Bring to Our Team

Education and Experience

• 4 years of experience in data engineering
• SW certification or degree in IT related field

Required Knowledge, Skills and Abilities

• Deep understanding of modern relational and non-relational models and differences between them.
• Expert in writing complex SQL, including pivots, window functions, and complex date calculations.
• Fluent in Python programming language.
• Proficient in the use of Excel and several analytical tools such as Tableau, MicroStrategy, PowerBI, etc...
• Expertise in the use of REST API and JSON and ability to parse that data and convert into relational models.
• Detail oriented and able to examine data and code for quality and accuracy.
• Able to lead and mentor more junior data engineers.
• Self-Starter -- taking initiative when inefficiencies or opportunities are seen.
• ETL experience preferred
• AWS Lambda / Console experience preferred
• Git experience preferred

Disclaimer

• This job description is subject to change at any time.

Benefits

The Highlights

• Competitive base salary and benefits effective day one
• Comprehensive medical and dental through our own health solutions (yes, we use what we build)
• Unlimited PTO---rest and recharge time is non-negotiable
• Mental health support, retirement planning, and financial protection
• Professional development with clear career progression and learning budgets
• Mission-driven culture where diverse perspectives drive real impact on people's health

Compensation

This position offers a base salary range of $101,000 - $115,000, depending on location, skills, and experience. You're eligible for our full benefits package starting day one.

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 [e-mail]. View all legitimate openings at personifyhealth.com/careers.