Senior Data Platform Architect

HEALTH UNION LLC • Philadelphia, PA

3d • $156,000 - $170,000 • Hybrid

About The Position

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.

Position Overview: The Senior Data Platform Architect is a highly hands-on, high-impact role centered on execution and technical leadership. You will be the technical leader, translating the technical direction and designs set by our leadership into deployed, highly functional data platforms. Your primary mission is to ensure our vision for enterprise data is realized efficiently and reliably in production. To achieve this, you will design and implement scalable data solutions primarily using AWS and Snowflake, but also incorporating other tools as necessary, given our evolving data ecosystem. You will guide the Data Team and partner across the organization to deliver reliable, high-quality data platforms. This role requires exceptional coordination skills to bridge communication and execution across engineering teams, as well as with critical cross-functional partners.

Requirements

• 8+ years of experience in data engineering or data platform architecture.
• 5+ years of hands-on experience designing and evolving unified data platforms built on AWS and Snowflake, with a proven track record of consolidating complex multi-system environments into clean, maintainable architectures.
• Deep expertise across data ingestion, transformation, data modeling, and pipeline development, including relational and non-relational databases, data streams, file stores, dbt, Apache Airflow, Python, Spark, and advanced SQL.
• Strong command of performance tuning, query optimization, and the ability to define and enforce rigorous engineering standards and quality assurance processes across the platform.
• Experience implementing CI/CD practices for data pipelines and platform infrastructure.
• Understanding of data security, governance, and compliance principles as they apply to platform architecture.
• Demonstrated ability to translate data strategy into architectural designs and implementation plans, and lead technical initiatives.
• Strong communication and teamwork skills, with the ability to operate effectively across engineering, cross-functional, and leadership audiences, and elevate the engineers around you through mentorship and technical guidance.
• A self-motivated, innovative mindset to proactively identify problems, frame solutions, and drive outcomes without waiting to be directed.
• Experience with, or active exploration of, how data platform requirements evolve when AI agents and LLMs become data consumers, including implications for warehouse design, semantic layers, and tool interfaces.
• Hands-on experimentation with AI and LLM-based tooling in data platform use cases, with a track record of forming and articulating informed opinions in an emerging and fast-moving space.
• Applicants must be legally eligible to work in the U.S for any employer.

Nice To Haves

• Experience in healthcare, ad tech, programmatic audiences, or related industries is a plus.
• AWS and Snowflake certifications, such as AWS Certified Data Engineer Associate, AWS Certified Solutions Architect Professional, SnowPro Advanced: Architect, or SnowPro Advanced: Data Engineer, are a strong advantage.

Responsibilities

• Move fluidly between high-level architecture and hands-on implementation, translating data platform strategy and roadmap into clear, actionable technical designs.
• Architect and implement scalable data solutions using AWS and Snowflake, including pipelines, storage layers, and data models, designed from the ground up to serve both human consumers and AI agents.
• Ensure warehouse design, semantic layer structure, and tool interfaces are ready for LLM and agent-based access patterns as the company's AI capabilities expand.
• Design, implement, and evolve a clean, consolidated core data platform architecture across AWS, Snowflake, dbt, and integrated systems by eliminating redundancy and optimizing for performance, cost, and efficiency.
• Define authoritative standards for data ingestion, transformation, data modeling, and pipeline development, including ingestion frameworks and tooling, to deliver scalable, resilient, and efficient data movement.
• Establish and enforce data quality standards, ensuring freshness, completeness, and reliability through validation, monitoring, and observability.
• Solve complex technical challenges with innovation and proactive problem-solving, including cross-system architecture, Snowflake workload optimization, pipeline reliability, and integrating new data sources and applications into the unified platform.
• Collaborate across Data, Product, Engineering, and Business teams to deliver aligned, high-impact solutions.
• Define and promote best practices for data modeling, pipeline design, and platform architecture.
• Ensure systems meet security, governance, and compliance requirements and are production-ready.
• Mentor and guide engineers on architecture, design decisions, and engineering best practices, and translate architectural direction into actionable guidance for engineers on complex or high-leverage projects.

Benefits

• medical, dental, and 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 when needed to support your physical, financial, and emotional well-being

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed