Data Engineer (Python & SQL)

ITCAN PTE. LIMITED; Singapore; Sur place; SGD 120 000 - 180 000; Plein temps

Résumé du poste

ITCAN PTE. LIMITED is seeking a Data Engineer to design, build, and maintain robust data infrastructure supporting statistical production processes.

You will lead data pipelines, ETL processes, and data architecture while guiding engineering standards across the team. You will translate business needs into robust technical solutions, modernising legacy workflows and ensuring outputs align with production results.

Qualifications

• Proficient in Python and SQL for complex data transformations and quality monitoring.
• Experience designing and implementing production-grade data solutions at scale.
• Strong ETL, batch processing, and data pipeline architecture skills.
• Proficient in Linux/Unix shell scripting and CLI tools.

Responsabilités

• Lead the architecture, design and implementation of ETL processes and data pipelines across multiple sources.
• Build and maintain large-scale batch and real-time data pipelines with proper failure handling and monitoring.
• Develop production-quality code for statistical production processes and modernise legacy workflows.
• Lead data model design, schema design and performance optimisation for large datasets.
• Promote reusable components, libraries, and configuration frameworks to standardise workflows.
• Establish CI/CD for data workflows and manage environments (Development, UAT, Production).
• Oversee version control with GitLab, code reviews, and documentation of architectures.
• Troubleshoot production incidents and optimise system performance for large-scale data.
• Provide mentoring to data engineers and guide solution designs and implementation choices.
• Collaborate with business users to translate requirements into robust technical solutions.

Connaissances

Python

SQL

Data pipelines

ETL

Data architecture

Code reviews

CI/CD

Outils

GitLab

CI/CD tooling

Linux

Description du poste

Role Overview

The Data Engineer works closely with statisticians, analytical teams, and business stakeholders to design, build, and maintain the data infrastructure needed to support rigorous statistical production processes. The role centres on building reliable and maintainable data pipelines, validation and frameworks that support statistical production processes, while providing technical leadership across the engineering team.

You will work closely with the user team on the business needs, translate them into robust technical solutions and lead in the modernization of legacy processes. This includes ensuring that existing business logic is preserved and that outputs are accurately reconciled against current production results. In addition, you will provide technical guidance on solution design, engineering standards, and implementation approaches to ensure the team delivers production-quality solutions.

Key Responsibilities

• Leads the architecture, design, and implementation of ETL processes, workflows, and data pipelines for the ingestion, transformation, and integration of data from multiple source agencies.
• Build and maintain efficient and reliable large-scale batch and real-time data pipelines with data processing frameworks, including dependency management, failure handling, recovery, and operational monitoring.
• Develop and maintain modular, production-quality code for statistical production processes, including uplifting of legacy processes while preserving business logic and reconciling outputs against existing results. Review complex business logic and provide technical direction for migration and modernisation activities.
• Lead database and data model design, including schema design, storage patterns and performance optimisation for large-scale statistical datasets.
• Design and drive the adoption of reusable data engineering components such as common libraries, configuration frameworks, logging standards, and utilities to streamline production workflows and promote consistent engineering practices across the team.
• Design and implement CI/CD for data engineering workflows to automate testing and deployment, and establish workflows to safely isolate and synchronise Development, UAT, and Production environments.
• Lead the design and configuration of complex pipeline workflows and schedules using enterprise tools, including dependency management, failure handling, recovery and operational monitoring.
• Establish version control structures using GitLab, set up code review frameworks, and document technical architectures. Provide technical reviews for solution designs, merge requests and implementation approaches, and promote appropriate engineering standards across the development team.
• Troubleshoot production incidents, monitor pipeline health, and continuously optimise system performance for large-scale datasets. Lead the investigation of complex production issues, identify root causes, and implement preventive and performance improvement measures.
• Lead and provide technical guidance and mentoring to data engineers, including support on coding practices, solution design, troubleshooting and implementation decisions.
• Collaborate with technical team, business users and other stakeholders to translate complex business and statistical processing requirements into robust technical solutions.
• Identify technical risks, dependencies and improvement opportunities, and recommend appropriate design or implementation approaches.

Required Skills & Experience

• Professional experience in data engineering, data platform development, or a related software engineering role, with demonstrated experience designing and implementing production-grade data solutions at scale.
• Strong proficiency in Python and SQL, including experience in complex data transformations, analysis, and quality monitoring, with the ability to design, review and optimise complex processing logic.
• Strong experience with batch processing, ETL, data integration and data pipeline architecture.
• Strong working knowledge of Linux/Unix environments, shell scripting and command-line tools for data processing
• Strong understanding and practical application of software engineering practices such as modular design, configuration management, logging, exception handling, testing, and technical documentation, with experience defining or applying engineering standards for production systems.
• Experience with designing technical solutions and making engineering trade-off decisions involving performance, maintainability, scalability and operational reliability.
• Experience with leading or providing technical guidance for data pipeline development, system migration or modernization initiatives.
• Experience with conducting code reviews and mentoring or providing technical guidance.
• Experience with version control using Git, including branching strategies, merge requests, code review, and CI/CD pipelines for automated testing and deployment
• Experience with cloud platforms and orchestration/CI-CD tooling is preferred.
• Excellent problem-solving, analytical, and communication skills, with the ability to work independently in an agile team environment while providing technical leadership when resolving complex engineering problems.