at Publicis Groupe in Chicago, Illinois, United States
Job Description
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
The Director, Date Engineering, Tech & Data develops and supports data products. This resource plays a critical role in the development and maintenance of data solutions and deliverables used by internal and external stakeholders. You will 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 ensure the reliability and scalability of our data platforms. You will report to the SVP, Data Engineering.
This is a hybrid role, requiring three days in-office each week. If you are contacted for an interview, your recruiter will discuss specifics with you, inclusive of any necessary reasonable accommodations. This position can operate out of our NYC, Philadelphia or Chicago office location.
Responsibilities:
+ Lead and manage a team of data engineers, providing guidance and mentorship
+ 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
+ 7 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.
Compensation Range: $106,500 – $167,000 annually. This is the pay range the Company believes it will pay for this position at the time of this posting. The Company anticipates the application deadline for this job posting will be 8/15/2024.
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.
To view full details and how to apply, please login or create a Job Seeker account