Marketing Data Architect & AI-Driven Strategist (Remote)

phase2-careers; United States; Remote; USD 140,000 - 200,000; Full time

Job summary

Phase2 is a remote‑first digital agency helping clients unlock growth through data‑driven experiences. This role leads data architecture, pipelines, and platform integrations, bridging hands‑on engineering with strategic client advising.

You will design cloud warehouses, implement CDPs and marketing integrations, and collaborate with cross‑functional teams to deliver measurable outcomes for acquisition, lifecycle marketing, attribution, and AI‑powered workflows.

Qualifications

• 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.
• Strong proficiency in Python and SQL, with demonstrated experience building and operating production‑grade pipelines and data models.
• Hands‑on experience with cloud data warehouses (e.g., Snowflake, BigQuery, Redshift), dbt or similar transformation tooling, data modeling, and tag management.
• 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.

Responsibilities

• Design data models, schemas, and identity strategies that connect raw data to clear business and marketing outcomes.
• Build and maintain ETL and ELT pipelines and transformations into cloud warehouses using modern patterns and tooling.
• Integrate warehouses, CDPs, CRM and marketing systems, messaging platforms, analytics tools, and data sources.
• Configure audience, scoring, and lifecycle signal flows from warehouses into tools using Reverse ETL.
• Build attribution structures, UTM frameworks, and campaign tracking for trusted performance.
• Shape data for AI‑powered use cases such as agents, automations, and RAG workflows.
• Test, monitor, and document data systems; address technical debt and ensure reliability.
• Present architecture to client stakeholders and align on requirements.
• Contribute reusable patterns to strengthen Phase2’s data engineering practice.

Skills

Python

SQL

Data modeling

ETL/ELT

Data architecture

Client communication

CDP implementations

AI/Automation fluency

Tools

Snowflake

BigQuery

Redshift

dbt

Airflow

Dagster

Segment

mParticle

HubSpot

Salesforce

Iterable

Braze

Census

Hightouch

Job description

Phase2 is a remote‑first digital agency helping clients unlock growth through data‑driven experiences. This role leads data architecture, pipelines, and platform integrations, bridging hands‑on engineering with strategic client advising.

You will design cloud warehouses, implement CDPs and marketing integrations, and collaborate with cross‑functional teams to deliver measurable outcomes for acquisition, lifecycle marketing, attribution, and AI‑powered workflows.