Intern, Data Engineering and Automation (PNPL)

Phillip Securities Pte Ltd; Singapore; On-site; SGD 11,000 - 17,000; Part time

Job summary

Phillip Nova Pte Ltd in Singapore is seeking a Data Engineering and Automation Intern to help build, optimize, and document ETL pipelines and automation solutions. The role emphasizes SQL and Python to implement data automation projects, including API integrations and data manipulation scripts for business-critical financial services.

Join the data team to design tests, maintain CI/CD pipelines, and contribute to cataloguing the data warehouse while exploring Generative AI and LLM initiatives in

Qualifications

• Proficiency in data modelling and data architecture.
• SQL, Python, and API integration are required.
• Foundational understanding of Generative AI and LLMs.

Responsibilities

• Propose automation or data engineering solutions based on business needs.
• Build and maintain ETL/ELT pipelines in the data warehouse.
• Implement CI/CD pipelines for data solution deployment.
• Assist in designing LLM and data warehouse implementations.
• Ensure data quality by automated tests and validation rules.
• Document the data warehouse and catalog the data assets.

Skills

SQL

Python

Data modelling

Data Architecture

API integration

Generative AI basics

Education

Undergraduate major in relevant field

Tools

SSMS

SSIS

Job description

Job Description:

The Data Engineering and Automation Intern will play a key role in supporting Phillip Nova’s data infrastructure by building, optimizing, and documenting our ETL pipelines and automation solutions. This hands‑on position requires proficiency in SQL and Python to design and implement data automation projects, including API integrations and data manipulation scripts, to deliver business‑critical solutions in the financial services domain.

Key Responsibilities:

• Propose automation, AI or data engineering solutions based on business needs.


• Build, maintain, and introduce best practices to ETL/ELT pipelines and data transformation jobs in our data warehouse.


• Implement and maintain CI/CD pipelines alongside our testing environment for data solution deployment, ensuring seamless integration.


• Assist in designing and planning LLM and data warehouse implementations.


• Ensure high data quality and data integrity by designing and implementing automated tests and validation rules across all implemented pipelines.


• Help the data team build a catalogue and document the data warehouse.

Requirements:

• Undergraduate majoring in Data Science / Statistics / Computer Science / Quantitative Finance / Business Analytics / Economics / Mathematics / other relevant majors.


• Proficient in Data modelling, Data Architecture.


• Proficient in SQL, Python programming and API integration.


• Foundational understanding of Generative AI and LLMs.


• (Optional) Familiarity with CI/CD practices and automated deployment on Git.


• (Optional) Familiar with Microsoft SQL Server tools (SSMS, SSIS).

We regret that only shortlisted candidates will be notified.

Brought to you by Phillip Nova Pte Ltd (A member of PhillipCapital)