Senior Data Engineer

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.