SENIOR DATA ANALYST

Job Summary

The Senior Data Analyst is responsible for analyzing, cleansing, validating, and managing business data throughout the ERP implementation lifecycle.

This role works closely with key users, project managers, ERP consultants, and IT teams to ensure accurate data migration, reporting, process alignment, and successful ERP system deployment.

Key Responsibilities

1. ERP Data Analysis \& Management

• Analyze existing business data from legacy systems and databases.
• Identify data inconsistencies, duplication, and quality issues.
• Define data standards, structures, and governance policies.
• Prepare and manage master data including:
• Customer master
• Supplier master
• Material/item master
• BOM (Bill of Materials)
• Inventory data
• Production routing and recipe
• Financial data

2. Data Migration \& Validation

• Lead ERP data migration activities from old systems to the new ERP platform.
• Perform data mapping between source and target systems.
• Develop data cleansing and validation procedures.
• Coordinate user verification and sign-off for migrated data.
• Ensure data accuracy during trial runs and go-live stages.

3. Business Process Analysis

• Gather and document business requirements from departments.
• Analyze workflow and identify gaps between current processes and ERP functions.
• Recommend process improvements and automation opportunities.
• Support ERP configuration discussions with consultants/vendors.

4. API Integration/ SQL connection \& System Connectivity

• Coordinate API integration or SQL connection between ERP and external systems such as:
• Epicor System
• HRMS
• Accounting systems
• WellKnit, ViewTex, Datacolor, LogicArt.
• Analyze API data structure, field mapping, and transaction flow.
• Work with software developers and vendors to troubleshoot API communication issues.
• Validate API integration results and monitor transaction accuracy.
• Support real-time and scheduled data synchronization processes.
• Prepare API integration documentation and testing scenarios.
• Monitor integration logs and error handling mechanisms.

5. IoT Machine Integration \& Smart Manufacturing Support

• Support IoT integration between factory machines and ERP/MES systems.
• Coordinate machine data collection including:
• Production output
• Machine running status
• Downtime
• Efficiency (OEE)
• Barcode/RFID scanning data
• Weight scale integration
• Sensor/device data
• Work with automation vendors and engineers on machine communication protocols such as:
• OPC
• Modbus
• MQTT
• TCP/IP
• RS232/RS485
• Validate machine-generated data before ERP posting.
• Monitor data accuracy and system connectivity stability.
• Support smart factory and Industry 4.0 initiatives.
• Assist in dashboard development for production monitoring and machine analytics.

6. Reporting \& Dashboard Development

• Develop operational and management reports.
• Create dashboards and KPI tracking tools.
• Support departments with data-driven analysis and reporting requirements.
• Monitor ERP data accuracy and reporting consistency.
• Develop real-time production and machine monitoring dashboards.

7. Testing \& User Support

• Support UAT (User Acceptance Testing) and system trial runs.
• Prepare test scenarios and validate transaction results.
• Troubleshoot data-related ERP and integration issues.
• Provide support and guidance to key users during implementation.
• Support go-live stabilization and post-implementation monitoring.

8. Documentation \& Training

• Prepare SOPs, integration flowcharts, and technical documentation.
• Document API specifications and machine integration setup.
• Conduct user training related to data handling, reporting, and integration workflows.
• Maintain implementation records and data audit trails.

Requirements

Education

• Bachelor’s Degree in:
• Information Technology
• Computer Science
• Data Analytics
• Business Information Systems
• Accounting / Finance (with strong ERP experience)

Experience

• 5+ years experience in:
• ERP implementation
• Data analysis
• Business systems
• Manufacturing or supply chain environment
• Experience with any ERP systems.

Technical Skills

• Strong SQL and database knowledge
• Advanced Microsoft Excel skills
• Experience with:
• Power BI
• Tableau
• SSRS
• ERP reporting tools
• Understanding of:
• MRP
• Inventory control
• Production planning
• Finance processes
• Supply chain operations

Soft Skills

• Strong analytical and problem-solving skills
• Good communication and coordination ability
• Able to work with cross-functional departments
• Detail-oriented and highly organized
• Strong project coordination skills

Preferred Industry Experience

• Manufacturing
• Textile / Garment
• Warehouse \& Distribution
• Retail Supply Chain

Pay: RM4,500.00 - RM6,500.00 per month

Work Location: In person