Business Analyst ( MIS & Reporting )

Delhi Press Group; New Delhi; On-site; INR 600,000 - 900,000; Full time

Job summary

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

The candidate will prepare Excel-based dashboards, sales trackers, and management reports, with a focus on accuracy, timely submission, and data-driven insights to improve circulation and

Qualifications

• Graduate in Commerce, Business Administration, Statistics, Economics, or related field.
• 1–3 years of experience in MIS reporting, data analysis, or business analysis.
• Experience in publishing, print media, FMCG, or distribution industry preferred.
• Advanced knowledge of MS Excel: Pivot Tables, VLOOKUP/XLOOKUP, SUMIFS, COUNTIFS, data cleaning.
• Experience in dashboards, reports, and performance trackers.
• Strong analytical skills and attention to detail.
• Good communication and coordination skills.

Responsibilities

• Prepare and maintain daily, weekly, and monthly MIS reports for 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 targets versus achievements and highlight gaps.
• Prepare Excel dashboards and management reports.
• Analyze circulation trends, stock movement, and unsold copies to identify improvements.
• Track distributor orders, billing, and payments.
• Coordinate with regional teams, distributors, and internal departments to validate data.
• Ensure accuracy, timeliness of circulation reports.
• Identify data discrepancies and follow up for resolution.
• Improve reporting processes and automate MIS tasks.
• Provide data-driven insights to support circulation growth and efficiency.

Skills

MIS reporting

Data analysis

Business analysis

MS Excel advanced

Power BI

SQL

Communication

Deadline management

Education

Graduate in Commerce

Graduate in Business Administration

Graduate in Statistics

Graduate in Economics

Tools

Power BI

SQL

Job description

Business Analyst (MIS Reporting)

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.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.