Software Engineer (Python)

ALPHA X TECHNOLOGY PTE. LTD.; Singapore; On-site; SGD 90,000 - 150,000; Full time

Job summary

ALPHA X Technology PTE. LTD. seeks a Software Engineer to help design and implement data pipelines and BI processes within the semiconductor manufacturing domain. The role involves managing Oracle-based data environments and delivering end-to-end BI from ingestion to visualization, on-site at a partner facility.

You will work with Python to build APIs, develop data models, ETL workflows, and collaborate with BI developers to produce Power BI dashboards and KPI reports for manufacturing analytics.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field.
• Minimum 3 years of data engineering, data integration, or BI development.
• Proficient in Python for data extraction, APIs, and JSON manipulation.
• Strong data warehousing, schema design, and ETL best practices.
• Experience with Oracle, SQL Server, MySQL, PostgreSQL and stored procedures.
• Proficiency with ETL tools (Pentaho Kettle, Informatica, Talend, etc.).
• Experience building Power BI (or Tableau/Qlik) reports and dashboards.
• Knowledge of SQL pipelines, data validation, and replication tools.
• Excellent written and verbal communication; able to work cross-functionally.

Responsibilities

• Design, develop, and maintain Python-based apps and APIs to deliver JSON data.
• Create robust data models for querying and reporting.
• Define relationships, hierarchies, and calculated columns/measures.
• Build ETL workflows for manufacturing data (ERP, MES, SPC, FDC).
• Implement database logic including PL/SQL scripts and stored procedures.
• Develop staging schemas, data validation, and transformation logic.
• Create data marts and dimensional models for analytics.
• Collaborate with BI developers to deliver Power BI dashboards and KPI reports.
• Ensure data accuracy and consistency across source systems.
• Support data governance, documentation, and performance tuning.
• Engage stakeholders to ensure timely, high-quality data delivery.

Skills

Python

Data Engineering

ETL

Power BI

SQL

APIs

Data Warehousing

Documentation

Education

Bachelor’s degree

Tools

Pentaho Kettle

Informatica

Talend

Oracle

SQL Server

MySQL

PostgreSQL

Job description

1. Position Summary

We are looking for a Software Engineer to join our team and contribute to a major project within the semiconductor manufacturing domain. The role involves designing and implementing data pipelines, managing Oracle-based data environments, and supporting end-to-end BI processes — from data ingestion to visualization. This position is based on-site at our partner’s advanced manufacturing facility, offering hands‑on exposure to large‑scale industrial data systems.

2. Key Responsibilities

• Design, develop, and maintain Python-based applications and APIs to extract, transform, and deliver data in JSON format.
• Design and create robust data models to support efficient querying and reporting.
• Define relationships, hierarchies, and calculated columns/measures that align with business logic.
• Design, develop, and maintain data pipelines and ETL workflows for manufacturing data (ERP, MES, SPC, FDC, etc.).
• Implement and optimize database logic, including stored procedures, functions, and PL/SQL scripts.
• Build and manage staging schemas, data validation processes, and data transformation logic.
• Develop and maintain data marts and dimensional models to support analytics and reporting.
• Collaborate with BI developers and analysts to deliver Power BI dashboards, KPI reports, and visual analytics.
• Ensure data accuracy, consistency, and completeness across multiple source systems.
• Support data governance, documentation, and performance tuning efforts.
• Partner with internal and external stakeholders to ensure timely and high-quality data delivery for business use.
• Perform any ad-hoc duties assigned by the Company as and when required.

3. Qualifications & Skills

• Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field.
• Minimum 3 years of experience in data engineering, data integration, or BI development.
• Proficient in Python programming, specifically for data extraction, API development, and JSON data manipulation.
• Strong understanding of data warehousing concepts, schema design, and ETL best practices.
• Solid working experience with relational databases (e.g. Oracle, SQL Server, MySQL, PostgreSQL), including stored procedures and query optimization.
• Proficient with ETL tools such as Pentaho Kettle, Informatica, Talend, or similar.
• Experience developing reports and dashboards in Power BI (or Tableau/Qlik).
• Familiarity with SQL pipelines, data validation, and data replication tools.
• Strong analytical and problem-solving mindset with attention to data quality and performance.
• Ability to work collaboratively with business, IT, and engineering teams in fast-paced environments.
• Excellent documentation and communication skills.

4. Preferred / Additional

• Experience in semiconductor or manufacturing systems (ERP, MES, SPC, FDC) preferred.
• Exposure to data replication frameworks (Oracle Golden Gate, SharePlex, AWS Glue) is an advantage.
• Experience developing custom Python applications/APIs for data extraction and familiarity with JSON data structures is highly preferred.
• Familiarity with cloud-based data warehouses (Snowflake, Redshift, Synapse) and Giga Report is a plus.
• Knowledge of data governance frameworks, metadata management, and data security best practices.