Company DescriptionPresent 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 DescriptionAbout 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.QualificationsResponsibilities:
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 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 [email protected] .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