Job Information
Publicis Groupe Associate Director, Data Engineering, Technology and Data in Philadelphia, Pennsylvania
Company Description
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
Overview of Job Responsibility:
Develop and support data products, this resource plays a critical role in the development and maintenance of data solutions and deliverables used by internal and external stakeholders. Design and develop big data solutions built on the Databricks and Azure technology stacks. You will help drive PHM data strategy, managing data pipelines, and ensuring the reliability and scalability of our data platforms. You will report to the Director, Data Engineering.
Responsibilities:
Design, implement, and maintain scalable data pipelines and architectures using Databricks and Azure technologies
Create high performance data products by monetizing warehouse and ETL solutions using python, sql and spark
Build data flow automation to retrieve, transform and load data. Manage data warehouse structure and file storage rules
Performance tuning and optimization of ETL and database structures. Optimize data infrastructure performance, reliability, and cost-efficiency
Monitor long running transactions and can improve query executions using best practices and methodologies
Design data models for enterprise-wide data integration incorporating:
Structured and unstructured data
Real-time, on-demand, batch and varying timing schedules
Collaborate with cross-functional teams to understand data requirements and deliver innovative solutions
Develop and enforce data engineering best practices, standards, and policies
Maintain best practices for handling, storing and using data
Evaluate and implement new technologies and tools to support data engineering initiatives
Drive continuous improvement and innovation in data engineering processes
Qualifications
Minimum Requirements:
Bachelor's degree in Computer Science, Engineering, or a related field; advanced degree
5 years experience in a data engineering leadership role, managing teams and complex projects.
Expertise in Databricks (Delta Lake, Apache Spark, Unity Catalog), Snowflake, Azure (Data Factory, Blob), SQL, and Python.
Expertise in Datorama, Tableau, PowerBI.
Strong understanding of data modeling, ETL processes, and data warehousing concepts.
Experience with cloud infrastructure and services, preferably Azure.
Excellent analytical and problem-solving skills.
Effective communication and collaboration skills with the ability to work across teams.
#LI-hybrid
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 USMSTACompliance@publicis.com .
All your information will be kept confidential according to EEO guidelines.