Director, Engineering
Chicago, IL, United States
Publicis Media Exchange (PMX) is the global media platform for Publicis Groupe [Euronext Paris FR0000130577, CAC 40]. PMX is an omnichannel activation powerhouse that drives smart application of investment through leveraging scale, marketplace innovation, deeper partnerships and knowledge. PMX is at the forefront of the converging marketplace building data-informed, tech-enabled media to help marketers connect with consumers in a measurable way.
Job Description
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.
A 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.
This is a hybrid role, requiring three days in-office each week. If you are contacted for an interview, your recruiter will discuss specifics with you, inclusive of any necessary reasonable accommodations.
Your Impact:
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
Qualifications
Minimum Bachelor’s Degree in Computer Sciences, Information Technology, or its equivalent
Minimum 2+ years’ experience with ETL and databases.
Minimum 2+ 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 LaDifférence”meanswe’rebetter together, and we believe thatour differences make us stronger. It means wehonor and celebrate all identities, across all facetsof intersectionality, and it underpins all that we doas an organization.We are focusedon 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.
All your information will be kept confidential according to EEO guidelines.
REQ # 23-9349
#J-18808-Ljbffr