Senior Analyst, Data Engineering, Technology & Data Philadelphia, PA Job at Publ

Senior Analyst, Data Engineering, Technology & Data

PHM is the leading health media agency in the US. We are designed for—and dedicated to—delivering solutions that connect people with meaningful health and wellness solutions every day. Guided by our genuine passion for health and wellness, our work across the entire media ecosystem helps patients navigate the most important moments of their healthcare journeys.

While we have grown to be the No. 1 agency in our industry, at heart we’re still a startup. It’s that energy and spirit of innovation that allows us to create bold and meaningful “health media firsts” for our clients, and to do it all with #phmlove.

Job Description

Position Summary

The Senior Analyst, Tech & Data will use their background in data analysis across to clean, classify, and QA many media data sources to integrate all of them in multiple BI platforms while documenting these integrations and assisting the client on media data operation questions on how to query, visualize and automate further processes.

You will be responsible in data collecting, cleaning and classification to improve data solutions. You will gather media data requirements for the development and providing support of data products with internal and external clients. An understanding of data engineering and a knowledge of media data as the position will help with the advancement of our current warehouse solutions (built on the Datorama and Snowflake technology stacks), classifying real-time data for our clients and ensuring that the data has flowed through our warehouse solutions correctly for downstream user ingestion. This involves a data quality assessment and correction process that you will manage.

Besides fulfilling any data requests made by the external client, data must also align with internal BI partners to make sure the data is available and visualized based on the measurement strategy outlined. Therefore, a person that is successful in this role will understands the media buy process from start to finish.

You will report to the Associate Director of Business Intelligence.

Responsibilities

• Develop mapping tables, dictionaries and stored procedures for cleaning data reservoirs and optimizing data solutions by enhancing and establishing QA processing.
• Communicate with external clients/partners to gather requirements and resolve any outstanding issues.
• You will improve SQL and database structures and automated processes.
• Craft and maintain professional relationships with the many members of your internal & external client team(s).
• Work throughout the year with internal (PHM) and external (client team, partner agencies/consulting groups) partners to deliver and support data operations.
• Address challenges with clearly defined goals and definitions of data integration and reporting success.
• You will understand and maintain both internal and external client workstreams that culminate in the delivery of data. This includes ensuring the data flows are correct and QA’ing the data before it is ingested.
• You will help maintain many internal data sources and third-party vendors/data streams that comprise our custom measurement platform while keeping process on task within the established timelines and delivery dates.
• You will classifying incoming data, overseeing maintains of the existing processes and ensuring implementation of data integrity processes. This will include overseeing existing data quality processes with the reporting manager while requiring identification of new approaches on how to ensure our data is correct.

Qualifications

• Bachelor’s Degree (preferably a BS in a related field) is required.
• 3+ years of work experience in data/analytics consulting or quantitative marketing/analysis.
• Media Data Experience required.
• Experience with business intelligence software such as Datorama, media data and financials (PRISMA, Ad Servers) and cloud base services such as Snowflake, Databricks, Azure
• Skillset strengths in the following core competencies:
  • Data QA & Metadata
  • Project Management
  • SQL/PY Spark & Datorama Development Experience
  • Basic coding languages, such as Python, SQL, Py spark

#LI-Hybrid

Additional Information

Our Publicis Groupe motto “Viva LaDifférence”meanswe’rebetter together, and we believe thatour differences make us stronger. It means wehonor and celebrate all identities, across all facetsof intersectionality, and it underpins all that we doas an organization.We are focusedon 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.

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