Data Engineer

Location: Gelang Patah, Johor, MY

Employment Type: Regular

Responsibilities:

• Manage, maintain, and continuously improve a portfolio of 40+ Power BI reports connected to 100+ data sources, ensuring data accuracy, performance optimization, and alignment with business needs.

• Collaborate with business stakeholders from Operations, Production, Engineering, Quality, Planning, Procurement, Service, Logistics and IT, to gather, analyze, and document reporting requirements, translating them into technical specifications.

• Architect and create SQL views and queries to support data models, reporting layers, and downstream analytics.

• Read, interpret, and refactor complex data pipelines to improve performance, readability, and maintainability across existing data infrastructure.

• Maintain and improve Python data pipeline scripts that extract, transform, and load data between SAP, Salesforce, ServiceMax, SFTP, Email, and MES systems, ensuring reliability and performance.

• Build and publish new Power BI reports and dashboards from initial requirements through final delivery, including data modeling, DAX measures, and visual design.

• Manage, monitor and troubleshoot PowerBI gateway, report refresh failures, data discrepancies, and pipeline issues; drive resolution in a timely manner.

• Document data pipelines, SQL views, and report logic to ensure knowledge transfer and sustainability of the reporting environment.

• Experience designing, implementing, and configuring both public and private API endpoints to enable seamless system integrations and scalable solutions.

Basic Qualifications:

• Bachelor’s degree in Computer Science, Information Systems, Data Engineering, or a related field, or equivalent work experience.

• Expert-level proficiency in Microsoft SQL Server, including complex query writing, performance tuning, stored procedures, CTEs, window functions, and view creation in production environments.

• Demonstrated ability to read and interpret complex, multi-layered SQL queries and understand underlying data structures.

• 3+ years experience creating and managing Python data pipelines and ETL for analytics use cases.

• 3+ years of hands-on Power BI development experience, including report building, data modeling, DAX authoring, and managing connections across a large number of diverse data sources.

• Proven ability to gather and translate business requirements into functional data and reporting solutions.

Preferred Characteristics:

• Experience maintaining a large Power BI report portfolio (40+ reports, 100+ sources) in an enterprise environment.

• Familiarity with Power BI Service administration, including workspaces, row-level security (RLS), and scheduled refresh management.

• Strong communication skills with the ability to present data findings and technical concepts to non-technical stakeholders.

• Knowledge of SAP, SAP Business Objects, SalesForce, ServiceMax, and SFTP systems to extract and move data.

• Experience in Python for data engineering tasks, including pipeline development, automation, data transformation, and integration (e.g., pandas, pyodbc, requests).

• Experience in VBScript for automation, scripting, and integration of tasks within the data environment.

• Detail-oriented with strong problem-solving skills and a proactive approach to identifying and resolving data quality issues.