P

Publicis Groupe

Runs advertising and digital transformation services

Manager – Media Data & Analytics

Business IntelligencePosted on Nov 5
Full-timeChicago, IL, USA$87.2k - $125.3k /yrIn-person

About the Job

Requirements

  • Solid skills in SQL for querying and manipulating relational databases.
  • Proficiency in business intelligence and data visualization tools such as Tableau and at least one of Power BI, Looker, or Dataroma.
  • A bachelor's degree in computer science, information systems, data science, or a related field.
  • At least 3 years of experience in data analysis, business intelligence development, or a related field.
  • Strong analytical and problem-solving skills, including the ability to interpret complex data sets and deliver clear insights.
  • Experience with structured and unstructured problem-solving.
  • Experience with Microsoft Office Suite, including Word, Excel, and PowerPoint.
  • Demonstrated experience independently leading small- to mid-size projects and managing time effectively.

Responsibilities

  • Design, develop, and maintain data models as part of client data strategy using Visio or another tool.
  • Write SQL to access data from data sources.
  • Write processes using scripting languages such as Python to efficiently integrate data from diverse sources into reporting data marts.
  • Develop and maintain scalable and efficient data models to support analytical needs, ensuring data is organized, consistent, and accessible using Prep Builder or by working with engineers on more complex implementation.
  • Create and manage reports, dashboards, and visualizations using business intelligence tools such as Tableau, Power BI, Looker, and Dataroma to deliver actionable insights to business partners.
  • Work with database connections such as Microsoft SQL Server and Azure.
  • Work closely with data analysts, engineers, reporting analysts, and business partners to understand data needs and translate business requirements into technical specifications.
  • Work regularly with partners to inform them of the latest capabilities and implement those capabilities to elevate client success.
  • Implement data quality checks and validation processes to ensure accuracy, consistency, and reliability of data sources.
  • Support data governance practices and compliance initiatives on the business intelligence platform.
  • Optimize database queries and ETL processes to improve system performance and data processing speed.
  • Document data processes, technical specifications, architecture, and data models to support clarity and future maintenance and development.
  • Monitor and resolve issues within business intelligence solutions, ensuring high availability and reliability of data and reporting systems.

Desired Qualifications

  • Data modeling using Microsoft Visio.
  • Experience with Tableau Prep Builder and/or Alteryx.
  • Experience with scripting languages such as Python or R for data manipulation and automation.
  • Knowledge of TabPy, Pandas, and NumPy.
  • Experience with Jira Issue Management System.
  • Background in media performance measurement and reporting.
  • Familiarity with data governance and industry-standard processes.
  • A master's degree.

About the Company

Publicis Groupe

Runs advertising and digital transformation services

Publicis Groupe runs advertising, media buying and digital transformation services for companies that want to reach consumers, coordinate campaigns and improve their business systems. Its agency network includes creative and media specialists, while Publicis Sapient builds and modernizes the technology behind clients' operations. Epsilon adds customer data and marketing technology that connect brands with audiences and measure campaign results. Clients pay for consulting, campaign creation and execution, with production and media costs billed through alongside the group's service work. Founded in 1926, Publicis Groupe is headquartered in Paris, France.

Company size
10,001+
Company stage
IPO
Headquarters
Paris, France
Founded
1926

Recently Posted Jobs

Explore more opportunities at Publicis Groupe

See more jobs