Sr. Executive / Assistant Manager - Sales MIS

Job Description

Title: Sr. Executive / Assistant Manager - Sales MIS

Company Name: ABDUL MONEM LTD. (BEVERAGE UNIT)

Vacancy: --

Age: Na

Job Location: Dhaka

Salary: --

Experience:

• 5 to 7 years

• BBA / MBA or bachelor’s degree in Business Administration, Statistics, Applied Mathematics, Finance, Data Analytics or a related discipline from a reputed university.

• 5 to 7 years

• Experience: 5–7 years of relevant experience in Sales MIS, Commercial Analytics, Data Modeling or Business Intelligence, preferably in FMCG, consumer goods or the Beverage industry.
• Technical Expertise (Must-have): Advanced MS Excel including XLOOKUP, INDEX-MATCH, Dynamic Arrays, Power Query, Data Modeling, VBA/Macros and Power BI including DAX, interactive visuals and Power BI Service.
• Sales Operations Knowledge: Understanding of primary and secondary sales, distributor management, route-to-market and sales data structures.
• Systems & Software: Familiarity with ERP systems such as SAP or Oracle, Sales Force Automation (SFA) tools and SQL/database querying is an advantage.
• Location & Mobility: Based at Corporate Head Office, Dhaka, with coordination across regions and field sales teams as required.

Key Competencies

• Analytical & Problem-Solving: Strong numerical acumen, critical thinking and ability to turn complex datasets into practical business insights.
• Technical Expertise: Advanced Excel and Power BI skills, with a focus on automation, data modeling and clear visualization.
• Accuracy & Data Integrity: Strong attention to detail and commitment to producing consistent, reliable and timely reports.
• Communication & Coordination: Ability to collaborate with field sales teams, regional leadership and senior management.
• Work Style: Results-oriented, self-motivated and capable of prioritizing tasks under tight corporate reporting deadlines.

Location: Corporate Head Office, Dhaka

Department: Sales & Marketing

About Abdul Monem Ltd.

Abdul Monem Ltd. (AML) is one of the leading diversified conglomerates in Bangladesh, with a rich history of over 50 years. Our Beverage Unit is a vital component of our success, producing and distributing popular beverage brands nationwide. We are committed to excellence, innovation, and sustainable growth, offering a dynamic and challenging environment for professionals to thrive.

Executive Role Summary

Lead sales reporting and MIS processes through advanced analytics, automated dashboards and accurate performance tracking, providing timely insights to support commercial planning and management decisions.

Key Responsibilities & Deliverables

Dashboard Development & Data Modeling

• Design, build and maintain interactive Power BI dashboards to track daily, weekly and monthly sales volume, revenue and performance.
• Develop reliable data models and automated reporting solutions for leadership and field sales teams.
• Monitor dashboard refreshes and resolve data inconsistencies in coordination with relevant teams.

Advanced Excel Analytics & Data Management

• Use advanced MS Excel functions, Power Query, Dynamic Arrays, Pivot Tables, Data Validation and VBA/Macros to clean, consolidate and process large datasets.
• Integrate data from multiple sources and maintain accurate, structured datasets for analysis and reporting.
• Apply data validation and reconciliation checks to ensure accuracy and consistency of sales information.

Sales Reporting & MIS Management

• Prepare daily sales updates, target-versus-achievement trackers, secondary sales reports, distributor stock statements and monthly executive MIS packs.
• Monitor territory-, region- and sales-officer-wise targets, achievements, incentives, commissions and trade scheme performance.
• Deliver timely and accurate reports to support sales reviews, business planning and management decisions.

Variance Analysis & Process Automation

• Analyze sales trends, seasonal demand, price-volume mix, market growth and performance gaps; highlight exceptions and business risks.
• Automate manual reporting through Power Query pipelines, data connections and scheduled Power BI refreshes.
• Coordinate with Regional Sales, Commercial, Supply Chain, Finance and IT/ERP teams to maintain data integrity and improve reporting workflows.

Abdul Monem Ltd. offers a competitive remuneration package, including: Negotiable Salary (commensurate with experience and competence) Festival Bonuses Leave Encashment A dynamic and supportive work environment with opportunities for professional growth and career advancement