BI Senior Analyst, GroupM India Offshoring Team, India
Role Context:
We are looking for a Business Intelligence and Data Visualization specialist who will 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 and validating the data to build dashboards for various clients, leading to analysis and optimization of media investments.
Core Responsibilities:
Data Integration and Transformation:
Extract and integrate data from multiple platforms using tools like Super metrics, APIs, or FTP into Google BigQuery .
Build and maintain automated data pipelines and workflows to ensure efficient and accurate data ingestion.
Data Analysis and Reporting:
Develop and maintain interactive dashboards and reports in Looker Studio or Power BI for visualizing key metrics.
Structure and automate End-of-Campaign ( EoC ) reports for scalable reporting.
Address ad hoc data requests and update dashboards based on evolving needs.
Data Validation and QA:
Ensure data accuracy by conducting QA between media platforms and reporting outputs using tools like SQL, Excel, and DAX.
Identify and resolve data discrepancies, monitor data feeds for gaps or failures, and troubleshoot issues.
Oversee QA processes for data provision to client data warehouses.
Taxonomy Governance and Collaboration:
Build maintain taxonomy workflows to ensure adherence to naming conventions across all media channels.
Collaborate with client teams to resolve data gaps and escalate issues as needed.
Required Skills / Experience:
Proven experience as a BI Analyst or similar role in data and analytics
2 - 4 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 Looker Studio is a must; knowledge of visual techniques for data analysis and presentation is a plus,
Experience with Looker BI for business logic design required.
Experience with pipeline tools like Supermetrics / Adverity is required
Experience working in Cloud environment (Google Cloud Platform),
Experience working with SQL required, experience with Python a plus,
Experience with the nuances of data granularity and limitations is required
Not afraid to ask questions or seek clarity, while being confident in providing thoughtful answers
Strong speaking and written professional communication skills,
Strong analytical, critical thinking, and problem-solving skills,
The ability to breakdown projects/requests and proactively action them
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.
More about GroupM:
GroupM - GroupM leads and shapes media markets by delivering performance enhancing media products and services, powered by data and technology. Our global network agencies and businesses enable our people to work collaboratively across borders with the best in class, providing them the opportunity to accelerate their progress and development. We are not limited by teams or geographies; our scale and diverse range of clients lets us be more adventurous with our business and talent. We give our talent the space, support and tools to innovate and grow.
Discover more about GroupM at www.groupm.com Follow @GroupMAPAC on Twitter Follow GroupM on LinkedIn - https: / / www.linkedin.com / company / groupm /
More about GroupM India Offshoring Team:
GroupM India Offshoring Team is the industry s largest community of performance marketing experts designed to drive performance and innovation at scale for GroupM s agencies and clients. With the most platform accreditations in the industry combined with proprietary technology, media, and solutions, culture of continuous innovation and scaled partnerships, GroupM Nexus consistently sets new benchmarks for effectiveness and efficiency across all forms of media to drive growth for the world s leading advertisers.
About India:
2020 brought opportunities for brands to innovate because of which we saw an evolving media stack. The growth of digital is set to soar high because of changing consumer habits. With approximately 500 million smartphone users, low-priced data plans, 45 to 50 million e-commerce shoppers, approximately 60 OTT offerings and a young population, India is a mobile-first internet market. It is also one of the top 10 ad spend markets in the world and is set to climb the ranks. Global big tech corporations have made considerable investments in top e-commerce/retail ventures and Indian start-ups, blurring the lines between social media, e-commerce, and mobile payments, resulting in disruption on an unimaginable scale.