Company description

At Publicis CoLab, it is our mission to deliver Better Outcomes For All.

That means delivering exceptional results and performance for our clients, for their customers and for our teams. A competitive advantage we have in this space is our unique structure with four consolidated and integrated COE’s, a powerful and data-rich Operating System, and our deep relationships across teams and Publicis Groupe via our Power of One models.

We are driven by our values to Be Better, Be Curious, Be Open & Be Bold.

We live at the intersection of technology, digital, creative, CRM, analytics, and media. We are driven by a common purpose, a powerful spirit, shared behaviors, and a relentless focus on our people. We are constantly challenging the status quo and redefining what is possible for our clients. We combine industry expertise, top-tier talent, and unique, scalable solutions to deliver more valuable customer experiences and tangible business results.

Overview

As a leader on the Data Engineering, the Director, Data Engineering will play a pivotal role in shaping the future of the team, being responsible for the design, development, implementation and on-going support of a data driven healthcare professional (HCP) software platform. You enjoy and thrive in a fast-paced environment on multiple projects simultaneously, including both enhancements as well as new project development. The candidate must be a self-starter with a sense of urgency and a commitment to quality and professionalism.

Responsibilities

Role Objectives:

• Synthesize ambiguous business requirements to drive direction/action and partner with product team to provide strategic data solutions

• Collaborate with frontend engineers to design and/or modify schema for optimal software performance

• Advanced database administration and development including stored procedures, user defined functions, triggers and ETL packages as well as security and roles

• Uphold quality standards and create monitoring tools to ensure high fidelity data

• Manage data partnerships – ensuring data acquisition compliance and file format integrity

• Optimization and tuning of existing stored procedures to improve performance

• Troubleshoot database issues, identify root causes, and implement optimal solutions

• Extract, transform, and load data from multiple data sources using languages and tools such as Python and AWS Glue

• Design, Build, Test, Debug, Monitor, and Troubleshoot ETL and software processes in Python

• Recommend solutions to existing or anticipated issues

• Serve as an escalation point for any issues that may arise

• Design testing requirements and prepare test plans and test modules

• Ability to follow implementation standards, develop documentation and transfer of knowledge

The following experience is a plus:

• Experience with Snowflake

• Experience with Business Intelligence software (Tableau, PowerBI)

• Experience and thorough understanding of a variety of APIs

• Experience supporting analytics and data science teams/tools (Pandas, R, Alteryx)

• Experience with front-end development

Qualifications

• 5+ years’ experience with ETL and databases, (Redshift preferred)

• 5+ years’ experience with Python

• Strong experience in working with pharmaceutical clients, especially with healthcare professionals (HCP) and physician-level data (e.g., NPI data).

• Familiarity with cloud technologies such as Amazon Web Services (Redshift, S3, Glue, Lambda)

• Advanced PostgreSQL programming skills (stored procedures, functions, etc.)

• Experience with marketing data and digital media

• Experience with complex processing logic against large data sets

• Excellent data modelling skills and experience working with multiple datasets

• Possession of strong communication and presentation skills as well as an analytical mindset

• Good problem solving and testing skills

• Familiarity with code versioning tools such as Git

• Strong organizational skills & attention to detail

• Possess a desire to work for a fast-paced, results-based company

• Experience managing multiple projects simultaneously

• Self-driven/entrepreneurial spirit with the ability to think outside of the box

• Bachelor’s Degree in Computer Sciences, Information Technology, or equivalent

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 .

Compensation Range: $132,715 - $208,840 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 03/05/2025.

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

#LI-JL2