Senior Analyst, Data Engineering

Company description

PHM is the leading health media agency in the US, dedicated to connecting people with meaningful health and wellness experiences every day. By reimagining media's role in healthcare, PHM delivers best-in-class solutions, pushing the boundaries of media through data, content, commerce and creativity. Our teams' spirit of innovation and genuine passion for health inspire bold and meaningful work for our clients, and we do it all with #phmlove.

Overview

The Sr Analyst plays a key role in the client data onboarding process by developing effective business solutions that accurately stores data over time and allows the Data Operations group to build and improve the PHM media optimization methodology.

The variety of platforms and information available today requires careful planning and discipline to optimize performance at scale. The agency environment provides a variety of situations that requires weighing multiple options to solve technical problems.

Responsibilities

• Assist in leading information gathering and brainstorming sessions for business requirements definition

• Analyze, understand, and map complex system processes into user stories, data flows, and business system requirements

• Develop technical execution requirements based on specifications

• Monitor the original requirements throughout quality assurance testing and implementation to ensure that they are effectively delivered

• Review systems and report inefficiencies and improvement areas to the business process

• Ensure issues are identified, tracked, reported on and resolved in a timely manner

• Understands how to communicate difficult/sensitive information tactfully and effectively

• Comfortable in developing options and present alternatives

• Have an eye on automation, while managing data warehouse file storage

• Data management functions including:

• Metadata management

• Capacity planning

• Query tuning

• ETL

• Maintain best practices for handling and storing client data

• Tools Utilized:

• SQL Server/SSIS/Visual Studio/Source Control

• Java/R/Perl/Python

• Cloud Technologies - AWS, Azure, Google

Qualifications

• Bachelor's Degree in in Computer Information Systems, IT, Business, Marketing, or related field of study

• Minimum 3 years of work experience in Information Technology Systems Analysis or equivalent combination of education and experience

• Knowledge of Microsoft SQL and how to write advanced SQL queries

• Strong knowledge of MS Office products, including Visio

• Experience working in a Software Development and support environment a plus

• Effective communicator within Analytics Department; individual must be comfortable communicating to a non-technical audience and with members of interdisciplinary teams

• Flexible/adaptable/approachable and willing to work in rapidly changing, and high delivery environment

• High attention to detail and ability to audit for data anomalies and trends

• Strong analytical ability and abstract thinking to be able to gather business requirements effectively and facilitates creation of the technical specifications

• Ability to independently investigate and resolve issues - critical thinker

• Understanding of API integrations and experience implementing; including REST/RESTful

• Knowledge of data security protocols for handling sensitive information

• Experience with Data Warehousing technologies, development and management

• Experience with Mongo, Hadoop, Hive, Spark, Presto, Pig and NoSQL are a strong plus

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, 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 [email protected] .

Compensation Range: $73,150- $101,010 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 06/09/2026.

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

#LI-HA1

26-8106