Full Time Rbc Data Analyst Jobs in Chicago, IL (NOW HIRING)

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.

Job Description

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

• Exceptional attention to detail and a strong commitment 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 Difference" 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, 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 USMTTACompliance@publicis.com.

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

 Compensation Range: USD $73,150.00 - USD $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, 401k, and paid time off. The Company anticipates the application deadline for this job posting will be 8/2/2026.Employment Type: FULL_TIME