Mars United Commerce · 1 day ago
Data Governance Director
Mars United Commerce is a global commerce marketing practice that aligns people, technology, and intelligence to improve business outcomes for clients. The Data Governance Director is responsible for ensuring the accuracy and conformity of retailer, vendor, and platform data used for reporting, managing data quality, ingestion workflows, and collaborating with various teams to deliver reliable reporting.
AdvertisingMarketing
Responsibilities
Taxonomy Governance
Data Conformity
Data Quality
Mapping and Match Tables
Data Validation
Data Entry Accuracy
Training
Reporting Readiness
Metadata Management
Documentation
Weekly Ingestion Workflow Management
Own and maintain taxonomy mapping for placements, programs, budgets, and channel structures
Build and update match tables to align retailer and vendor naming conventions to internal schemas
Interpret retailer data extracts and apply standardized mapping rules required for reporting
Work with engineering to confirm that required fields for managed versus self service tracking are correctly populated
Validate all incoming files using automated and manual checks for completeness, accuracy, and consistency
Identify missing data, schema mismatches, and anomalies, escalating issues where needed
Provide training, documentation and workflow updates to drive accuracy, timeliness and alignment across teams
Maintain a QC coverage dashboard that highlights data gaps, unsupported fields, and connector issues and meet with key stakeholders to communicate and remediate issues
Maintain a list of non-compliant vendors and coordinate with internal teams or vendors to resolve structural or naming issues
Work with Media and Business Analytics to resolve discrepancies in spend, placements, or program level details
Use SQL queries, macros, and Python scripts to pull data from multiple sources and aggregate it into unified structures
Build automated data cleaning and transformation workflows where appropriate to support the weekly ingest cycle
Create summary level tables using group by logic and metric calculations to support pacing, budgeting, and performance reporting
Implement repeatable checks that confirm dataset completeness and alignment before reporting is refreshed
Maintain detailed documentation including data standards, field definitions, lineage diagrams, and transformation rules
Update the internal data catalog to reflect taxonomy structures, dataset attributes, mapping rules, and dependencies
Ensure our Data Governance policies are properly followed
Prepare validated datasets for BI dashboards in Power BI and Looker
Validate data as it lands in platform tables and ensure mapping logic is consistent with reporting expectations
Support platform migrations by documenting required fields and confirming availability in new schema structures
Partner with Business Analytics to ensure reporting reflects accurate mapping and metric calculations
Coordinate with Media Activation teams to validate spend, placement, and activation level details
Show up, be accountable, and take responsibility for data integrity
Qualification
Required
Bachelor's or Master's degree in Data Analytics, Information Systems, Computer Science, or a related field
Seven to ten years of experience in data governance, stewardship, analytics engineering, or data operations
Advanced SQL skills including joins, group by functions, aggregations, window functions, and metric calculation
Experience using Python to automate data cleaning, transformation, and validation tasks
Ability to build reusable macros and workflow scripts for repeated ingestion and QC processes
Experience aggregating data across multiple sources and preparing datasets for reporting
Familiarity with Databricks or similar data platforms
Working knowledge of BI tools such as Power BI or Looker
Solid understanding of data warehousing and lakehouse concepts including schema design and partitioning
Strong understanding of data governance including cataloging, metadata management, lineage, and access controls
Experience resolving data quality issues and managing ingestion or mapping workflows
Ability to interpret raw datasets and bring them into alignment with required naming and taxonomy standards
Experience partnering with Media, Marketing, Engineering, and Analytics teams
Excellent documentation skills for data dictionaries, technical specs, and workflow instructions
Clear communication skills for explaining data quality issues to technical and non-technical audiences
Benefits
Medical coverage
Dental
Vision
Disability
401K
Parental and family care leave
Family forming assistance
Tuition reimbursement
Flexible time off
Company
Mars United Commerce
Mars United℠ Commerce is a global commerce marketing practice that aligns people, technology, and intelligence to make the business of our clients better today than it was yesterday.
H1B Sponsorship
Mars United Commerce has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2020 (1)
Funding
Current Stage
Late StageTotal Funding
unknown2021-05-17Acquired
Recent News
24-7 Press Release Newswire
2025-06-11
stoppress.co.nz
2024-03-27
Company data provided by crunchbase