AmbitionBox
Search
Jobs
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
All Filters
91 EssenceMediacom Jobs
BI Senior Analyst
EssenceMediacom
posted 2hr ago
Job Role Insights
Fixed timing
Key skills for the job
Job Description
Description
Position at GroupM Nexus
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:
About India:
#LI-Offshore
Employment Type: Full Time, Permanent
Read full job description What people at EssenceMediacom are saying
What EssenceMediacom employees are saying about work life
based on 15 employees
Strict timing
Monday to Friday
No travel
Day Shift
EssenceMediacom Benefits
View more benefits
Compare EssenceMediacom with
WPP
Compare
Publicis
Compare
Dentsu Communications
Compare
Havas Worldwide
Compare
IPG
Compare
Madison India
Compare
Groupm Media
Compare
Ogilvy
Compare
Lowe Lintas
Compare
Cheil India
Compare
TCS
Compare
Accenture
Compare
Wipro
Compare
Cognizant
Compare
Capgemini
Compare
HDFC Bank
Compare
Infosys
Compare
ICICI Bank
Compare
HCLTech
Compare
Tech Mahindra
Compare
Similar Jobs for you
Share an Interview