Senior Analyst, Data Enablement (MCI)

Publicis Health Media; Chicago (IL); On-site; USD 73,150 - 101,010; Full time

Benefits offered by this job

Medical coverage

Dental coverage

401(k) plan

Flexible time off

Tuition reimbursement

Job summary

Publicis Health Media in Chicago is seeking a Data Enablement team member to design and develop core data products. The role involves working with large datasets to create scalable data solutions, implementing classification logic, and ensuring data accuracy.

The ideal candidate will have hands-on experience with SQL, Python, Databricks, and a strong analytical mindset. Publicis offers a robust benefits package including medical, dental, and 401(k) options, fostering an inclusive work environment.

Qualifications

• Hands-on experience with Databricks and/or Snowflake.
• Proficiency in SQL and/or Python for data analysis.
• Experience with large datasets and scalable data solutions.
• Detail-oriented with a commitment to data accuracy.
• Strong problem-solving skills for complex data issues.
• Excellent communication skills for technical concepts.

Responsibilities

• Contribute to the design and maintenance of data pipelines.
• Develop scalable classification logic and transformation rules.
• Ensure data quality and consistency through rigorous validation.
• Collaborate with Engineering and Business Intelligence teams.
• Resolve complex data issues and implement long-term solutions.

Skills

SQL

Python

Databricks

Snowflake

Data Quality Assurance

Problem-Solving

Communication Skills

Tools

Databricks

Snowflake

Datorama/MCI

Tableau

Power BI

Alteryx

Job description

Company Description

PHM is the leading health media agency in the US, built for the modern healthcare experience. Here, industry depth meets media scale, where data becomes direction, where creativity and storytelling bring truth to life, and where orchestration replaces fragmentation. Dedicated to making brands discovered, PHM redefines what media can do through data, content, and creativity. Because in modern healthcare, the brands that are found are the ones that lead. And when brands lead, advantage follows. Go deeper. Be found.

Overview

As a key member of the Data Enablement team, you will play a critical role in the design, development, and ongoing evolution of core data products, including our classification engine and supporting data infrastructure. This role sits at the intersection of data engineering, data product development, and data governance, with a focus on building scalable, high-quality solutions that power downstream analytics and reporting. You will work hands‑on with large, complex datasets to develop and maintain data pipelines, implement classification logic, and ensure data accuracy and consistency across systems.

Responsibilities

• Contribute to the design, build, and maintenance of data pipelines and workflows supporting the classification engine and other core data products using Databricks and/or Snowflake


• Develop and implement scalable classification logic and data transformation rules using SQL and/or Python


• Ensure data quality, consistency, and integrity across datasets through rigorous QA, validation, and monitoring processes


• Partner closely with Engineering, Business Intelligence, and Media teams to support and evolve data products and underlying data models


• Troubleshoot and resolve complex data issues, identifying root causes and implementing long‑term solutions


• Work within Agile frameworks (Jira) to manage priorities, deliverables, and cross‑functional collaboration

Qualifications

• Hands‑on experience working with Databricks and/or Snowflake, or similar modern data warehouse technologies


• Proficiency in SQL and/or Python for data transformation and analysis


• Experience working with large, complex datasets and building scalable data solutions


• Exceptionally detail oriented and committed to data accuracy and quality


• Strong problem‑solving skills with the ability to debug complex data and system issues


• Excellent communication skills, with the ability to clearly explain technical concepts to both technical and non‑technical stakeholders


• Ability to think critically about data structures, logic, and system design

Preferred But Not Required

• Experience with taxonomy, classification systems, or data governance frameworks


• Experience with data visualization tools such as Datorama/MCI, Tableau, and Power BI


• Familiarity with tools such as Alteryx


• Experience working with media or marketing data (pharmaceutical experience is a plus, but not required)

Additional Information

Our Publicis Groupe motto “Viva La Différence” means we’re 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, 401(k), as well as parental and family care leave, family forming assistance, tuition reimbursement, and flexible time off.

All your information will be kept confidential according to EEO guidelines.

Compensation Range: USD $73,150.00 – $101,010.00 annually. This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on the skills, qualifications, and experience of the applicant along with the requirements of the position, and the Company reserves the right to modify this pay range at any time. Temporary roles may be eligible to participate in our freelancer/temporary employee medical plan through a third‑party benefits administration system once certain criteria have been met. Temporary roles may also qualify for participation in our 401(k) plan after eligibility criteria have been met. For regular roles, the Company will offer medical coverage, dental, vision, disability, 401(k), and paid time off. The Company anticipates the application deadline for this job posting will be 8/2/2026.