Data Engineer Job at PerkinElmer (Gelang Patah)

Job Responsibility

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.

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.

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.