Data Analyst / Business Intelligence

Company Name: A WELL REPUTED GROUP OF COMPANY

Location: Dhaka

Job Type: Full-Time

Workplace Type: On-Site

Job ID: IJOB202672410

• Data Management & Reporting
• Extract, clean, and validate data from ERP and production systems.
• Design and maintain interactive dashboards and reports using Power BI.
• Prepare daily, weekly, and monthly MIS reports for management.
• Advanced Excel Analysis
• Perform complex data analysis using advanced Excel functions.
• Automate reporting tasks using Power Query, VBA, and formulas.
• Production & Inventory Analysis
• Analyze production efficiency (OEE), capacity, and bottlenecks.
• Monitor inventory, supply chain, and shipment performance.
• Identify trends in sales, quality defects (DHU), and lead times.
• Overhead Cost Analysis
• Analyze overhead costs (Utility, Labor, Maintenance, Depreciation) cost center-wise.
• Prepare Budget vs. Actual variance reports with root cause analysis.
• Calculate overhead absorption rates per unit/machine hour.
• Identify cost reduction opportunities and recommend corrective actions.
• Materials Consumption Report
• Prepare Yarn, Fabric, Accessories, and Chemical consumption reports (Actual vs. Standard).
• Reconcile BOM vs. Actual consumption for every order.
• Analyze wastage, rejection, and shrinkage at each production stage.
• Prepare order-wise, style-wise, and buyer-wise consumption reports.
• Calculate financial impact of material over-consumption or savings.
• Collaboration
• Work with Merchandising, Production, Accounts, and Procurement teams.

Coordinate with IT for ERP data structure improvements.

Requirements

• Experience: 1 to 3 years
• Education:
• BSc in CSE, Statistics, Mathematics, Data Science, or BBA (MIS/Finance/Accounting)., Educational background BBA/MBA with Commerce will be preferable
• Skills: Data Analysis

Last Date of Application: 31 October 2026