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 Lead Database Engineer is responsible for the design, development, implementation and on-going support of a data driven software platform.  Must be able to work in a fast-paced environment on multiple projects simultaneously, including both enhancements as well as new project development. The ideal candidate must be a self-starter with a sense of urgency and a commitment to quality and professionalism.

Responsibilities:

• Analyze business requirements and partner with product team to provide a strategic solution
• Collaborate with front end 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
• 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 issues that may arise
• Design testing requirements and prepare test plans and test modules
• Develop documentation and transfer of knowledge

• Minimum Bachelor’s Degree in Computer Sciences, Information Technology, or its equivalent
• Minimum 5+ years’ experience with ETL and databases
• Minimum 3+ years’ experience with SSIS or Talend
• Familiarity with cloud technologies such as Amazon Web Services (AWS)
• Experience with complex processing logic
• 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
• 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

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