MNC InsiderMNC Insider
Capital One logo

Sr Manager IC, Merchant & Advertiser Data Marts — Analytics Team (Remote-Eligible)

Capital One

Sr Manager IC, Merchant & Advertiser Data Marts — Analytics Team (Remote-Eligible)

full-timePosted: Aug 11, 2026Updated: Aug 27, 2026VA, McLean

Job Description

Sr Manager IC, Merchant & Advertiser Data Marts — Analytics Team (Remote-Eligible)The roleOwn the platform substrate behind Capital One Shopping's merchant and advertiser data — the marts that power Retail Media, advertiser reporting, revenue attribution, and every marketing measurement in the business. You set the standards (reference architecture, catalog, access policy, GDPR/audit guarantees) that downstream product teams build on. This is an own-and-build role, not a maintenance seat: you own and operate these marts in production, and in your first six months you ship three net-new systems. You'll report to the Engineering Director for the Shopping data platform as one of two senior IC pillars of the analytics org.What you'll buildA data mart catalog + query-pattern analysis — a single source of truth covering every production mart (owner, SLO, lineage, PII classification, audit trail), plus a Trino-log analysis that shows which raw tables need a mart next. Extends the existing Dataset Registration Scanner, doesn't fork it.Iceberg standardization on a revenue-attached mart — finish the Hive → Iceberg pattern on one high-value merchant/advertiser mart, with PII-masking parity, GDPR deletion-propagation, and schema-change audit baked into a reusable playbook other teams can follow. Bounded standardization, not an open-ended migration.A marts-first access policy, enforced — draft and land a policy that steers consumers off raw event tables when a mart exists, enforced on three high-traffic raw schemas via Trino permissions + CloudSentry, with a full auditable exception log.The stackLakehouse on Iceberg (with legacy Hive tables mid-standardization), dbt at multi-repo scale, Trino/Presto and Spark SQL, Airflow orchestration, Kafka/MSK streaming upstream, on AWS. Data catalog tooling (Amundsen, DataHub, Collibra, OpenMetadata, or home-grown equivalents). GDPR/CCPA governance mechanics throughout.The day-to-day"Manager" is the level, not the job — this is an individual-contributor role, and you'll spend most of your day writing migration code and dbt models, not managing a team. Roughly 65% building: writing the Hive → Iceberg migration and its parity tests, coding catalog lineage / PII-classification / audit capture, authoring dbt models and Airflow DAGs, and implementing access enforcement as Trino + CloudSentry policy-as-code. The other ~35% is technical coordination — the weekly Sales / BizOps / Analytics cadence and the PII/access decisions — because governance is cross-functional by nature. The policy work is code and config, not a PDF. You also carry ongoing production support and an on-call rotation for the existing and future marts on this surface — you own what you build, in production. No direct reports — you build.What we're looking for10+ years engineering experience, 5+ years building shared data platforms / lakehouse infrastructureHands-on experience leading a Hive → Iceberg (or analogous lakehouse) migration at scale on a revenue-attached systemA track record of setting standards that multiple product teams actually adopted (≥3 teams)Experience building or extending a data catalog used across teamsData-access governance under a regulated framework — GDPR/CCPA, SOX, or equivalent — with specific PII-classification, deletion-propagation, or audit-trail work you owned end-to-endA track record of shifting consumers off raw event tables onto curated martsAt least one prior role in a regulated data environment (financial services, healthcare, or equivalent)Prior merchant, advertiser, or retail-media data experience (or an analogous B2B customer-facing data product) — strong plusCross-functional fluency — a hard requirement; weekly cadence with Sales, BizOps, and Analytics, translating business needs into platform work and backClaude Code fluency — daily use, skill authoring, PR-level deliverables (hard requirement)Basic Qualifications:Bachelor’s DegreeAt least 6 years of experience in software engineering (Internship experience does not apply)At least 1 year experience with cloud computing (AWS, Microsoft Azure, Google Cloud)Preferred Qualifications: Master’s Degree9+ years of experience in at least one of the following: JavaScript, Java, TypeScript, SQL, Python, or Go4+ years of experience with AWS, GCP, Microsoft Azure, or another cloud service4+ years of experience in open source frameworks1+ years of people management experience2+ years of experience in Agile practicesCapital One will consider sponsoring a new qualified applicant for employment authorization for this position. The minimum and maximum full-time annual salaries for this role are listed below, by location. Please note that this salary information is solely for candidates hired to perform work within one of these locations, and refers to the amount Capital One is willing to pay at the time of this posting. Salaries for part-time roles will be prorated based upon the agreed upon number of hours to be regularly worked.Remote (Regardless of Location): $209,000 - $238,500 for Sr. Lead Software Engineer McLean, VA: $229,900 - $262,400 for Sr. Lead Software Engineer Candidates hired to work in other locations will be subject to the pay range associated with that location, and the actual annualized salary amount offered to any candidate at the time of hire will be reflected solely in the candidate’s offer letter.This role is also eligible to earn performance based incentive compensation, which may include cash bonus(es) and/or long term incentives (LTI). Incentives could be discretionary or non discretionary depending on the plan.Capital One offers a comprehensive, competitive, and inclusive set of health, financial and other benefits that support your total well-being. Learn more at the Capital One Careers website. Eligibility varies based on full or part-time status, exempt or non-exempt status, and management level.This role is expected to accept applications for a minimum of 5 business days.No agencies please. Capital One is an equal opportunity employer (EOE, including disability/vet) committed to non-discrimination in compliance with applicable federal, state, and local laws. Capital One promotes a drug-free workplace. Capital One will consider for employment qualified applicants with a criminal history in a manner consistent with the requirements of applicable laws regarding criminal background inquiries, including, to the extent applicable, Article 23-A of the New York Correction Law; San Francisco, California Police Code Article 49, Sections 4901-4920; New York City’s Fair Chance Act; Philadelphia’s Fair Criminal Records Screening Act; and other applicable federal, state, and local laws and regulations regarding criminal background inquiries.If you have visited our website in search of information on employment opportunities or to apply for a position, and you require an accommodation, please contact Capital One Recruiting at 1-800-304-9102 or via email at RecruitingAccommodation@capitalone.com. All information you provide will be kept confidential and will be used only to the extent required to provide needed reasonable accommodations.For technical support or questions about Capital One's recruiting process, please send an email to Careers@capitalone.comCapital One does not provide, endorse nor guarantee and is not liable for third-party products, services, educational tools or other information available through this site.Capital One Financial is made up of several different entities. Please note that any position posted in Canada is for Capital One Canada, any position posted in the United Kingdom is for Capital One Europe and any position posted in the Philippines is for Capital One Philippines Service Corp. (COPSSC).

