Manager, Data Engineering, Technology & Data

Publicis Groupe - Philadelphia, PA

Full-time - Mid Level

Hybrid - Philadelphia, PA

Professional, Scientific, and Technical Services

About the position

The Data Manager of Data Engineering will play a crucial role in the Technology and Data Department at PHM, a leading health media agency. This position involves hands-on management of data processes, ensuring the stability, security, and compliance of data flows within the organization. The role requires collaboration with various internal and external partners to monitor data transfers, perform quality assurance, and maintain documentation, all while supporting the Vice President of Data Engineering in enforcing enterprise-wide data protocols.

Responsibilities

• Lead portfolio of data projects across different clients in the agency
• Work with different teams such as Media Tech, BI, Media, Strategy, Investments and Tech & Data
• Use the agency warehouse and ETL solutions to oversee data transfers
• Monetize data flow automation to retrieve, transform and load data
• Data management responsibilities including ETL/data feed management and Metadata management
• Review Process to ensure data stability, security, and compliance
• Present issues, trends & recommendations to internal and external teams
• Provide solutions for data needs and issue resolutions with the Data Engineering, Technology and Data and BI teams
• Maintain best practices for handling, storing, and using data

Requirements

• BS Degree in Computer Science, Information Technology, or related field
• Experience tracking and resolving BI and database related incidents as well as requests
• Experience with database structures, theories, principles, and practices
• Experience with ETL and data warehouse principles
• Technical documentation skills
• Experience communicating complex updates and resolutions to partners in user-friendly language
• Minimum 4 years SQL experience
• Minimum 3 years of ETL experience
• Minimum 3 years analyzing data sets
• Minimum 4 years BI experience (Tableau, Datorama)
• Excel proficiency with complex functions
• Experience with large datasets
• Experience with Web and Digital marketing data is a plus

Nice-to-haves

• Experience with Cloud Technologies - Databricks, AWS, Azure

Benefits

• Medical coverage
• Dental coverage
• Vision coverage
• Disability insurance
• 401K
• Parental leave
• Family care leave
• Family forming assistance
• Tuition reimbursement
• Flexible time off