Responsibilities

• Data architecture and modeling: Design data models, schemas, and identity strategies that connect raw data to clear business and marketing outcomes.
• Pipelines and transformation: Build and maintain ETL and ELT pipelines and transformations into cloud warehouses using modern patterns and tooling.
• Platform integrations: Integrate warehouses, CDPs, CRM and marketing systems, messaging platforms, analytics tools, and media data sources.
• Activation and Reverse ETL: Configure audience, scoring, and lifecycle signal flows from warehouses into operational tools using Reverse ETL and activation patterns.
• Attribution and measurement: Build attribution structures, UTM frameworks, and campaign tracking that give a trusted view of performance.
• Data for AI and automation: Shape and prepare data for AI-powered use cases such as agents, automations, analytics assistants, and RAG-style workflows.
• Quality, reliability, and enablement: Test, monitor, document, and improve data systems so they are reliable, scalable, and easy for clients to operate. Proactively identify and address technical debt.
• Client collaboration: Work directly with client stakeholders to present the architecture, align on requirements, and clearly communicate technical decisions.
• Practice development: Contribute reusable patterns and frameworks that strengthen Phase2’s data engineering practice.

Requirements

• Experience: 6+ years of hands-on data engineering experience in production environments, with a clear interest in growing from a builder role into strategy and client consulting, and 2+ years in an agency or consulting context working directly with clients.
• Core technical skills: Strong proficiency in Python and SQL, with demonstrated experience building and operating production-grade pipelines and data models.
• Cloud data and modeling experience: Hands-on experience with cloud data warehouses (e.g., Snowflake, BigQuery, Redshift), dbt or similar transformation tooling, data modeling, and tag management.
• Pipeline and event systems experience: Proven experience with CDPs (e.g., Segment, mParticle) or event collection systems, orchestration tools (e.g., Airflow, Dagster), and building and operating production data pipelines.
• MarTech and platform integrations: Experience integrating CRM, marketing automation, and messaging platforms (e.g., HubSpot, Salesforce, Iterable, Braze) with warehouse and CDP data.
• Activation and measurement knowledge: Hands-on experience with Reverse ETL (e.g., Census, Hightouch), web analytics, attribution, and marketing measurement.
• AI and coding assistant fluency: Active daily use of coding assistants (e.g., Claude Code, Copilot, Codex) and comfort building with AI tools, agents, and automations as part of everyday delivery.
• Client communication: Comfort presenting technical architecture and decisions directly to client stakeholders, with prior agency or consulting experience strongly preferred.

Nice to have

Benefits

• The chance to make a real impact, helping millions of people per year.
• To work from wherever you thrive best. We’re a remote-first team built on trust, flexibility, and outcomes.
• A competitive compensation package that considers various factors.
• A comprehensive benefits package that includes medical, dental, vision, life insurance, disability coverage, and supplemental insurance.
• Our fun and interactive wellness program offers rewards for participation.
• A 401(k) with a 3% employer contribution -- no match required and 100% vested after just 90 days.
• You’ll start with 16 paid vacation days, 4 personal days, and 1 volunteer day each year. Vacation and personal time increase with your tenure, recognizing your continued contributions.
• Up to 12 weeks of fully paid leave for birthing parents and up to 6 weeks of fully paid bonding leave, based on your tenure. This includes support for adoption and foster placement, along with the option to extend time off through additional unpaid leave.
• Inclusive fertility, adoption, and surrogacy benefits through Kindbody, along with virtual health coaching and care navigation.
• A $500 stipend to personalize and equip your home workspace for success.