Senior Data Engineer

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

Benefits offered by this job

Health insurance

401(k) plan

Professional development budget

Paid time off

Job summary

Health Union LLC in Philadelphia, PA seeks a Senior Data Engineer to design and evolve data pipelines powering our enterprise data platform. You will implement data models, ensure reliability and compliance, and work with analytics, software engineering, and product teams.

The role emphasizes hands-on work with Snowflake, AWS services, dbt, Python, and advanced SQL, plus performance tuning, testing, and data governance. Hybrid schedule with two in-office days per week is offered.

Qualifications

• 5+ years of hands-on data engineering experience with Snowflake and AWS data services.
• Strong Python and advanced SQL skills, with knowledge of dbt and data modeling.
• Experience building reliable, well-tested data pipelines with QA and documentation.

Responsibilities

• Design, build, and maintain scalable data pipelines and ETL/ELT processes using AWS, Snowflake, Python, and dbt.
• Translate requirements into clear technical designs and high-quality, tested code.
• Optimize data models and transformation layers, ensure data quality, security, and governance.

Skills

Snowflake

AWS

Python

SQL

Data pipelines

Tools

dbt

Airflow

Kinesis

Job description

Job Title: Senior Data Engineer

Location: Philadelphia, PA (Center City)

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.

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.

Strong hands‑on expertise with Snowflake and core AWS data services is essential. Experience with dbt, Python, and advanced SQL is highly valued, along with solid performance‑tuning, optimization, and data‑validation skills.

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 you r 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.

In addition, our Total Rewards package includes medical, dental, and vision insurance, a 401(k) plan, a professional development budget, and paid time off available to full‑time employees upon hire. You will also be granted time off for designated company‑paid holidays, summer Fridays, Personal/Family Care, and other leaves of absence when needed to support your physical, financial, and emotional well‑being.

HEALTH UNION REALLY IS THE 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. Health Union encourages applicants from historically marginalized populations to consider our team as your next opportunity for change. 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.

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

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.