Senior Data Engineer

Health Union; Philadelphia (Philadelphia County); Hybrid; USD 95,000 - 131,000; Full time

Benefits offered by this job

Medical insurance

Dental insurance

Vision insurance

401(k) plan

Professional development budget

Paid time off

Company holidays

Summer Fridays

Personal/Family Care

Other leave

Job summary

Health Union seeks a Senior Data Engineer to design and evolve data pipelines powering our enterprise data platform. You will build robust ETL/ELT processes using Snowflake, AWS services, Python, and dbt, while ensuring data quality and compliance.

You will translate requirements into scalable data models, optimize workflows for cost and performance, and collaborate with analytics, software engineering, and product teams to deliver maintainable data solutions.

Qualifications

• 5+ years of hands-on data engineering experience with Snowflake and core AWS services.
• Strong SQL, Python, and dbt for modeling and transformation.
• Experience building reliable, tested data pipelines and QA practices.
• Understanding of data security, governance, and compliance.

Responsibilities

• Design, build, and maintain scalable data pipelines and ETL/ELT processes.
• Translate requirements into robust data models and transformations.
• Optimize workflows for performance, cost, and reliability.
• Ensure data accuracy, quality, and governance across platforms.
• Collaborate with analytics, product, and engineering teams to deliver data solutions.
• Participate in code reviews and contribute to planning and roadmap discussions.
• Advance CI/CD practices for data pipelines and automation initiatives.

Skills

Snowflake

AWS

dbt

Python

SQL

Airflow

ETL/ELT

Data Modeling

Data QC

CI/CD for Data

Tools

S3

Lambda

MWAA

Kinesis

Snowpipe

Job description

Job Details

Job Location: Philadelphia - Philadelphia, PA, Position Type: Full Time, Salary Range: Undisclosed, Job Category: Information Technology, Job Title: Senior Data Engineer

Company Overview

Health Union powers the first and largest community-based activation and data platform, transforming healthcare by providing unparalleled support, information, and validation for millions navigating complex health conditions and their care teams. With over 125+ condition-specific online communities and 15 years of community leadership, Health Union’s authentic engagements fuel the company’s robust suite of endemic media, influencer marketing, market research, and data solutions, driving proven outcomes for patients, HCPs, and brands.

Job Description

As a Senior Data Engineer, you will help build and evolve the data pipelines and platform capabilities that power our enterprise data environment. Reporting to the Senior Director of Enterprise Data Platforms and working closely with our data engineering pod leads and team members, you will design and build robust data pipelines, implement data models, and ensure the reliability, quality, and compliance of the data we deliver. You will be a hands-on senior engineer who executes against the technical direction and roadmap set by our data leadership.

What You Do:

• Design, build, and maintain scalable data pipelines and ETL/ELT processes using AWS, Snowflake, Python, and dbt, from ingestion through transformation and delivery.
• Translate functional requirements into clear technical designs and well-structured, high-quality code, complete with unit testing and documentation.
• Implement and evolve data models and transformation layers (dbt on Snowflake), following the standards and technical direction set by data leadership.
• Optimize data workflows for performance, scalability, cost, and reliability.
• Safeguard the accuracy and integrity of our data through meticulous analysis, rigorous testing, data profiling, and problem resolution.
• Support data security, governance, and privacy practices to ensure appropriate use of data and compliance with company policies.
• Partner with analytics, software engineering, product, and business stakeholders to understand data needs and deliver sound, maintainable solutions.
• Participate in code reviews and share knowledge with peers to help maintain a high bar for engineering quality.
• Contribute to quarterly and sprint planning for Data Engineering activities, and communicate progress and trade-offs clearly across project teams.
• Automate and improve aspects of our data platform to enhance efficiency and output.
• Stay current with technologies and best practices in the data engineering space, and bring ideas back to the team.

Qualifications: What You Bring:

• 5+ years of hands-on data engineering experience, with strong, recent production experience on Snowflake and core AWS data services as the primary platform, for example S3, Lambda, MWAA/Apache Airflow for orchestration, and streaming/ingestion services such as Kinesis or Snowpipe. Familiarity with a solid subset is what matters; depth over breadth.
• Working knowledge of dbt for data modeling and transformation, Python, and advanced SQL (stored procedures, analytic functions), or the demonstrated ability to ramp quickly.
• Strong command of modern data engineering and data warehousing concepts, including relational and non-relational databases, data streams, and file stores, and of performance tuning, query optimization, data profiling, and validation.
• Experience building and maintaining reliable, well-tested data pipelines, with sound QA, testing, requirements-gathering, and documentation practices.
• Experience implementing CI/CD practices for data pipelines is a plus.
• Understanding of data security, governance, and compliance principles as they apply to data platforms.
• Openness to learning and adopting AI-driven data platform practices and agentic workflows as this becomes a growing team focus; willingness to lean in matters more than extensive prior expertise.
• Strong communication and teamwork skills, with the ability to work effectively across engineering, analytics, product, and business partners.
• A self-motivated, proactive mindset, strong logical reasoning, and a love for learning, with an eagerness to keep growing your skills and take on more as opportunities arise.
• Experience in healthcare, ad tech, programmatic audiences, or related industries is a plus. Familiarity with clean-room environments/integrations and adtech partners (SSPs, DSPs) would be a plus.
• AWS and/or Snowflake certifications (e.g. AWS Certified Data Engineer Associate, SnowPro) are an advantage.

Annual base salary for positions at this level and job group is $95,000-$131,000, and your base pay will depend on the qualifications, experience, skills, and competencies required for this job.

At Health Union, base pay is one part of our total compensation package and is determined within a range that provides the opportunity to progress as you grow and develop within a role.

Benefits and Compensation

• medical insurance
• dental insurance
• vision insurance
• a 401(k) plan
• a professional development budget
• paid time off available to full-time employees upon hire
• time off for designated company-paid holidays
• summer Fridays
• Personal/Family Care
• other leaves of absence

Health Union: A Best Place to Work

As a dynamic organization that offers flexible work options, we foster a workplace that encourages an authentic, respectful culture of teaching and learning. We work hard and save space to form close-knit relationships that are meaningful to us individually. Health Union also offers top-tier benefits and other perks to full-time employees, starting day one. We cultivate a dynamic, collaborative work environment that values inclusion, community, excellence, and transparency. But don’t just take our word for it: The Philadelphia Inquirer, Philadelphia Business Journal, Inc., and Forbes have all named Health Union a “best place to work”-and we take pride in living up to that hype every day.

Commitment to Inclusion

At Health Union, we believe that individually we make a statement, but collectively we make an impact. Diversity and inclusion power that impact. We strive to create a sense of belonging by embracing our differences. We are an organization where everyone is valued, heard, and appreciated.

We are committed to equal employment opportunity and advancement regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, citizenship, marital status, disability, gender identity or gender expression, Veteran status, or any other characteristic protected by applicable law.

Health Union encourages applicants from historically marginalized populations to consider our team as your next opportunity for change.

Location and Work Arrangement

The position offers a hybrid work arrangement, requiring a minimum of two in-office days per week. Our office is located in Center City, Philadelphia.

Applicants must be legally eligible to work in the U.S for any employer.

To comply with federal law, Health Union participates in E-Verify. Successful candidates must pass the E-Verify process after hire.