Locations

  • VA, McLean
  • US Remote (Remote)

Salary

209,000 - 238,500 USD / yearly

Skills Required

  • or extending a data catalog used across teamsintermediate
  • software engineeringintermediate
  • cloud computingintermediate
  • at least one of the following: JavaScriptintermediate
  • AWSintermediate
  • open source frameworksintermediate
  • Agile practicesintermediate

Required Qualifications

  • 10+ years engineering experience, 5+ years building shared data platforms / lakehouse infrastructure (experience, 10 years)
  • Hands-on experience leading a Hive → Iceberg (or analogous lakehouse) migration at scale on a revenue-attached system (experience)
  • A track record of setting standards that multiple product teams actually adopted (≥3 teams) (experience)
  • Experience building or extending a data catalog used across teams (experience)
  • Data-access governance under a regulated framework — GDPR/CCPA, SOX, or equivalent — with specific PII-classification, deletion-propagation, or audit-trail work you owned end-to-end (experience)
  • A track record of shifting consumers off raw event tables onto curated marts (experience)
  • At least one prior role in a regulated data environment (financial services, healthcare, or equivalent) (experience)
  • Prior merchant, advertiser, or retail-media data experience (or an analogous B2B customer-facing data product) — strong plus (experience)
  • Cross-functional fluency — a hard requirement; weekly cadence with Sales, BizOps, and Analytics, translating business needs into platform work and back (experience)
  • Claude Code fluency — daily use, skill authoring, PR-level deliverables (hard requirement) (experience)
  • 10+ years engineering experience, 5+ years building shared data platforms / lakehouse infrastructure (experience, 10 years)
  • Hands-on experience leading a Hive → Iceberg (or analogous lakehouse) migration at scale on a revenue-attached system (experience)
  • A track record of setting standards that multiple product teams actually adopted (≥3 teams) (experience)
  • Experience building or extending a data catalog used across teams (experience)
  • Data-access governance under a regulated framework — GDPR/CCPA, SOX, or equivalent — with specific PII-classification, deletion-propagation, or audit-trail work you owned end-to-end (experience)
  • A track record of shifting consumers off raw event tables onto curated marts (experience)
  • At least one prior role in a regulated data environment (financial services, healthcare, or equivalent) (experience)
  • Prior merchant, advertiser, or retail-media data experience (or an analogous B2B customer-facing data product) — strong plus (experience)
  • Cross-functional fluency — a hard requirement; weekly cadence with Sales, BizOps, and Analytics, translating business needs into platform work and back (experience)
  • Claude Code fluency — daily use, skill authoring, PR-level deliverables (hard requirement) (experience)
  • Bachelor’s Degree (degree)
  • At least 6 years of experience in software engineering (Internship experience does not apply) (experience, 6 years)
  • At least 1 year experience with cloud computing (AWS, Microsoft Azure, Google Cloud) (experience, 1 years)
  • Bachelor’s Degree (degree)
  • At least 6 years of experience in software engineering (Internship experience does not apply) (experience, 6 years)
  • At least 1 year experience with cloud computing (AWS, Microsoft Azure, Google Cloud) (experience, 1 years)

