Data Engineer
Gelang Patah Malaysia
Responsibilities
Location Gelang Patah, Johor MY Job ID REQ-057460Responsibilities:
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.
PerkinElmer is committed to creating a diverse environment and is proud to be an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity or expression, sexual orientation, national origin, genetics, disability status, age, or veteran status or any other characteristics protected by applicable law. PerkinElmer is committed to a culturally diverse workforce.
