Lead Data Engineer

Company Description

Present in over 100 countries and employing nearly 80,000 professionals, Publicis Groupe is the third largest communications group in the world. Publicis Groupe is listed on the Euronext Paris [FR0000130577] and is part of the CAC 40 index. Active across the entire value chain, Publicis Groupe offers its major clients a transversal, unified and fluid model allowing them access to all the Groupe's tools and expertise around the world through the mantra "The Power of One." You will report to Alexander Bley, Executive Vice President, Engineering. This is a hybrid role.

Job Description

About Publicis Media:

Publicis Media is one of Publicis Groupe's four solution hubs, aligning all of Publicis Groupe's media agencies and operations. Publicis Groupe (Euronext Paris Exchange: FR0000130577; CAC 40 index), is the world's third-largest communications group. The Business Platforms Global Practice was created to deliver best-in-class solutions and consolidate Publicis Media's data and technology to transform our business from a service business to a platform business.

Description:

Lead Data Engineer responsible for the design, development, implementation, and ongoing support of a data-driven software platform. Must be able to work in a fast-paced environment on multiple projects simultaneously, including enhancements and new project development. The candidate must be a self-starter with a sense of urgency and a commitment to quality and professionalism.

Qualifications

Responsibilities:

• Analyze business requirements and partner with the product team to provide a strategic solution
• Collaborate with front-end engineers to design or modify the 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
• Optimization and tuning of existing T-SQL 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 ETL tools such as SSIS or Talend
• Design, Build, Test, Debug, Monitor, and Troubleshoot ETL and software processes
• Recommend solutions to existing or anticipated issues
• Follow implementation standards
• Serve as an escalation point for any problems that may arise
• Design testing requirements and prepare test plans and test modules
• Develop documentation and transfer of knowledge

Minimum Qualifications:

• Minimum Bachelor's Degree in Computer Sciences, Information Technology, or its equivalent
• Minimum 3+ years' experience with ETL and databases.
• Minimum 3+ years' experience with SSIS or Talend.
• Minimum 1+ years' experience with Databricks.
• Familiarity with cloud technologies such as Amazon Web Services (AWS) and Microsoft Azure.
• Experience with complex processing logic
• Excellent data modeling 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
• Advanced T-SQL programming skills (stored procedures, functions, etc.)
• Familiarity with code versioning tools such as Git
• Strong organizational skills & attention to detail
• Experience working with big data technologies such as Hadoop(Hive) and MPP
• Possess a desire to work for a fast-paced, results-based company
• Experience managing multiple projects simultaneously

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 hrcompliance_usms@publicis.com.

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

Compensation Range:  $106,500 - $167,500 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 06/06/2024.

Veterans Encouraged to Apply

#LI-Hybrid