Director, Data Management
Chicago, IL - USA
Job Summary
Spark Foundry was built during the most transformative time in the history of advertising and marketing. We deliver everything a traditional media agency has to offer and have grown into one of the worlds most successful agencies by helping brands evolve their marketing by leveraging identity commerce artificial intelligence and more to connect with people. Transformation is part of our DNA. Spark Foundrys start-up spirit delivers high-touch approaches and a never-ending desire to challenge the status quo. Combined with Publicis Medias powerhouse soul leveraging connected data assets advanced AI applications and investment clout we Bring HEAT to Brands. No other agency possesses the expertise that we do to address todays most pressing challenges to drive business transformation through media.
The Director Data Management Lead is the primary client and agency point of contact for media and pharmaceutical data management. This role defines the end-to-end data management approach guides backend architecture in Databricks and Snowflake and ensures that data is accurate secure compliant traceable and fit for reporting measurement optimization and advanced analytics.
Embedded within the Data & Analytics organization this role blends functional data leadership with hands-on engineering. The lead partners across client media analytics technology privacy and offshore teams; brings forward scalable data engineering best practices; and can roll up their sleeves to design build troubleshoot and optimize data flows. Knowledge of pharmaceutical media HCP data privacy and compliance requirements and applied AI is highly valued.
1) Data Governance Strategy & Data Health
- Own the client and agency data management and governance operating model across media measurement and pharmaceutical data domains.
- Define standards for data ownership lineage metadata naming conventions taxonomies access retention and fitness for use.
- Establish measurable data health controls SLAs stewardship routines issue escalation paths and governance forums.
- Translate regulatory privacy security and client requirements into practical controls with working knowledge of HCP and other sensitive pharmaceutical datasets considered a strong advantage.
2) Media Data Operations & Quality Management
- Lead ingestion validation reconciliation monitoring and delivery of media data across paid search social programmatic video display offline and publisher sources.
- Design media data quality guardrails automated checks thresholds and exception handling across source-to-report pipelines.
- Own error tracking and defect management including triage root-cause analysis remediation ownership SLA monitoring and prevention of recurrence.
- Ensure transformed and harmonized datasets reconcile to source systems and satisfy reporting measurement optimization and audit requirements.
3) Cross-Functional Process Leadership
- Serve as the primary point of contact for client data discussions including data strategy architecture onboarding quality governance issue resolution compliance and delivery readiness.
- Guide client media analytics engineering ad operations privacy security and offshore teams through clear requirements RACIs decisions dependencies risks and escalation paths.
- Lead source onboarding and change management so media plans buys identifiers taxonomies and required metadata flow correctly into downstream platforms.
- Build trusted client relationships by communicating technical topics in business terms and providing clear recommendations trade-offs owners and next steps.
4) Data Architecture Business Rules & Transformation Enablement
- Provide technical direction for scalable backend architecture in Databricks and/or Snowflake covering ingestion medallion or layered design transformation orchestration storage performance security and observability.
- Translate functional reporting and analytics needs into data models mapping specifications business rules validation logic BRDs TRDs and engineering-ready acceptance criteria.
- Lead by example and contribute hands-on when needed by building reviewing troubleshooting and optimizing SQL Python notebooks jobs and data pipelines.
- Bring forward data engineering best practices for modularity reuse testing deployment documentation cost efficiency recoverability and production support.
5) Training Compliance & Change Management
- Partner with client privacy legal security and compliance stakeholders to interpret requirements and embed appropriate access handling masking retention transfer and audit controls.
- Promote compliant use of HCP patient-adjacent audience identity and media data without compromising analytical utility or operational clarity.
- Develop playbooks standards job aids templates and training for onshore and offshore teams explaining both the control and the business rationale behind it.
- Monitor adoption document evidence and improve processes when controls or operating practices break down.
6) Global Stewardship & Continuous Improvement
- Serve as the accountable day-to-day lead for data operations platform health governance and engineering delivery across markets and workstreams.
- Maintain a prioritized improvement roadmap spanning automation reusable frameworks monitoring documentation performance cost and operational resilience.
- Evaluate and responsibly apply AI-assisted capabilities for data quality anomaly detection metadata management engineering productivity and operational support.
- Provide leadership and clients with concise updates on data health delivery risks blockers decisions ownership and measurable business impact.
- 810 years of experience in data management data engineering analytics engineering media data operations or data governance within an agency pharmaceutical or similarly complex environment.
- Demonstrated leadership of client-facing data programs with the ability to own the overall approach facilitate technical and functional decisions and communicate risks and recommendations.
- Strong hands-on experience with Databricks and/or Snowflake SQL Python data modeling ETL/ELT orchestration testing monitoring and production support.
- Deep understanding of media and marketing data across digital and offline channels including campaign hierarchies taxonomies platform extracts delivery metrics and reporting dependencies.
- Proven experience establishing data governance quality controls reconciliation processes error tracking lineage metadata and operational SLAs.
- Ability to translate business requirements into scalable technical designs and to review or build data flows when delivery requires hands-on support.
- Strong understanding of privacy security data handling auditability and compliance principles in regulated environments.
- Excellent leadership stakeholder management documentation problem-solving and communication skills across technical and non-technical audiences.
Preferred Experience
- Experience with pharmaceutical media and regulated data including familiarity with HCP data identity consent privacy and compliant activation or measurement workflows.
- Experience designing lakehouse or warehouse architectures and CI/CD practices in cloud data environments.
- Familiarity with media buying ad serving audience measurement and publisher platforms and their data delivery patterns.
- Experience with data observability catalog lineage master/reference data and quality monitoring frameworks.
- Working knowledge of AI/ML concepts and practical AI-assisted use cases in data engineering and governance.
- Strong program management discipline including roadmaps RACIs dependency tracking release planning and executive status reporting.
Tools & Platforms
- Core engineering: Databricks Snowflake SQL Python notebooks ETL/ELT orchestration APIs file transfers and version control/CI-CD practices
- Governance and operations: data catalogs lineage quality and observability tools issue/error tracking access controls documentation and collaboration platforms
- Business intelligence and analytics: Power BI and comparable reporting transformation and workflow tools
- Media and measurement platforms: Campaign Manager 360 DV360 The Trade Desk paid social platforms Amazon DSP Google Analytics Adobe Analytics Prisma and related agency/client systems
Our Publicis Groupe motto Viva La Différence means were better together and we believe that our differences make us stronger. It means we honor and celebrate all identities across all facets of intersectionality and it underpins all that we do as an organization. We are focused on fostering belonging and creating equitable & inclusive experiences for all talent.
Publicis Groupe provides robust and inclusive benefit programs and policies to support the evolving and diverse needs of our talent and enable every person to grow and thrive. Our benefits package includes medical coverage dental vision disability 401K as well as parental and family care leave family forming assistance tuition reimbursement and flexible time off.
If you require accommodation or assistance with the application or onboarding process specifically please contact
All your information will be kept confidential according to EEO guidelines.
#LI-DR1
Required Experience:
Director
About Company
Publicis Media is one of the four solutions hubs of Publicis Groupe ([Euronext Paris FR0000130577, CAC 40], alongside Publicis Communications, Publicis.Sapient and Publicis Healthcare. Led by Steve King, CEO, Publicis Media is powered by its five global brands, Starcom, Zenith, Spark ... View more