Preferred Qualifications

  • Master’s Degree (degree)
  • 9+ years of experience in at least one of the following: JavaScript, Java, TypeScript, SQL, Python, or Go (experience, 9 years)
  • 4+ years of experience with AWS, GCP, Microsoft Azure, or another cloud service (experience, 4 years)
  • 4+ years of experience in open source frameworks (experience, 4 years)
  • 1+ years of people management experience (experience, 1 years)
  • 2+ years of experience in Agile practices (experience, 2 years)
  • 9+ years of experience in at least one of the following: JavaScript, Java, TypeScript, SQL, Python, or Go (experience, 9 years)
  • 4+ years of experience with AWS, GCP, Microsoft Azure, or another cloud service (experience, 4 years)
  • 4+ years of experience in open source frameworks (experience, 4 years)
  • 1+ years of people management experience (experience, 1 years)
  • 2+ years of experience in Agile practices (experience, 2 years)
  • Capital One will consider sponsoring a new qualified applicant for employment authorization for this position. (experience)
  • The minimum and maximum full-time annual salaries for this role are listed below, by location. Please note that this salary information is solely for candidates hired to perform work within one of these locations, and refers to the amount Capital One is willing to pay at the time of this posting. Salaries for part-time roles will be prorated based upon the agreed upon number of hours to be regularly worked. (experience)
  • Candidates hired to work in other locations will be subject to the pay range associated with that location, and the actual annualized salary amount offered to any candidate at the time of hire will be reflected solely in the candidate’s offer letter. (experience)
  • Capital One offers a comprehensive, competitive, and inclusive set of health, financial and other benefits that support your total well-being. Learn more at the Capital One Careers website. Eligibility varies based on full or part-time status, exempt or non-exempt status, and management level. (experience)
  • For technical support or questions about Capital One's recruiting process, please send an email to Careers@capitalone.com (experience)
  • Capital One does not provide, endorse nor guarantee and is not liable for third-party products, services, educational tools or other information available through this site. (experience)
  • Capital One Financial is made up of several different entities. Please note that any position posted in Canada is for Capital One Canada, any position posted in the United Kingdom is for Capital One Europe and any position posted in the Philippines is for Capital One Philippines Service Corp. (COPSSC). (experience)

Responsibilities

  • A data mart catalog + query-pattern analysis — a single source of truth covering every production mart (owner, SLO, lineage, PII classification, audit trail), plus a Trino-log analysis that shows which raw tables need a mart next. Extends the existing Dataset Registration Scanner, doesn't fork it.
  • Iceberg standardization on a revenue-attached mart — finish the Hive → Iceberg pattern on one high-value merchant/advertiser mart, with PII-masking parity, GDPR deletion-propagation, and schema-change audit baked into a reusable playbook other teams can follow. Bounded standardization, not an open-ended migration.
  • A marts-first access policy, enforced — draft and land a policy that steers consumers off raw event tables when a mart exists, enforced on three high-traffic raw schemas via Trino permissions + CloudSentry, with a full auditable exception log.
  • A data mart catalog + query-pattern analysis — a single source of truth covering every production mart (owner, SLO, lineage, PII classification, audit trail), plus a Trino-log analysis that shows which raw tables need a mart next. Extends the existing Dataset Registration Scanner, doesn't fork it.
  • Iceberg standardization on a revenue-attached mart — finish the Hive → Iceberg pattern on one high-value merchant/advertiser mart, with PII-masking parity, GDPR deletion-propagation, and schema-change audit baked into a reusable playbook other teams can follow. Bounded standardization, not an open-ended migration.
  • A marts-first access policy, enforced — draft and land a policy that steers consumers off raw event tables when a mart exists, enforced on three high-traffic raw schemas via Trino permissions + CloudSentry, with a full auditable exception log.

Target Your Resume for "Sr Manager IC, Merchant & Advertiser Data Marts — Analytics Team (Remote-Eligible)" , Capital One

Get personalized recommendations to optimize your resume specifically for Sr Manager IC, Merchant & Advertiser Data Marts — Analytics Team (Remote-Eligible). Takes only 15 seconds!

AI-powered keyword optimization
Skills matching & gap analysis
Experience alignment suggestions

Check Your ATS Score for "Sr Manager IC, Merchant & Advertiser Data Marts — Analytics Team (Remote-Eligible)" , Capital One

Find out how well your resume matches this job's requirements. Get comprehensive analysis including ATS compatibility, keyword matching, skill gaps, and personalized recommendations.

ATS compatibility check
Keyword optimization analysis
Skill matching & gap identification
Format & readability score

Tags & Categories

GeneralGeneral

Answer 10 quick questions to check your fit for Sr Manager IC, Merchant & Advertiser Data Marts — Analytics Team (Remote-Eligible) @ Capital One.

Quiz Challenge
10 Questions
~2 Minutes
Instant Score

Related Books and Jobs

No related jobs found at the moment.