Publicis Collective is a Metro Detroit Agency servicing Stellantis (formerly Fiat Chrysler Automobiles).

We live at the intersection of technology, digital, creative, CRM, analytics and media. We are driven by a common purpose, a powerful spirit, shared behaviors, and a relentless focus on our people. We are constantly challenging the status quo and redefining what’s possible for our clients.

We combine auto industry expertise, top-tier talent and unique, scalable solutions to deliver more valuable customer experiences and tangible business results.

We are driven by our values to Be Better, Be Curious, Be Open & Be Bold.

Our 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.

Role Objectives:

• 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

Desired qualifications and skillsets:

• 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

The following experience is a plus:

• 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

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