Associate Director, Data Engineering (Media Agency)

Publicis Groupe • New York, NY

3d • $110,580 - $173,995

About The Position

This is a senior data engineer within our North American team. The data engineer will collaborate within a team of technologists to produce enterprise scale solutions for our clients' needs. This position will be focused on building out a customer data hubs/profile databases and building data warehouse solutions.

Requirements

• 5-8 years in a data engineering role with demonstrable experience with data integration and data warehouse projects.
• Responsible for the maintenance, improvement, cleaning, and manipulation of data in the business's operational and analytics databases.
• Works with the business's data analytics teams, data scientists, and software engineers in order to understand and aid in the implementation of database requirements, analyze performance, and troubleshoot any issues.
• Defines and builds the data pipelines that will enable faster, better, data-informed decision-making within the business.
• Experience designing and building data warehouses, customer profile databases, data marts, etc.
• Experience with data modeling, warehouse design, and fact/dimension concepts.
• Experience working with different query languages (i.e. T-SQL, PostgreSQL, PL-SQL).
• Understanding and experience working with cloud platform services: Redshift, Aurora, Data Factory, SQL DW, Azure Datawarehouse, Data Lake, BigQuery, etc.
• Experience working with code repositories and continuous integration (i.e. Git, Jenkins, etc.)
• Understanding of development and project methodologies.
• Ability to work collaboratively in teams with other specialized individuals.
• Able to work in a fast-paced, technical environment.
• Good verbal and written communication skills.

Nice To Haves

• Prefer some experience in at least one programming language (i.e. Python, Java, Scala, C#, etc.).
• Prefer some experience in data integration projects and automation via ETL Tools (i.e. Talend, Informatica, SSIS, etc.)
• Experience in Amazon Redshift is a plus.
• Experience with marketing data (Google Double-Click, Site Analytics, Paid Search, etc.) is also a plus.

Responsibilities

• Deliver quality work on defined tasks with little oversight and direction.
• Ensure all deliverables are of high quality throughout the project by adhering to coding standards and best practices and participating in code reviews.
• Participate in integrated test sessions of components and subsystems on test and production servers.
• Serve as technical resource during software development life cycle to solve business issues through the process of identifying and analyzing detailed requirements that translate into data integration and database system designs.
• Solve business issues through the process of identifying and analyzing detailed requirements that translate business requirements into technical system designs.
• Use information gained through prior experience, knowledge sharing with other Technology Associates, education and training to resolve issues and remove project barriers
• Provide status updates to team members on a regular basis and clearly escalate issues and risks to project management as needed.

Benefits

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed
• Number of Employees: 5,001-10,000 employees