Operations and data analyst

Roology HQ; Mumbai; On-site; INR 600,000 - 900,000; Full time

Job summary

Roology HQ in Mumbai is seeking an Operations & Data Analyst to manage business data, maintain reports and trackers, and provide insights to support management decisions. The role collaborates across Operations, Sales and Marketing, pulling data from multiple systems, cleaning it, and turning it into structured dashboards and actionable recommendations.

Strong Excel/Sheets skills, detail orientation and proactive problem-solving are essential as you monitor KPIs, identify inefficiencies, and

Qualifications

• Strong Excel/Google Sheets skills and data handling experience.
• Experience building and maintaining dashboards and reports across teams.
• Ability to pull data from multiple sources and ensure reporting accuracy.

Responsibilities

• Pull and consolidate data across Operations, Sales and Marketing from different teams and systems.
• Maintain trackers, dashboards and MIS reports with accurate formatting and validations.
• Analyse operational, sales and marketing data to identify trends, gaps and improvement opportunities.
• Prepare structured reports and data summaries for management review meetings.

Skills

Google Sheets

Data collection & validation

Data analysis & reporting

Pivot Tables & lookups

Analytical thinking

Attention to detail

Cross-functional coordination

Data storytelling

Education

Bachelor’s degree in Business/Commerce/Finance/Economics/Statistics/Data Analytics

Tools

Shopify

CRM platforms

Google Analytics

Logistics platforms

Google Drive

Automation tools

Job description

Job Description – Operations & Data Analyst

About the Role

We are looking for an Operations & Data Analyst to manage business data, maintain accurate reports and trackers, analyse operational performance, and provide meaningful insights to support management decisions.

The role will work closely across Operations, Sales and Marketing, with responsibility for pulling data from different teams and systems, consolidating it, analysing performance and highlighting important business insights.

The ideal candidate is analytical, organised, detail-oriented and proactive, with strong hands‑on knowledge of Excel/Google Sheets and the ability to work across multiple business functions.

Key Responsibilities

Data Management & Reporting

• Pull and consolidate data across Operations, Sales and Marketing from different teams, platforms and business systems.
• Collect, organise, clean and validate data to ensure reports are accurate and up to date.
• Maintain structured trackers, dashboards, MIS reports and management reports.
• Ensure strong sheet hygiene through correct formatting, formulas, dropdowns, validations, naming conventions and duplicate checks.
• Cross-check and reconcile information across multiple reports and data sources.
• Coordinate with teams to collect missing information and ensure timely updates.

Operations Data & Analysis

• Track and analyse operational data including order processing, production, inventory, dispatch, delivery, returns, exchanges and other key operational metrics.
• Identify delays, exceptions, recurring issues, process gaps and operational inefficiencies.
• Monitor operational KPIs and highlight areas requiring immediate attention.
• Maintain action trackers and follow up on pending operational issues.
• Pull and maintain daily, weekly and monthly sales data.
• Track sales performance, orders, revenue, conversion, customer trends and other relevant sales KPIs.
• Analyse sales trends and identify gaps, opportunities and areas of improvement.
• Reconcile sales data across different sources and ensure reporting accuracy.
• Provide management with clear observations and insights from sales performance.

Marketing Data & Analysis

• Pull and consolidate data from marketing channels, campaigns and platforms.
• Track key marketing metrics such as traffic, leads, enquiries, campaign performance, customer acquisition and conversions.
• Maintain marketing performance trackers and dashboards.
• Analyse campaign and channel performance to identify what is working, what is not and where improvements may be required.
• Coordinate with the marketing team/agency to ensure data is collected and reported accurately and on time.

Business Insights & Management Reporting

• Analyse daily, weekly and monthly business performance across Operations, Sales and Marketing.
• Track KPIs, trends, delays, exceptions, gaps and areas requiring attention.
• Prepare structured reports and data summaries for management and review meetings.
• Convert raw data into observations, insights and actionable recommendations.
• Highlight unusual trends, inconsistencies or potential business risks proactively.

Documentation & Process Management

• Maintain SOPs, process documentation, meeting notes and action trackers.
• Keep reporting systems and trackers organised and easy for teams to use.
• Follow up on key action points and ensure timely closure.
• Help improve reporting processes, data collection systems and business dashboards.
• Identify opportunities to reduce manual work and improve reporting efficiency through basic automation.

Skills Required

• Strong knowledge of Google Sheets
• Data collection, cleaning, consolidation and validation
• Data analysis and management reporting
• Pivot Tables, XLOOKUP/VLOOKUP, SUMIFS, COUNTIFS and basic dashboards
• Strong analytical and problem-solving ability
• High attention to detail and data accuracy. Ai workflow and automation.
• Good communication and cross-functional coordination
• Ability to understand business metrics and identify trends
• Strong documentation and organisational skills
• Ability to present data and insights clearly during meetings
• Ability to work with data across Operations, Sales and Marketing

Qualifications

• Bachelor’s degree in Business Administration, Commerce, Finance, Economics, Statistics, Data Analytics or a related field.
• Strong practical knowledge of data handling and Excel/Google Sheets will be given significant importance.

Experience

• 1–3 years of experience in Operations, MIS, Business Analytics, Data Analysis, Reporting or a similar role.
• Experience handling trackers, dashboards, MIS reports and management reporting is preferred.
• Experience working with data across multiple departments will be an added advantage.
• Strong freshers with excellent Excel/Google Sheets and analytical skills may also be considered.

Preferred Knowledge

• Exposure to tools such as Shopify, CRM platforms, Google Analytics, logistics platforms, Google Drive and basic automation tools will be an added advantage.

Ideal Candidate

We are looking for someone who does not just update data, but can understand what the numbers mean, identify gaps, find possible reasons and recommend the next course of action.

You should be comfortable working across Operations, Sales and Marketing, pulling data from different sources and bringing it together into one clear view of business performance.