We are looking for an Associate Director to join our Engineering Team at Universal McCann. A successful candidate should be a data minded, hands-on individuals with a technical academic background, entrepreneurial spirit and interest in media and marketing. You will be critical in hands-on data process management of our data ecosystem and to drive high client satisfaction. Curiosity and passion for data management and technologies is a must!
This position will be working across many key accounts that our agency covers, including J&J, Spotify, Coke, CVS, Sony, and more. You will also be reporting directly into the Engineering and Product Lead and responsible for major components of Universal McCann's product development
Primary day to day tasks will include designing database infrastructure, data aggregation strategies and wireframes for major project buildouts.
Creation and overseeing data ETLs, working with teams to establish raw data templates, reinforcing templatized data collection, and managing communication with client data teams/3rd parties agencies leveraging the data. Regular data quality checks including comparison, reformatting and researching new potential sources will be an integral part of the job as well.
Given the technical nature of the role, prior experience working with etls, ssis, python, sql and excel is a must. Any background working with media metrics and rules is also a strong plus.
* Lead design of engineering projects for data collection, processing and storage * Responsible for collecting, ingesting, auditing, processing, and the automation of all data feeds: * Candidate must have experience using SQL Server, T-SQL, SSIS and VB/C# * Experience in the following is a plus: Python * Manage and mentor junior analysts, engineers, and other managers who will be direct reports on the team. * Responsible for project managing builds, timelines, roadmaps and reporting back to leadership on progress * Work with cross-functional internal teams to establish data reporting templates and routines. This will involve onboarding and assessment of requirements and reviewing steps on site. * Work with team leads to establish operational/data requirements and help ensure adherence. * Primary point of contact for clients, internal teams and 3rd party agencies in regards to data delivery, comparisons and QA checks. * Lead & conduct training and operational improvements with teams on outlined processes. * Collaborate and provide quality assurance, process optimizations and work with data from multiple partners, clients and systems for analysis and reporting. * Candidate will lead ETL and automated data processing buildouts for key data sources across major clients * Become a subject matter expert of data management and capabilities. * Help manage Tableau data feeds and dashboard refreshes. Understand visualization platforms and how reporting/dashboard tools work. * Interest in analytics with emphasis on Marketing Mix Analysis. * Ability to work independently or collaboratively with strong time management and organizational skills. * Strong written and verbal communication skills (professional and technical).This role will involve working with multiple teams and clients in person, in addition to managing a team.
* Bachelor's Degree or above in: Information Systems, Computer Science, Data Science, Business Management, Statistics, Mathematics, or other related field.
Work Experience & Skills:
* At least 5+ years of experience in data specific function: SQL Server experience is a must. * Strong Technical Skills in SQL, VB/C#, Python, Tableau, Excel * Experience working with media data or agency experience is a strong plus * Strong communication, project management, and leadership skills
A full-service media agency, UM strives to use Better Science and Art to create moments that drive business momentum for brands. Founded in 1999, UM is made up of entrepreneurially-minded planners, researchers, investment experts, decision scientists, account executives, and content and activation specialists-over 4,800 employees across 130 offices in over 100 countries around the world. They are globally headquartered in New York, with six additional North America offices in Dallas, Detroit, Los Angeles, Miami, San Francisco, and Toronto.
UM's culture is an inclusive one, where people are encouraged to bring their full selves to the office, and where personal and professional growth are a priority of every member of the team. The executive leadership is dedicated to building a culture that permeates every element of the company, from work flexibility, to career planning and regular talent reviews, to an active culture club. They proudly uphold the following values:
* Courage: having the courage to try the things that make us afraid, present something to a client that we know isn't what they are expecting, taking on roles that we may be a bit intimidated by, inventing the future, etc. * Candor: pushing ourselves to have the hard conversations with colleagues, team members, clients and media partners that will make us all better. * Curiosity: being curious about the world, media, our clients and each other and using this curiosity to find new and innovate ways of doing everything we do. * Commitment: being committed to UM, our teams, and our clients and going above and beyond when it is required. * Community: being an active and positive participant in the UM community, our team and client communities, our local community and the world and creating valued communities with the people, clients and partners that we work with. * Caring: caring about those around us - both their work lives as well as their personal lives and working to make everyone have as complete and fulfilling a life as possible.
As a company, they are constantly pushing themselves to improve, under their Better Science, Better Art, Better Outcomes banner, striving to set the bar in the ever-evolving media landscape. Key clients include J&J, Sony, HULU, H&M, Coca-Cola, Hershey's, Spotify, ExxonMobil, and BMW.