Commercial Excellence

Talisman Hr Solutions; Mumbai; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Talisman HR Solutions in Mumbai seeks a BI/ MIS analyst to design and automate MIS reports, dashboards, and commercial analytics. You will transform complex data from ERP/CRM systems into actionable insights to support sales and operations.

The role emphasizes Excel/VBA automation, Power Query data transformation, and Power BI dashboard development for performance tracking and decision support.

Qualifications

• Bachelor's degree in a related field.
• Min 4 years in MIS, Commercial Analytics, or Data Analytics.
• Proven experience automating MIS reports and analytics.

Responsibilities

• Develop automated MIS reports and dashboards.
• Build Excel-based tools and automation with VBA/Macros.
• Consolidate data from multiple systems into a unified reporting structure.
• Design power BI dashboards for commercial and sales performance.
• Ensure data quality, governance, and timely delivery.

Skills

Excel Expert

VBA Macros

Power Query

Power BI

Data Integration

Analytical Thinking

ERP/CRM Data

Automation

Education

Bachelor's degree

Tools

SAP

Salesforce

Oracle

Job description

Role Purpose

• Design, develop, and automate business reporting, MIS reports, and performance dashboards.
• Integrate data from multiple systems to provide actionable business insights and support commercial decision-making.
• Leverage advanced Excel, VBA/Macros, Power Query, and Power BI to transform complex datasets into meaningful business matrices and reports.

Ideal Candidate Profile

• Highly analytical BI professional with strong expertise in Excel, VBA/Macros, Power Query, and Power BI.
• Experienced in integrating data from multiple sources and converting complex customer- and product-level data into actionable business insights.
• Strong understanding of commercial analytics, business reporting, and data-driven decision-making.

Key Responsibilities

• Develop automated MIS reports, performance dashboards, and management reporting frameworks.
• Build advanced Excel-based tools and automation solutions using VBA/Macros, Power Query, and advanced formulas.
• Consolidate and integrate data from multiple internal and external systems into a unified reporting structure.
• Combine data across platforms, systems, products, customers, and channels to generate meaningful business insights.
• Establish automated data workflows to improve reporting accuracy, efficiency, and turnaround time.
• Develop customer-level and product-level matrices to support strategic and operational decision-making.
• Identify business trends, opportunities, risks, and key performance drivers.
• Design and deploy interactive Excel and Power BI dashboards for commercial and sales performance tracking.
• Ensure data quality, consistency, and governance across reporting systems.
• Support forecasting, target setting, incentive calculations, and performance reviews.

Required Qualifications

• Bachelors degree in Engineering, Statistics, Mathematics, Computer Science, Business Analytics, or a related field.
• Minimum 4 years of experience in MIS, Commercial Analytics, or Data Analytics.
• Proven experience in developing and automating MIS reports and sales analytics solutions.

Technical Skills

Mandatory Skills

• Expert-level Microsoft Excel.
• Advanced VBA/Macros programming and automation.
• Power Query for data transformation and integration.
• Intermediate-level Power BI dashboard development.
• Strong analytical and problem-solving skills.
• Experience integrating data from multiple databases, ERP, CRM, and other business systems.

Preferred Skills

• Experience with SAP, Salesforce, Oracle, or similar enterprise systems.
• Experience in Commercial Excellence or Sales Analytics.

Key Competencies

• Strong business acumen and analytical thinking.
• Ability to translate business requirements into effective analytical solutions.
• Process improvement and automation mindset.
• Strong problem-solving and data interpretation skills.
• Ability to work independently in a fast-paced environment.

Success Measures

• Reduction in manual reporting effort through automation.
• Improved reporting accuracy, consistency, and data governance.
• Timely delivery of dashboards, reports, and actionable business insights.
• Successful integration of multiple data sources into a single source of truth.

Additional Details :

Designation: Commercial Excellence

Location: Mumbai (BKC)

Working days: 5 Days

Work timings: 9:00am To 5:00pm (Candidate need to be flexible)

Gender Preference: Male / Female

Interview Process: Virtual Interview , Face to face interview

Contract period, auto-renewable or not: 1 year. Can be renewed with evaluation.

On Third Party Payroll (Talisman HR)