Job Description

Job Description – Operations & Data Analyst

n

About the Role

n

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.

n

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.

n

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.

n

Key Responsibilities

n

Data Management & Reporting

n

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

n

Operations Data & Analysis

n

n
- Track and analyse operational data including order processing, production, inventory, dispatch, delivery, returns, exchanges and other key operational metrics.
n
- Identify delays, exceptions, recurring issues, process gaps and operational inefficiencies.
n
- Monitor operational KPIs and highlight areas requiring immediate attention.
n
- Maintain action trackers and follow up on pending operational issues.
n

n

Sales Data & Analysis

n

n
- Pull and maintain daily, weekly and monthly sales data.
n
- Track sales performance, orders, revenue, conversion, customer trends and other relevant sales KPIs.
n
- Analyse sales trends and identify gaps, opportunities and areas of improvement.
n




- Reconcile sales data across different sources and ensure reporting accuracy.
n
- Provide management with clear observations and insights from sales performance.
n

n

Marketing Data & Analysis

n

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

n

Business Insights & Management Reporting

n

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

n

Documentation & Process Management

n

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

n

Skills Required





n

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

n

Qualifications

n

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

n

Experience

n

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

n

Preferred Knowledge

n

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

n

Ideal Candidate

n

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.

n

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.

n

Key Approach

n

Collect → Clean → Analyse → Identify → Insight → Recommend → Track

📌 Operations and data analyst (Mumbai)
🏢 Roology HQ
📍 Mumbai