Data Analyst (Transportation industry / Training provided) PNHP

PERSOL SINGAPORE PTE. LTD.; Singapore; On-site; SGD 54,000 - 78,000; Full time

Job summary

PERSOL SINGAPORE PTE. LTD. is seeking a data analyst to consolidate asset condition data and generate regulatory reports in Singapore. The role involves leveraging Excel, Python, and Power BI to support asset management and compliance tasks.

You will collaborate with engineering and cloud teams to develop ETL processes and dashboards, ensuring data quality and governance for NSM systems. Training is provided and Azure certifications are a plus.

Qualifications

• Experience in a data analysis role is advantageous.
• On-the-job training is provided.
• Proficient with Excel, Python and Power BI for data analysis.

Responsibilities

• Prepare regulatory compliance reports.
• Conduct failure and reliability trending for Track Infra and Building & Facilities Systems.
• Support Engineering and Systems Management on data governance and analytics.
• Develop ETL scripts to maintain NSM linear asset repository.
• Collaborate with Data Engineers and Cloud Solutions Architect on data pipelines and dashboards.

Skills

Excel proficiency

Python programming

Power BI proficiency

Education

Microsoft Azure Data Engineer certification

Microsoft Azure Data Scientist certification

Tools

Excel

Python

Power BI

Job description

Job Purpose:

Railway infrastructure such as tracks, tunnels and viaducts are inspected and monitored routinely to ensure safe use. Increasingly, the use of inspection technologies such as photo imaging systems, laser and ultrasonic scan systems are used alongside more traditional track visual inspections methods to determine the condition of the infrastructure. Railway buildings and facilities are also equipped with smart environmental control, pump monitoring, and lift control systems.

The defect and asset condition information from multiple inspection sources need to be aligned, processed, stored, and fused a linear asset data warehouse. The combined data can then be retrieved to 1) ascertain linear asset condition; 2) compliance to LTA code of practices; 3) fault diagnostics; 4) reliability centred maintenance program development; 5) spares provisioning.

Duties and Responsibilities:

• Prepare and vet regulatory compliance reports
• Perform failure and reliability trending of Track Infra and Building & Facilities Systems.
• Support Engineering and Systems Management on:

Support Tasks:

• Generation of asset condition reports
• Reliability improvement initiatives such as maintenance program reviews
• Spares provisioning Develop the data governance requirements for NSM entities
• Developing extract-transform-load (ETL) scripts to ensure a high level of data quality to upkeep of NSM linear asset repository
• Work with Data Engineers and Cloud Solutions Architect to implement data pipelines and dashboards.
• Ensure that people, process, and technology aspects of technology induction are addressed.
• Scout for and implement commercial off-the-shelf maintenance technologies

Qualifications and Work Experience:

• Work experience in a data analysis role is beneficial
• Training is provided
• Proficient in Excel Proficient in Python and its data science packages
• Proficient in Power BI
• Having Microsoft Azure Data Engineer certification & Microsoft Azure Data Scientist certification will be a bonus