Role Objective:

A key objective of this role is responsible for preparing, maintaining, and analyzing sales-related data for Direct International Business. The role focuses on monitoring sales performance, customer-wise sales, product-wise sales, region-wise sales, billing trends, order status, target achievement, and overall business growth analysis.

The position will support management by converting raw sales data into meaningful business insights through accurate reporting, analytical interpretation, and dashboard-based monitoring. The role requires strong analytical ability, attention to detail, problem-solving skills, and hands-on expertise in MIS tools, SAP, Excel, Power BI, and Power Query.

Desired Candidate Profile:

- Graduate in Commerce, Data Analytics, Business Administration, or a related field.
- Preferred certification or working knowledge in Advanced Excel, Power BI, Power Query, and SAP.
- 2–5 years of relevant experience in Sales MIS, Sales Analysis, Business Analysis, Sales Operations, Export Sales Support, Budgeting & Forecasting, or International Business MIS.
- Strong analytical mindset with the ability to interpret sales trends and generate actionable insights.
- Detail-oriented, proactive, solution-driven, and capable of handling multiple assignments simultaneously.
- Good communication and presentation skills.
- Ability to work independently with strong ownership and follow-up discipline.

Role & Responsibilities:

1. Sales MIS and Performance Reporting

- Prepare daily, weekly, monthly, and quarterly sales MIS reports for Direct International Business.
- Track sales performance against targets, budgets, forecasts, previous months, and previous years.
- Generate customer-wise, country-wise, region-wise, product-wise, and division-wise sales analysis reports.
- Ensure timely and accurate submission of management reports and business updates.

1. Sales Data Handling and Accuracy

- Collect, validate, clean, and consolidate sales data from SAP and other internal systems.




- Ensure accuracy of billing data, customer details, product information, sales figures, and order status.
- Identify and resolve data mismatches, duplicate records, missing information, and incorrect entries.
- Maintain structured and organized sales databases for effective reporting and analysis.

1. Sales Analysis and Business Insights

- Analyze sales trends, growth patterns, business gaps, and revenue opportunities.
- Perform variance analysis against targets, budgets, forecasts, pricing, previous month performance, and previous year trends.
- Provide meaningful business insights to support sales planning, strategic discussions, and management decision-making.
- Support identification of key business drivers and improvement opportunities.

1. SAP-Based Sales Reporting

- Extract sales orders, billing, invoice, customer, and product-related data from SAP.
- Reconcile SAP data with MIS reports to ensure data accuracy and consistency.
- Coordinate with relevant departments for clarification and resolution of SAP-related data discrepancies.

1. Power BI / Power Query Dashboard Management

- Utilize Power Query for data cleaning, transformation, and automation.
- Support development and maintenance of Power BI dashboards for sales monitoring.
- Create dashboards for target vs achievement analysis, region-wise sales, customer contribution, product contribution, sales trends, and pending orders.
- Improve reporting efficiency through automation and enhanced visualization techniques.

1. Sales Review and Presentation Support

- Prepare weekly, monthly, quarterly, and annual sales review presentations.




- Develop business review decks and management summaries in a professional and accurate format.
- Support leadership teams with analytical data required for business review meetings and strategic discussions.

1. Coordination and Stakeholder Management

- Coordinate with internal stakeholders for collection and validation of sales-related information.
- Ensure all reports and dashboards reflect the actual business status and operational updates.
- Maintain effective communication with cross-functional teams for timely data availability and reporting accuracy.

Functional Skills Required:

- Advanced Microsoft Excel (Pivot Tables, VLOOKUP/XLOOKUP, Power Pivot, Formulas, Dashboards)
- Power BI and Power Query
- SAP Sales Reporting and Data Extraction
- Sales MIS Reporting and Data Management
- Sales Analysis and Business Analytics
- Data Validation and Reconciliation
- Budgeting and Forecasting Analysis
- Presentation Preparation using PowerPoint
- Reporting Automation and Visualization

Behavioral Skills Required:

- Strong analytical and logical thinking ability
- Attention to detail and high level of accuracy
- Solution-oriented and proactive approach
- Smart working with effective time management
- Ownership and accountability
- Strong follow-up and coordination skills
- Ability to multitask and work under deadlines
- Positive communication and interpersonal skills
- Team collaboration and stakeholder management
- Positive attitude and willingness to learn

Team Size to be Manage:

- Reports to: Manager SFE
- Reportee: Individual Contributor role

Important Links:

- Website: https://biotechhealthcare.com/
- LinkedIn: https://www.linkedin.com/company/biotechhealthcare/
- Instagram: Biotech Vision Care

Biotech is an Equal Opportunity Organisation promoting diversity while ensuring no discrimination on any ground including gender, race, religion, age, sexual orientation, disability, etc.

📌 Management Information System Executive (Ahmedabad)
🏢 Biotech Healthcare
📍 Ahmedabad