Sr. Executive / Assistant Manager - Sales MIS

চাকরির বিবরণ

Advanced Excel Analytics & Data Management Sales Reporting & MIS Management Variance Analysis & Process Automation

দায়িত্ব

• 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.
• 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.
• 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.
• 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.

যোগ্যতা

• 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.
• 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.
• Key Competencies

সুবিধা

• 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