Description
Position at GroupM Nexus
ABOUT US
GroupM Data & Analytics Services is a marketing science, technology and consulting group specializing in fact-based business strategies and assessment. We combine AdTech and MarTech platform strategy with data science & data engineering expertise to make advertising work better for clients and consumers.
ABOUT THE ROLE
As an ETL Developer within the Analytics practice, you will work in an environment where everyone is passionate about data, analytics, and self-development with a customer-centric focus. This role is on the Smart Data team, which builds and maintains the reporting infrastructure for Wavemaker's roster of clients. You will have an opportunity to employ advanced data engineering, as well as data science tools and techniques, to media analytics. Some of the data sources you'll be working with are Ad Servers, Video Ad Servers, DSPs, DMPs, Ad Verification partners, Search & Social partners, Programmatic partners, and Campaign Management tools.
Want more jobs like this?
Get jobs in New York, NY delivered to your inbox every week.
YOU WILL BE EXPECTED TO
- Work closely with our Wavemaker counterparts to document reporting requirements and recommend optimal solutions.
- Construct the standard (aka 'Baseline') reporting infrastructure for new clients in Azure and customize it to meet individual client needs using SQL and/or Python code.
- In the execution of the above, you will need to:
- Create and modify data streams.
- Design, build and deploy custom ETL and data management processes.
- Review daily maintenance reports and communicate any issues to stakeholders.
- Report platform bugs to the engineering team and work closely on their resolution.
- Research new platform features.
- Optimize database performance and cost-efficiency of cloud-based processes.
- Maintain a high degree of knowledge in cloud data architecture and ETL best practices.
- Provision user access to Azure objects and SQL db.
- Formulate and execute robust UAT protocols to identify and address errors & data discrepancies.
- Draft build instructions for our offshore team and manage daily delivery of those.
- Proactively communicate project progress, issues and deliverables to Manager and stakeholders.
YOUR QUALIFICATIONS
- Bachelor's or Graduate degree in Statistics, Engineering, Computer Science, Economics, or related quantitative field.
- At least 1-2 years of relevant work experience, media analytics preferred.
- Strong SQL skills are a must.
- Knowledge of the advertising ecosystem, understanding of marketing metrics, and analytical products offered as a service is preferred.
- Familiarity with Azure (Data Factory, Azure Batch and/or Azure DataBricks) is preferred.
- Experience with other cloud-based platforms (GCP, AWS) is a plus.
- Python experience is a plus
- Tableau or other visualization tool experience is a plus.
- Exceptional organizational skills and detail oriented
- Strong critical thinking and problem-solving skills.
- Advance knowledge of MS Office Suite (Excel, Word, PowerPoint)
- Excellent written, oral, communication, project management, and presentation skills
GroupM Nexus brings together 9,000 practitioners globally across ad ops, addressable content & TV, AI, commerce, programmatic, search and social, among others, to deliver transformational outcomes across digital channels and platforms and create exciting new career paths for our people. GroupM Nexus is the world's largest performance engine that integrates paid, owned, and earned to deliver true business outcomes for our clients.
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, vision, and dental insurance, significant paid time off, preferential partner discounts, and employee mental health awareness days.
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, Wavemaker, EssenceMediacom, and T&Pm, and cross-channel performance (GroupM Nexus), data (Choreograph), entertainment (GroupM Motion Entertainment) and investment solutions, 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.
GroupM provides equal employment opportunities to applicants and employees without regard for factors such as race, religion, national origin, colour, sex, sexual orientation, gender identity or expression, age, protected veteran status, disability, or other protected status.
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 $45,000 to $90,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.