Want to know if this job is worth applying to?
Johor, Malaysia
Onsite
When joining PerkinElmer, you select an experienced and trusted leader in scientific solutions, with the support of a global service network and distribution centers, providing the right solution, at the right time, to meet critical customer needs. With over an 80+ year legacy of advancing science and a mission of innovating for a healthier world, our dedicated team collaborates closely with commercial, government, academic and healthcare customers to deliver our broad portfolio of analytical solutions, and OneSource services.
Job Description
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.
