Senior AI-Driven Marketing Data Architect

Smarsh; Portland (OR); On-site; USD 106,000 - 141,000; Full time

Job summary

Smarsh in Portland, OR seeks a Senior Marketing Analyst to build the data foundation for marketing and GTM, enabling AI-driven insights. You will own the data model, governance, and semantic layer to support reliable revenue decisions.

Collaborating with RevOps, IT, and marketing leaders, you will design measurement roadmaps, develop dashboards, and drive data quality and adoption across teams.

This role emphasizes hands-on analytics, SQL, and BI tooling in a fast-growing SaaS environment.

Qualifications

• 5+ years of GTM, marketing, or revenue-operations analytics experience.
• Advanced SQL and hands-on Snowflake experience.
• Hands-on dbt experience building production-grade models.
• Experience with a semantic/metrics layer (dbt Semantic Layer, LookML, Omni).
• Experience with ELT and orchestration tools (Fivetran, Airflow).
• Deep knowledge of Salesforce data structures and Marketo or similar.
• Expert BI skills in Power BI, Looker, Tableau or Omni.
• Proven ABM and multi-touch attribution experience.

Responsibilities

• Design and build an AI-ready data foundation for marketing and GTM with governed models and a semantic layer.
• Own end-to-end marketing data architecture from sources to Snowflake and curated models.
• Develop pipelines using ELT with tools like Fivetran and Airflow, with SLAs and monitoring.
• Define marketing attribution models (W-Shaped, custom, account-level) with documented assumptions.
• Build executive dashboards (Power BI, Looker, Tableau, Omni) reconciled to Salesforce and finance data.
• Set and govern a unified marketing metric definitions and roadmap.

Skills

GTM analytics

Advanced SQL

Snowflake

dbt

Semantic layer

Power BI

Looker

Tableau

AI tools

Analytic roadmap

Education

Bachelor's degree in Analytics/Statistics/CS/Business/Marketing

Tools

Fivetran

Airflow

Salesforce

Marketo

dbt

Power BI

Looker

Tableau

Omni

Job description

Smarsh in Portland, OR seeks a Senior Marketing Analyst to build the data foundation for marketing and GTM, enabling AI-driven insights. You will own the data model, governance, and semantic layer to support reliable revenue decisions.

Collaborating with RevOps, IT, and marketing leaders, you will design measurement roadmaps, develop dashboards, and drive data quality and adoption across teams.

This role emphasizes hands-on analytics, SQL, and BI tooling in a fast-growing SaaS environment.