Senior Executive – Analytics (Datorama) at The world’s largest media investment company · Gurugram, Bengaluru (Bangalore) · 3 - 8 years · ₹7L - ₹14L / yr · Posted 25 Sep 2023
Senior Executive – Analytics (Datorama)
at The world’s largest media investment company
Hi,
About the co.–Our client is an agency of the world’s largest media investment company which is a part of WPP. It is a global digital transformation agency with 1200 employees across 21 nations. Our team of experts support clients in programmatic, social, paid search, analytics, technology, organic search, affiliate marketing, e-commerce and across traditional channels.
Job Location: Gurgaon/Bangalore
Responsibilities of the role:
Manage extraction of data sets from multiple marketing/database platforms and perform hygiene and quality control steps, either via Datorama or in partnership with Neo Technology team. Data sources will include: web analytic tools, media analytics, customer databases, social listening tools, search tools, syndicated data, research & survey tools, etc…
Implement and manage data system architecture Audit and manage data taxonomy/classifications from multiple systems and partners
Manage the extraction, loading, and transformation of multiple data sets
Cleanse all data and metrics; perform override updates where necessary
Execute all business rules according to requirements Identify and implement opportunities for efficiency throughout the process.
Manage and execute thorough QA process and ensure quality and accuracy of all data and reporting deliverables
Manipulate and analyze “big” data sets synthesized from a variety of sources, including media platforms and marketing automation tools
Generate and manage all data visualizations and ensure data is presented accurately and is visually pleasing
Assist analytics team in running numerous insights reports as needed Help maintain a performance platform and provide insights and ongoing recommendations around.
What you will need:
3+ years’ experience in an analytics position working with large amounts of data
Hands-on experience working with data visualization tools such as Datorama, Tableau, or PowerBI Additional desirable skills include tag management experience, application coding experience, statistics background
Digital media experience background preferred, including knowledge of Doubleclick and web analytics tools
2 hour overlap with NY or Chicago in the morning (EST or CST time zones)
Excellent communication skills
Regards
Team Merito

Similar jobs (4)

