Staff Data Platform Architect

HEALTH UNION LLC • Philadelphia, PA

1d • $125,000 - $140,000 • Hybrid

About The Position

The Staff 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 supporting advanced analytics, machine learning, and AI use cases, with enthusiasm for adopting AI tools across the development lifecycle and user-facing solutions.

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 for analytics, operational, and AI enablement use cases.
• 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: Mid Level
• Education Level: No Education Listed
• Number of Employees: 101-250 employees