Senior Manager, Merchant & Advertiser Data Marts

Capital One Financial

Confirmed live today High trust
Remote

Quick summary

Work type
Remote
Location
McLean, VA
Employment
Full-time
Posted
77 days ago
Freshness
Confirmed live today

Market check

Salary context

How this pay compares to similar roles

Similar $190k
$154k $233k
below market most similar roles pay here above market

This listing doesn't post a salary. Most similar roles pay $165,000–$214,900.

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 2107 open roles on FindRole.

Listed pay typically runs $197,300–$225,100 across 1107 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

The Sr Manager IC, Merchant & Advertiser Data Marts — Analytics Team is an individual-contributor role responsible for owning the platform substrate behind merchant and advertiser data. You will build and operate data marts that power retail media, revenue attribution, and marketing measurements. Key responsibilities include developing a data mart catalog, performing query-pattern analysis, and executing Hive to Iceberg migrations with PII-masking and GDPR deletion-propagation. You will also implement access policies using Trino permissions and CloudSentry. The technical stack includes a Lakehouse on Iceberg, dbt, Trino/Presto, Spark SQL, Airflow, Kafka/MSK, and AWS. You must navigate complex data governance requirements, including CCPA and SOX compliance, while translating business needs from Sales and BizOps into technical platform work within a regulated financial services environment.

What you'll do

  • Build and operate production data marts that power retail media, revenue attribution, and marketing measurements.
  • Develop a data mart catalog to track ownership, SLOs, lineage, and PII classifications.
  • Execute Hive to Iceberg migrations for high-value merchant and advertiser marts.
  • Implement PII-masking, GDPR deletion propagation, and schema-change audit logs into reusable playbooks.
  • Author and enforce access policies using Trino permissions and CloudSentry to steer consumers toward curated marts.
  • Write migration code, dbt models, and Airflow DAGs to maintain the data platform substrate.
  • Provide ongoing production support and participate in an on-call rotation for existing and future marts.
  • Translate business needs from Sales, BizOps, and Analytics into technical platform requirements.

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.
  • Hands-on experience leading a Hive to Iceberg migration at scale on a revenue-attached system.
  • Experience building data catalogs, managing data-access governance (GDPR/CCPA/SOX), and shifting consumers to curated marts.
  • Prior experience in a regulated data environment (financial services, healthcare, or equivalent).
  • Claude Code fluency, cross-functional fluency, and prior merchant or retail-media data experience (preferred).
  • Bachelor’s Degree.

More like this

Similar roles

Senior Manager, FinOps & AI Enablement

Capital One Financial

Remote (McLean, VA) 77 days ago
AWS Python SQL Kafka Trino dbt Airflow Kubernetes Docker Nomad Cassandra DynamoDB ElasticSearch Aurora MySQL Spark SQL TypeScript Java Go S3 Iceberg RAG LLM
10+ yrs exp Remote

Senior Lead Data Engineer

Capital One Financial

McLean, VA 120 days ago
Python SQL AWS Spark Kafka Snowflake Databricks DynamoDB GenAI ETL NoSQL Hadoop Hive EMR Redshift MySQL Cassandra Mongo UNIX Linux Shell Scripting Agile AWS Glue Microsoft Azure Google Cloud
6+ yrs exp

Manager, Data Science, US Card - Marketing

Capital One Financial

McLean, VA +2 8 days ago $197,300–$225,100
Python AWS Spark XGBoost scikit-learn statsmodels H2O SQL Scala R Conda Relational Databases Machine Learning Deep Learning Reinforcement Learning Time Series Sentiment Analysis Clustering Classification Statistical Modeling
6+ yrs exp Hybrid

Manager, Data Scientist, US Card

Capital One Financial

McLean, VA +2 46 days ago $197,300–$225,100
Python AWS Spark H2O SQL Scala R Conda Relational Databases Machine Learning Deep Learning Time Series Sentiment Analysis Clustering Classification Statistical Modeling Big Data
6+ yrs exp

Manager, Advanced Analytics, Marketplace Payments

Walmart

Bentonville, AR +1 28 days ago $80,000–$155,000
SQL Python Advanced Analytics Business Intelligence Data Mining Statistical Analysis Data Management Prototype Development Financial Risk Management Data-Driven Decision Making
2+ yrs exp