Job Summary
Triveni Byapar Company Pvt. Ltd. (Triveni Group) is seeking an experienced and detail-oriented MIS professional for the position of MIS Officer – Assistant Manager. The selected candidate will be responsible for managing and improving Management Information Systems (MIS), developing accurate reports and interactive dashboards, and transforming import, trading, inventory, and sales data into meaningful insights to support effective business decisions.
The role requires strong analytical skills, advanced MS Excel proficiency, and the ability to coordinate with multiple departments to ensure data accuracy, reporting efficiency, and continuous improvement in business operations.
Key Responsibilities
Develop, maintain, and regularly update MIS reports covering procurement, import tracking, inventory, sales, and dispatch operations.
Design and maintain advanced Excel dashboards and automated reporting templates to monitor business performance and key performance indicators (KPIs).
Collect, consolidate, clean, validate, and standardize data from different departments, including Purchase/Import, Warehouse, Sales, and Finance.
Monitor and investigate discrepancies in inventory, pricing, supplier and customer records, and recommend appropriate corrective actions.
Extract and consolidate operational data from ERP systems, databases, and spreadsheets into standardized reporting formats.
Prepare periodic and ad-hoc analytical reports for management, including business trends, performance analysis, variance reports, and operational insights.
Ensure data accuracy, consistency, proper documentation, and version control of all MIS reports and dashboards.
Coordinate with relevant departments to improve data management, reporting processes, and overall operational efficiency.
Identify opportunities to automate reporting processes and minimize manual work.
Job Specifications / Requirements
Bachelor's degree in Management, Business Studies, Statistics, Computer Science, or a related field.
Minimum 3 years of relevant experience in MIS, data analytics, business reporting, or operational reporting, preferably in a trading or import-based organization.
Advanced proficiency in MS Excel, including Pivot Tables, XLOOKUP/VLOOKUP, SUMIFS, and other advanced formulas.
Proven ability to develop and maintain Excel dashboards, KPI reports, and structured reporting templates.
Strong knowledge of data cleaning, validation, reconciliation, and standardization techniques.
Ability to automate recurring reports using Excel formulas, named ranges, and efficient workbook structures.
Basic understanding of import and trading operations, including inventory movement, supplier documentation, pricing, and Goods Receipt Note (GRN) processes.
Familiarity with database management and reporting tools, including basic SQL and data extraction from ERP or other operational systems.
Strong analytical, problem-solving, and numerical skills.
Excellent attention to detail with the ability to manage multiple reporting requirements and meet deadlines.
Preferred Qualifications (Added Advantages)
Practical experience with Power Query, Excel Macros, VBA, or similar tools for reporting automation.
Knowledge of business intelligence and data visualization tools such as Power BI or Tableau.
Understanding of inventory costing methods, including FIFO and Weighted Average Costing.
Experience working with ERP systems and integrating data from multiple operational sources.
What We Offer
Opportunity to work closely with cross-functional teams across import, procurement, inventory, warehouse, and sales operations.
Professional growth opportunities with potential progression toward broader Assistant Manager-level responsibilities.
Supportive and collaborative working environment within the Triveni Group.
Opportunities for continuous learning, skill development, and professional advancement.
Employee benefits as per company policy and applicable Nepalese labour laws.