Commercial Excellence
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
• Bachelor’s 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)
Interested can share updated cv to Saloni Pimenta on search@talismanstaffing.com or What's app : 9136435341
Company Profile
Our client is an American MNC Pharmaceutical Company.
Apply Now
- Interested candidates are requested to apply for this job.
- Recruiters will evaluate your candidature and will get in touch with you.