Business Analyst (MIS & Reporting)

Delhi Press Group; Delhi; On-site; INR 520,000 - 760,000; Full time

Job summary

Delhi Press Group is seeking a detail-oriented Business Analyst for its Circulation Department. The role focuses on MIS reporting, analyzing circulation and sales data, tracking distributor performance, and preparing reports to support business planning and decision-making.

The candidate will prepare daily, weekly, and monthly MIS reports, analyze data across subscriptions, returns, and distribution, and develop Excel dashboards to drive operational efficiency.

Qualifications

• Graduate in Commerce, Business Administration, Statistics, Economics, or a related field.
• 1-3 years of experience in MIS reporting, data analysis, or business analysis.
• Experience in publishing / distribution industry will be preferred.
• Advanced knowledge of MS Excel (Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, COUNTIFS).
• Experience in dashboards, reports, and performance trackers.

Responsibilities

• Prepare and maintain daily, weekly, and monthly MIS reports related to circulation and sales.
• Consolidate and analyze data on magazine sales, subscriptions, returns, dispatches, and distribution.
• Track distributor-wise, territory-wise, and publication-wise sales performance.
• Monitor sales targets versus achievements and highlight performance gaps.
• Prepare Excel-based dashboards, sales trackers, and management reports.
• Analyze circulation trends, stock movement, unsold copies, and returns to identify improvements.
• Track distributor orders, billing, outstanding payments, and other circulation metrics.
• Coordinate with regional teams, distributors, and internal departments to collect and validate data.
• Ensure accuracy, consistency, and timely submission of all circulation reports.
• Identify discrepancies and follow up for resolution.
• Improve reporting processes and automate MIS tasks where possible.
• Provide data-driven insights to support circulation growth and efficiency.

Skills

Excel

Data analysis

Power BI

SQL

Education

Commerce degree

Statistics degree

Tools

Power BI

SQL

Job description

Experience: 1-3 Years
Location: Delhi
Industry Preference: Publishing / Print Media

Job Summary

Delhi Press is looking for a detail-oriented and analytical Business Analyst for its Circulation Department. The primary responsibility will be to manage MIS reporting, analyze circulation and sales data, track distributor performance, and prepare reports to support business planning and decision-making.

Key Responsibilities

• Prepare and maintain daily, weekly, and monthly MIS reports related to magazine circulation and sales.
• Consolidate and analyze data on magazine sales, subscriptions, returns, dispatches, and distribution.
• Track distributor-wise, territory-wise, and publication-wise sales performance.
• Monitor sales targets versus achievements and highlight performance gaps.
• Prepare Excel-based dashboards, sales trackers, and management reports.
• Analyze circulation trends, stock movement, unsold copies, and returns to identify improvement opportunities.
• Track distributor orders, billing, outstanding payments, and other relevant circulation metrics.
• Coordinate with regional teams, distributors, and internal departments to collect and validate data.
• Ensure accuracy, consistency, and timely submission of all circulation reports.
• Identify discrepancies in sales and distribution data and follow up with the concerned teams for resolution.
• Improve existing reporting processes and automate repetitive MIS tasks wherever possible.
• Provide data-driven insights to management to support circulation growth and operational efficiency.

Required Skills & Qualifications

• Graduate in Commerce, Business Administration, Statistics, Economics, or a related field.
• 1-3 years of experience in MIS reporting, data analysis, or business analysis.
• Experience in the publishing, print media, FMCG, or distribution industry will be preferred.
• Advanced knowledge of MS Excel, including Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, COUNTIFS, and data cleaning.
• Experience in preparing dashboards, reports, and performance trackers.
• Knowledge of Power BI and SQL will be an added advantage.
• Strong analytical skills, numerical accuracy, and attention to detail.
• Good communication and coordination skills.
• Ability to manage multiple reports and meet deadlines.

Preferred Candidate Profile

A data-driven professional with strong Excel and MIS reporting skills, preferably with an understanding of magazine circulation, distribution networks, sales analysis, and returns management.