Manager, Data Engineering

$81,500 - $128,000/Yr

Publicis Groupe - New York, NY

Full-time - Mid Level

New York, NY

10,001+ employees

Professional, Scientific, and Technical Services

About the position

The Data Engineer at CoLab is responsible for designing, developing, implementing, and supporting a data-driven software platform. This role requires a self-starter who thrives in a fast-paced environment, managing multiple projects that include enhancements and new developments. The Data Engineer will collaborate with product teams and frontend engineers to optimize software performance and ensure high-quality data management.

Responsibilities

• 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
• Perform advanced database administration and development including stored procedures, user defined functions, triggers, and ETL packages
• Uphold quality standards and create monitoring tools to ensure high fidelity data
• Optimize and tune 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
• Follow implementation standards, develop documentation and transfer of knowledge

Requirements

• 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
• 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
• Bachelor's Degree in Computer Sciences, Information Technology, or equivalent

Nice-to-haves

• Experience with Snowflake
• 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

Benefits

• Medical coverage
• Dental insurance
• Vision insurance
• Disability insurance
• 401k
• Paid time off