Senior Manager Merchant & Advertiser Data Marts

Capital One Financial

Confirmed live yesterday High trust
Remote

Quick summary

Work type
Remote
Location
McLean, VA
Salary
$209,000–$238,500 / yr
Posted
31 days ago
Freshness
Confirmed live yesterday

Market check

Salary context

Above market

How this pay compares to similar roles

Similar $203k
This role $224k
$152k most similar roles pay here $249k

This role pays more than 72% of similar roles. Most pay $166,359–$239,437 — the shaded band above. At the midpoint, this role pays about $224k versus about $203k for comparable roles.

Based on 240 similar postings.

Employer

About Capital One Financial

Capital One Financial is a bank holding company specializing in credit cards, auto loans, banking, and savings products, known for its data-driven approach to consumer and commercial finance. Industry: Financial Services & Banking

Capital One Financial currently has 998 open roles on FindRole.

Listed pay typically runs $197,300–$225,100 across 992 roles with salary data.

Most-posted roles

View all roles at Capital One Financial

At a glance

TL;DR · Senior Manager Merchant & Advertiser Data Marts

Sr Manager IC, Merchant & Advertiser Data Marts — Analytics Team is an individual contributor role focused on building the platform substrate for merchant and advertiser data. You will own and operate data marts that power retail media, revenue attribution, and marketing measurements. Key responsibilities include developing a data mart catalog with query-pattern analysis, executing Hive to Iceberg migrations, and implementing enforced access policies to steer consumers toward curated marts. The technical stack includes Lakehouse on Iceberg, dbt at multi-repo scale, Trino/Presto, Spark SQL, Airflow, Kafka/MSK, and AWS. You will also manage data governance requirements like GDPR and CCPA through policy-as-code. This role requires expertise in SQL, Python, or Java to build migration code and dbt models while coordinating with cross-functional teams to solve complex problems regarding merchant and advertiser reporting.

What you'll do

  • Build and maintain data marts that power retail media, advertiser reporting, and revenue attribution.
  • Develop a comprehensive data mart catalog including ownership, lineage, PII classification, and audit trails.
  • Execute Hive to Iceberg migrations for high-value merchant and advertiser data systems.
  • Implement and enforce access policies to steer users from raw event tables toward curated marts.
  • Author dbt models and Airflow DAGs to manage large-scale data transformations and orchestrations.
  • Manage production support and on-call rotations for all owned and newly developed data marts.
  • Translate business requirements from Sales, BizOps, and Analytics teams into technical platform specifications.

What we're looking for

  • At least 6 years of experience in software engineering.
  • At least 1 year of experience with cloud computing (AWS, Microsoft Azure, or Google Cloud).
  • 10+ years of engineering experience and 5+ years building shared data platforms or lakehouse infrastructure.
  • Experience leading a Hive to Iceberg migration at scale on a revenue-attached system.
  • Experience in data-access governance under regulated frameworks like GDPR, CCPA, or SOX.
  • Claude Code fluency for daily use and skill authoring (required).
  • Cross-functional fluency with Sales, BizOps, and Analytics teams (required).
  • Prior merchant, advertiser, or retail-media data experience (preferred).
  • Master's Degree (preferred).
  • 9+ years of experience in JavaScript, Java, TypeScript, SQL, Python, or Go (preferred).
  • 4+ years of experience with AWS, GCP, or Microsoft Azure (preferred).
  • 4+ years of experience in open source frameworks (preferred).
  • 1+ years of people management experience (preferred).
  • 2+ years of experience in Agile practices (preferred).

More like this

Similar roles

Senior Manager FinOps & AI Enablement

Capital One Financial

Remote 31 days ago $209,000$238,500
AWS Python SQL Go Java TypeScript JavaScript dbt Airflow Kafka Trino Presto Spark SQL Docker Kubernetes Nomad S3 Cassandra DynamoDB ElasticSearch Aurora MySQL RAG LLM
10+ yrs exp Remote

Director, Analytics, Commerce Platform

DoorDash, Inc

New York, NY +3 122 days ago $255,000$375,000
Data Science SQL Statistical Analysis Experimentation Causal Inference Forecasting KPI Design Funnel Analytics Business Analytics
10+ yrs exp

Senior Manager, Marketing Analytics

Okta Inc

Bellevue, WA +1 24 days ago $170,000$233,000
Tableau Salesforce Snowflake SQL Python R Google Analytics (GA4) Adobe Analytics Excel AI/ML Marketing Attribution Modeling A/B Testing Statistical Analysis API Integration Martech CRM Predictive Modeling
8+ yrs exp

Senior Manager, Marketing Analytics

Okta Inc

Bellevue, WA +1 24 days ago $170,000$233,000
Tableau Salesforce Snowflake SQL Python R Google Analytics (GA4) Adobe Analytics Excel AI/ML A/B Testing Marketing Attribution Modeling CRM Data Warehouse API Integration Statistical Analysis Marketing Mix Modeling
8+ yrs exp

Senior Manager, Customer Success Analytics

CrowdStrike

Remote (CA) 36 days ago $145,000$220,000
Business Intelligence SQL Snowflake BigQuery Tableau CRM Analytics ETL ELT Data Architecture SaaS Metrics Data Engineering
10+ yrs exp Remote