Overview
Data Engineer Jobs in Gelang Patah, Johore, Malaysia at PerkinElmer
Title: Data Engineer
Company: PerkinElmer
Location: Gelang Patah, Johore, Malaysia
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.
