Senior Business Intelligence Analyst
Description
We are a global communications agency leading with breakthrough thinking, building explosive growth for brands, and helping our clients see the bigger picture. Our daring global network of 10,000 influencers help our clients breach traditional boundaries in media, uncover novel ideas, and unleash exponential growth. GroupM Nexus Hub challenges conventional thinking to build, propel, and supercharge our clients’ businesses at scale and lead our industry in critical areas such as diversity, equity, inclusion, and sustainability.
GroupM Nexus Hub understands that our people are tasked with big goals: building breakthrough growth for brands and leading with breakthrough thinking in our industry. Our people are at the heart of this work because their ideas will enable us to decode the intersections of people, content, and technology to bring our aspirations to life. Our success is down to our eclectic, diverse, and talented people. GroupM Nexus Hub is a place for us to grow our careers and expand our horizons. GroupM Nexus Hub is committed to building an agency culture that supports our people, puts diversity at the forefront of our operations, and creates opportunity for all. This collective culture will be our “new power” where ideas are freely exchanged, and collaboration is actively encouraged in a place where you can innovate in our hyperconnected world.
Role Context:
We are looking for a Business Intelligence and Data Visualization specialist who will build assist in the development and maintenance of the reporting infrastructure to help stakeholders gain insights in their advertising campaigns. In this role, he/she will be responsible for retrieving, compiling, and transforming data to create the intelligence layer leading to analysis and optimization of media investments.
Core Responsibilities:
- Manage the QA of data between media platforms and reporting outputs using tools such as Alteryx, SQL, and/or Excel
- Manage and identify data gaps that require manual entry, escalate to investment teams, and collect, QA, and process returned manual data. This includes initiating the data collection process, communicating any data QA issues, and working with teams to resolve those issues.
- Monitor data feeds for gaps or failures and action where necessary to resolve failures
- Build and maintain automated data QA workflows using Alteryx
- Update Tableau dashboards based on new/additional requests
- Build and maintain taxonomy generators and enforcers (via Excel, Google Sheets, and Alteryx) to assist in the adherence of taxonomy across all media channels.
- Setup and maintain automated data feeds/pipelines through API (Adverity), FTP, and/or scheduled email report)
- Troubleshoot any data discrepancies or issues that might occur,
- Fulfill ad hoc data pulls required for client deliverables,
- Manage the QA of data provisioning to MMM vendors or for client data warehouses.
Required Skills / Experience:
- Bachelor’s degree in Marketing, Advertising, Economics, Computer Science, Information Systems, Business Analytics or related field with 1 – 3 years of work experience in data management, data visualization and data analytics preferably in a marketing and/or media agency.
- Experience with building dashboards in Tableau is required; knowledge of visual techniques for data analysis and presentation is a plus,
- Experience with Alteryx for business logic design required
- Experience working in Cloud environment (Azure, GCP),
- Experience working with SQL required, experience with Python a plus,
- Experience working with digital data from ad serving platforms (e.g., Google Campaign Manager, Other ad servers), campaign planning tools (e.g. Prisma, MediaOcean), website analytics software (e.g. Adobe Analytics, Google Analytics), paid search engine marketing data sources (e.g. Adwords, Marin, …) and others is strongly preferred,
- Strong speaking and written professional communication skills,
- Strong analytical, critical thinking, and problem-solving skills,
- The ability to thrive in a fast-paced and deadline-driven environment,
- Strategic Thinker & Doer,
- Curious and excited to learn,
- High sense of accountability and ownership,
- Collaborative with a partnership mindset.
En atención a la naturaleza del cargo en Modalidad de Teletrabajo o Híbrido que desempeñará el candidato, se informa que el trabajo deberá realizarse dentro del Territorio Colombiano, por lo que la aplicación a este cargo únicamente es posible para personas domiciliadas y con permiso de trabajo en el territorio nacional. Así mismo, se aclara que el contrato de Teletrabajo no es una opción para la contratación o cambio de domicilio en el extranjero.
#LI-PM1