Manager, Data Engineer (Media Agency)

Publicis Groupe•New York, NY

About The Position

The Manager, Data Engineering & ETL Development is a key driver to build data platform leveraging best in class ETL practice and is also a strategic thinker and a talented data visualization expert with emphasis on dashboard reporting. The primary responsibility will be developing business intelligence platform to support media and marketing data for our clients. This position will allow you to be a significant contributor as part of the team to support easy access of data and visualizations to fuel stronger insights and media optimizations. This position requires strong technical and tactical skill sets with an eye for numbers, intellectual curiosity, proficiency at problem solving, and a critical understanding of online media. The candidate must have a proven track record in managing ETL's, APIs and business intelligence platforms. Candidate should be a team player. A “roll up the sleeves” approach is mandatory and a “get it done” attitude is a must. Specific responsibilities include coordination between the research, analytics & media teams ensuring high quality data projects are effectively delivered. Successful candidates will be multi-dimensional ‘rising-stars' who are able to employ complex problem solving skills, and are able to communicate these succinctly to a broad client and media stakeholder audience.

Requirements

3+ years' related experience ETL development and business intelligence platform management
Understanding of BI/ETL development in the IT industry with recent development, system administration, application tuning and debugging experience.
3+ plus years' development experience with database engines including Presto, Mongo db and Hadoop.
3+ years' experience in ETL development, Strong Database (Modeling, SQL), SQL Server, Hadoop, AWS Redshift, Qubole.
Experience managing team of 2 or more associates/analysts preferred
Strong database modeling and SQL skills. Ability to write complex SQL statement, Procedures and data automation programs
Knowledge of ETL tools like Airflow, AWS Glue, Alteryx, SSIS, Qubole/Spark is a must
Knowledge of Python or similar programming languages required
Proficiency with Datorama, Tableau, or other data visualization tools is preferred
Experience working with AWS or other cloud technologies
Advanced user Microsoft Office Suite and reporting tools
Demonstrated expertise in core MS Excel functions (vlookup, pivot tables, data visualization)
Experience in designing jobs that can be easily promoted from one (Dev) environment to another (Test or Prod) seamlessly, without modification.
Strong analytical and problem-solving skills
Strong verbal/written communication and interpersonal skills is required
Self-starter with ability to thrive in a fast-paced environment and able to function independently while providing status updates to a team of analysts
Cooperative, flexible, conscientious, dependable, resourceful, self-motivated, and team-oriented
Problem solving, time management, and critical thinking skills with a professional and positive attitude
Ability to work independently and as part of an agile team, participating in daily stand-ups, sprint planning and sprint review

Responsibilities

Responsible for loading and validating data into the data warehouse from various source systems
Analyze, develop, fix, test, review and deploy functionality, and bug fixes in ETL data pipelines
Query tuning, diagnosis, and resolution of performance issues using ELT and push-down if required
Building Data mappings between Source to Target systems
Provides support for technical issues and ensuring system availability
Work with business customers to identify and develop additional data and reporting needs
Understand how business intelligence platform/data technologies work and offer the ability to explain technical concepts in ordinary terms (be technically savvy - understand the opportunities and limitations)
Establish and manage data integrations using a taxonomy nomenclature to make recommendations for data visualization to showcase media performance through the use of Datorama or Tableau
Perform regular quality assurance/quality control checks on assigned client campaigns to ensure the data is processing accurately
Design and build backend data streams and processes to automate reporting capability with data visualization tools
Contribute to client status and reporting calls, including presentation of reporting as required
Develop subject matter expertise in ETL, API development, and Business Intelligence platforms
Clearly define project deliverables, timelines, and dependencies for junior team members, internal partners and clients
Collaborate on an inclusive team, where members openly communicate and collectively problem-solve
Solid ability to evaluate new technologies and present findings to team
Contribute to knowledge sharing efforts and mentorships
Complete other duties as assigned.

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.

Stand Out From the Crowd

Upload your resume and get instant feedback on how well it matches this job.

Upload and Match Resume