Senior Manager, Merchant & Advertiser Data Marts – Analytics Team

This is a fully remote position, open to applicants in Virginia.

📋 Description

• Take charge of the platform substrate that underpins Capital One Shopping’s merchant and advertiser data marts, facilitating Retail Media, advertiser reporting, revenue attribution, and marketing measurement.

• Establish reference architecture, catalog, access policy, GDPR/audit assurances, and standards for downstream product teams.

• Develop a data mart catalog and query-pattern analysis system that encompasses production mart ownership, SLOs, lineage, PII classification, and audit trails.

• Enhance the Dataset Registration Scanner with Trino-log analysis to pinpoint raw tables that require marts.

• Finalize Hive-to-Iceberg standardization for a high-value merchant/advertiser mart, ensuring PII-masking parity, GDPR deletion propagation, and schema-change auditing.

• Formulate and enforce a marts-first access policy across three high-traffic raw schemas utilizing Trino permissions and CloudSentry.

• Create migration code and dbt models, document catalog lineage and audit capture, author Airflow DAGs, and implement policy-as-code.

• Collaborate weekly with Sales, BizOps, and Analytics on governance and PII/access decisions.

• Provide ongoing production support and participate in an on-call rotation for both current and future marts.

• Maintain ownership of systems through production; function as an individual contributor without direct reports.

⛳️ Requirements

• Over 10 years of engineering experience.

• More than 5 years of experience in building shared data platforms or lakehouse infrastructure.

• Practical experience in leading a Hive-to-Iceberg or similar lakehouse migration at scale on a revenue-affiliated system.

• A proven history of establishing standards adopted by at least three product teams.

• Experience in building or expanding a data catalog used across various teams.

• Knowledge of data-access governance under GDPR/CCPA, SOX, or a comparable regulated framework.

• Complete ownership of PII classification, deletion propagation, or audit-trail activities.

• Proven capability in transitioning consumers from raw event tables to curated marts.

• At least one previous role in a regulated data environment.

• Cross-functional fluency with Sales, BizOps, and Analytics, adept at translating business needs into platform work.

• Daily use of Claude Code, skill in authoring, and producing PR-level deliverables.

• Bachelor’s Degree.

• At least 6 years of software engineering experience; internship experience is not included.

• A minimum of 1 year of cloud computing experience with AWS, Microsoft Azure, or Google Cloud.

• Preferred: Master’s Degree.

• Preferred: Over 9 years of experience with JavaScript, Java, TypeScript, SQL, Python, or Go.

• Preferred: At least 4 years of experience with AWS, GCP, Microsoft Azure, or another cloud service.

• Preferred: At least 4 years working with open source frameworks.

• Preferred: More than 1 year of people management experience.

• Preferred: Over 2 years of experience with Agile practices.

🏝️ Benefits

• Performance-driven incentive compensation, which may include cash bonuses and/or long-term incentives (LTI).

• A comprehensive, competitive, and inclusive range of health, financial, and other benefits aimed at supporting overall well-being.

• Consideration for employment authorization sponsorship for new qualified applicants.

• Support for reasonable accommodations for applicants who require assistance.