Manager, Data Engineering

Company DescriptionCoLab is a fully integrated, cross-discipline team that provides best-in-class services in a fluid and modular way. With our clients at the center, we create brand movement at the speed of people’s lives by connecting real-time data with world-class creative, content, and media in service of growth and Return on investment.CoLab is a “power of one” solution, encompassing data, media, and production. By drawing from across the vast Publicis Groupe network, we are uniquely positioned to deliver innovation and specialized skills to our clients, as well as enriching opportunities and inclusive benefits to our employees. We pride ourselves on combining the atmosphere of a startup company with the stability and experience of a global leader.OverviewOur team is looking for a high-performing Data Engineer who will be responsible for the design, development, implementation and on-going support of a data driven 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

Analyze ambiguous business requirements and partner with product team to provide a strategic solution

Collaborate with frontend engineers to design 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

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

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

4+ years’ experience with Python

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 InformationOur 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.Compensation Range: $81,500 - $128,000 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. For this role, 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 11/14/2024.