Senior Analyst, Data Engineering

Publicis Groupe
Philadelphia, United States of America
yesterday

Role details

Contract type
Temporary contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 101K

Job location

Philadelphia, United States of America

Tech stack

Java
Amazon Web Services (AWS)
Data analysis
Azure
Business Systems
Information Engineering
ETL
Data Warehousing
File Systems
Perl
Hadoop
Hive
Python
Meta-Data Management
Microsoft Visual Studio
Microsoft Visio
Microsoft SQL Server
MongoDB
NoSQL
Query Optimization
DataOps
Software Engineering
SQL Server Integration Services
Data Streaming
Freeform SQL
Spark
Information Technology
Data Management
Presto
REST
Software Version Control
Api Management

Job description

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

Requirements

  • 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

Benefits & conditions

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

About the company

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., 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., © 2026 Careerjet All rights reserved

Apply for this position