Senior Data Engineer

Description

Position at GroupM Choreograph

GroupM is WPP's media investment group and the world's leading media investment company with a mission to shape the next era of media where advertising works better for people. The company is responsible for more than $60 billion in annual media investment, as measured by the independent research bureau COMvergence. Through its global agencies Mindshare, EssenceMediacom and, Wavemaker. GroupM's portfolio includes Data & Technology, Investment and Services, all united in vision to shape the next era of media where advertising works better for people. GroupM leverages a unique combination of global scale, expertise, and innovation to generate sustained value for clients wherever they do business. Discover more at www.groupm.com.

Role Summary and Impact:

GroupM's Data and Analytics team is proud to be a trusted data partner to PlayStation, a global leader in interactive entertainment. Embedded directly into PlayStation's internal engineering teams, we empower their marketing and advertising initiatives by managing a complex global database, ensuring data quality, and developing bespoke tools. Our expertise in data quality management, tool development, and API integration ensures the accuracy and accessibility of critical information. This data-driven approach fuels PlayStation's strategic decision-making and marketing success!

We are hiring for a Data Engineer to join the team, focused on building, managing and enhancing the vast data infrastructure that fuels PlayStation's marketing and advertising initiatives. This is a hands-on coding position and will play a crucial role in developing data pipelines, ensuring proper data collection techniques, and optimizing data-driven insights.

Please note: This hybrid position requires regular in-office presence. We are only considering candidates based in the New York tri-state area, Chicago, or Los Angeles.

Responsibilities:

• Maintain and enhance a large-scale database using Google Cloud Platform (GCP) and Python, ensuring scalability, performance, and data integrity. This includes applying hotfixes to the database when necessary.
• Design and implement data pipelines to automate data ingestion, transformation, and delivery from various sources, including advertising platforms, internal systems, and manual entry.
• Develop and implement data quality checks and monitoring systems to proactively identify and address data inconsistencies or errors.
• Work with the development team to enhance the robustness of data entry tools and provide clear guidelines for manual data entry.
• Work closely with internal Data & Analytics teams, PlayStation's engineering groups, and external partners to understand data needs, gather requirements, and provide technical expertise.
• Assist both PlayStation and EssenceMediacom (EMC) teams on servicing ad hoc requests for sales and audience data to help develop media plans or analyze their performance.
• Identify opportunities to optimize data infrastructure, enhance data quality processes, and implement best practices for data engineering and software development.

Qualifications:

• Bachelor's Degree in Statistical Modeling, Mathematics, Computer Science or other relevant fields of study.
• Minimum of 4 years experience of large-scale software development in a professional setting.
• Advanced proficiency in SQL, Python (including libraries like Pandas and Flask), Google Cloud Platform (GCP), Snowflake, and DBT (Data Build Tool).
• Experience in data governance processes, data quality assurance, and best practices for data integrity.
• Excellent verbal and written communication skills, with the ability to collaborate effectively with technical and non-technical teams.

Life at GroupM


Our passion for shaping the next era of media includes investing in our employees to help them do their best work, and we're just as committed to employee growth as we are to responsible media investment. GroupM employees can tap into the global GroupM & WPP networks to pursue their passions, grow their networks, and learn at the cutting edge of marketing and advertising. We have a variety of employee resource groups and host frequent in-office events showcasing team wins, sharing thought leadership, and celebrating holidays and milestone events. Our benefits include competitive medical, group retirement plans, vision, and dental insurance, significant paid time off, preferential partner discounts, and employee mental health awareness days.

GroupM provides equal employment opportunities to applicants and employees without regard to race; color; sex; gender identity; sexual orientation; religious practices and observances; national origin; pregnancy, childbirth, or related medical conditions; status as a protected veteran or spouse/family member of a protected veteran; or disability.

GroupM is committed to providing reasonable accommodation to, among others, individuals with disabilities and disabled veterans. If you need an accommodation because of a disability to search and apply for a career opportunity with GroupM, please send an e-mail to GroupM Leave Administration at [email protected] or call (212) 297-8507 and let us know the nature of your request and your contact information.

The base salary for this position at the time of this posting may range from $100,000 to $230,000. Individual compensation varies based on job-related factors, including business needs, experience, level of responsibility and qualifications. We offer a competitive benefits package, please visit https://www.wpp.com/people/wellbeing/benefits-at-wpp-in-the-us for more details.