Intern, Data Engineering and Automation (PNPL)

Phillip Capital Inc.; Singapore; On-site; SGD 20,000 - 27,000; Part time

Job summary

Phillip Nova Pte Ltd is offering an intern position in Data Engineering and Automation to support Phillip Nova’s data infrastructure. The role centers on building, optimizing, and documenting ETL pipelines and automation projects using SQL and Python for financial services.

The intern will contribute to CI/CD deployment, data quality testing, and planning for LLM/datawarehouse initiatives while gaining hands-on experience in a buzzing fintech environment.

Qualifications

• Undergraduate student in a data-focused field seeking hands-on experience in data engineering and automation.
• Experience with data modelling and data architecture concepts is required.
• Proficiency in SQL and Python, plus API integration familiarity.
• Foundational understanding of Generative AI and LLMs is preferred.

Responsibilities

• Propose automation, AI or data engineering solutions based on business needs.
• Build, maintain, and improve ETL/ELT pipelines and data transformation jobs in a data warehouse.
• Implement and maintain CI/CD pipelines for data solution deployment and testing.
• Assist in planning LLM and data warehouse implementations.
• Ensure data quality and integrity with automated tests and validation rules.
• Help document the data warehouse and build a data catalogue.

Skills

Data modelling

Data architecture

SQL

Python

API integration

Generative AI

LLMs

CI/CD basics

SSMS/SSIS

Education

Undergraduate majoring in Data Science / Statistics / Computer Science / Quantitative Finance / Business Analytics / Economics / Mathematics

Tools

Microsoft SQL Server tools (SSMS, SSIS)

Job description

Intern, Data Engineering and Automation (PNPL)

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)