Job Title: Senior Data Analyst
Location: Sharnam Metrolinks, Amraiwadi, Ahmedabad
Working Days: 6 Days a Week
Department: MDO
Reporting To: COO
Employment Type: Full-Time
Job Summary
We are seeking a highly analytical and detail-oriented Senior Data Analyst to lead data management, reporting, automation, and system development initiatives across the organization.
The role focuses on transforming raw data into meaningful insights, designing and implementing automated systems, strengthening data structures, and supporting cross-functional teams with accurate, actionable intelligence to drive strategic and operational business decisions.
Key Responsibilities
1. Data Management & Reporting
● Collect, clean, validate, and consolidate data from multiple internal and external sources.
● Prepare and deliver daily, weekly, and monthly MIS reports for management and departments.
● Design, develop, and maintain dashboards to track KPIs, performance metrics, and operational trends.
2. Database & Data Accuracy Management
● Manage and regularly update internal databases, spreadsheets, and reporting systems.
● Ensure data accuracy, consistency, integrity, and confidentiality across all platforms.
● Implement best practices for data validation, version control, and audit checks.
3. Data Analysis & Business Insights
● Analyze large and complex datasets to identify trends, patterns, gaps, and anomalies.
● Translate data findings into clear, actionable insights and recommendations to support
strategic and operational decision-making.
4. Reporting Automation, System Recommendation & Implementation
● Identify opportunities to replace manual or semi-manual processes with automated, data-driven systems.
● Design and implement automated reporting frameworks, dashboards, and data pipelines using Excel (Power Query, VBA, Macros), SQL, BI tools, and Python.
● Proactively suggest new automation tools, system enhancements, or integrations to
improve efficiency, accuracy, and scalability.
● Lead the end-to-end implementation of approved automation initiatives, including requirement gathering, system design, testing, deployment, and stabilization.
● Continuously monitor and optimize automated systems in line with business growth and evolving data needs.
5. Cross-Functional Coordination & Support
● Collaborate with Sales, HR, Finance, Operations, and other departments to understand
reporting and data requirements.
● Provide support for ad-hoc analysis, custom reports, and special data requests.
● Act as a data partner to department heads for decision support and performance tracking.
6. Documentation & Compliance
● Maintain complete and updated documentation for MIS processes, reports, data models,
automation logic, and system changes.
● Ensure compliance with company data governance policies and applicable data protection standards.
System Development & Data Structuring Responsibilities
● Study and understand departmental workflows to evaluate how data is generated, processed, and utilized.
● Review existing manual and digital data systems to identify operational gaps, risks, and
mprovement opportunities.
● Recommend structured data models, reporting formats, and storage solutions aligned with
business requirements.
● Coordinate with department heads to define data structures, access levels, and reporting
standards.
● Implement new or upgraded data systems (Excel-based models, cloud platforms, ERP
integrations) with minimal operational disruption.
● Design structured data formats and role-based access controls to ensure secure and
organized data management.
● Train employees on newly implemented systems and provide post-implementation
support.
● Monitor system performance, resolve issues, and continuously improve systems based on
user feedback and organizational growth.
Qualifications & Experience
● Bachelor’s degree in Commerce, Statistics, Computer Applications, or a related field.
● 3–5 years of experience in data analytics, reporting, or system automation roles.
● Strong analytical thinking, logical reasoning, and problem-solving abilities.
● High attention to detail with excellent organizational and documentation skills.
Technical Skills (Must Have)
● Advanced Excel: Power Query, Power Pivot, VBA basics, Macros, Charts
● BI Tools: Power BI or Tableau (DAX, data modeling, dashboard optimization)
● Google Apps Script: Automation in Google Sheets, custom functions, triggers, API integrations, workflow optimization
● Vlook
Preferred Skills
● Strong verbal and written communication skills
● Ability to handle sensitive and confidential information responsibly
● Quick learner with a tech-savvy, improvement-driven, and solution-oriented mindset
Strong Data Analyst Profile with Python, SQL, and data-pipeline expertise, ideally with retail / e-commerce datasets
2
Mandatory (Experience 1): Must have 4+ years of hands-on data-analyst experience, working with large datasets across areas such as sales, inventory, pricing, promotions, and customer behaviour.
3
Mandatory (Tech skill 1): Must have strong hands-on Python for data processing, transformation, automation, and analysis
4
Mandatory (Tech skill 2): Must have strong SQL skills, including complex queries, joins, aggregations, and data validation.
5
Mandatory (Tech skill 3): Must have a solid understanding of Data Lake architecture, ingestion, storage, and processing workflows
6
Mandatory (Tech skill 4): Must have hands-on experience with ETL / ELT pipelines, data integration, and transformation
7
Mandatory (Tech skill 5): Must have experience with Azure or GCP data services.
8
Mandatory (Tech skill 6): Must have understanding of or experience with Databricks and distributed data processing.
9
Mandatory (Tech skill 7): Must have knowledge of data modeling, data warehousing, and Lakehouse architecture
10
Mandatory (Tech skill 8): Must have experience with Power BI, Tableau, or Excel for reporting.
11
Mandatory (Communication): Must have strong analytical, documentation, and stakeholder-communication skills.
12
Mandatory (Education): Must hold a Bachelor’s degree in Computer Science, IT, Engineering, or a related field.
13
Mandatory (Note1): This is a 6-month contract role. Candidate must be comfortable with the contract engagement and able to join immediately (urgent — onboarding within ~a week)
About the Role
We are looking for enthusiastic Data Analytics Interns to join our team remotely for a 3-month internship. This is an excellent opportunity to gain hands-on experience in data analysis, data visualization, database management, and reporting. The selected candidates will have the opportunity to work on real projects, analyze datasets, and develop their technical and analytical skills.
Responsibilities
- Assist in collecting, cleaning, organizing, and analyzing datasets.
- Work with SQL and databases for data retrieval, manipulation, and analysis.
- Use Microsoft Excel to organize data, perform calculations, and prepare reports.
- Assist in creating dashboards and visualizations using Power BI or Tableau.
- Work with Python libraries such as Pandas and NumPy for data analysis.
- Perform exploratory data analysis to identify trends, patterns, and insights.
- Prepare reports and presentations based on analytical findings.
- Assist in tracking key performance indicators (KPIs) and monitoring business data.
- Maintain accurate documentation of data analysis activities and project contributions.
- Collaborate with team members on data-related projects and analytical tasks.
Requirements
- Basic knowledge of Data Analytics and data analysis concepts.
- Understanding of SQL and database fundamentals.
- Familiarity with Microsoft Excel and data management.
- Basic knowledge of Python is preferred.
- Familiarity with data visualization tools such as Power BI or Tableau is an advantage.
- Strong analytical and problem-solving skills.
- Good research and organizational abilities.
- Attention to detail and accuracy.
- Ability to work independently in a remote environment.
- Good communication skills and eagerness to learn.
What You'll Gain
- Real-world experience in data analytics and business intelligence.
- Hands-on experience with data cleaning, analysis, and visualization.
- Exposure to industry-relevant tools such as SQL, Python, Excel, and Power BI.
- Mentorship and exposure to practical analytical processes.
- Completion Certificate at the end of the internship.
- Letter of Recommendation based on performance.
- Opportunity to strengthen your portfolio with real-world data projects.
Internship Details
- Duration: 3 months
- Location: Remote (Work from Home)
- Perks: Completion Certificate + Letter of Recommendation

We are looking for a Lead – Information Systems who can combine strong Salesforce/CRM expertise, advanced Excel skills, MIS reporting and business analytics to support data-driven decision-making.
🔹 What We’re Looking For
• Minimum 4 years of hands-on experience with CRM systems, preferably Salesforce
• Minimum 3 years of practical Salesforce experience preferred
• Advanced proficiency in Microsoft Excel, including:
Advanced formulas, Pivot Tables, Power Query, Data analysis, Automation
• Strong experience in MIS reporting, data validation, analysis and presentation of insights
• Proven experience creating and maintaining dashboards, KPI reports and management reports
• Good technical aptitude with the ability to understand business processes and convert them into effective reporting solutions
• Basic to intermediate understanding of finance and business metrics, including revenue, costs, budgeting and financial reporting concepts
• Strong analytical and problem-solving skills
• Excellent stakeholder management and communication skills
• Ability to work independently and convert data into actionable business insights
🔹 Key Responsibilities
• Manage and analyze data from Salesforce/CRM and other business systems
• Develop and maintain MIS reports, dashboards and KPI trackers
• Ensure data accuracy, validation and consistency across reports
• Analyze business data and identify trends, gaps and opportunities
• Translate business requirements into meaningful reports and dashboards
• Work closely with business and functional stakeholders to understand reporting requirements
• Support management with timely and accurate business insights and performance reports
• Identify opportunities to improve reporting processes through Excel, Power Query and automation
• Support CRM-related reporting and process improvements
🎯 Ideal Candidate
Someone who is comfortable working at the intersection of CRM + MIS + Excel + Business Analytics, and can go beyond preparing reports to explain what the data means and what action the business should take.







