Analytics Engineer - Modern Data Pipelines & Cloud Platform

Sciente International Pte Ltd; Singapore; On-site; SGD 70,000 - 110,000; Full time

Job summary

Sciente International Pte Ltd is seeking a mid-level Analytics Engineer / Data Engineer to build and modernize data pipelines and analytics platforms for a leading bank. You will craft reliable data flows, analytical models, and reusable logic using modern cloud technologies.

The role requires 3–6 years of data engineering exposure, strong SQL and Python, plus experience with dbt and orchestration tools such as Airflow or Cloud Composer.

Qualifications

• Degree in Computer Science, Data Analytics, Information Technology or related field.
• 3–6 years of experience in Data Engineering, Analytics Engineering, Data Warehousing, or related areas.
• Strong hands-on experience with SQL.
• Proficient Python for data processing and automation.
• Strong dimensional data modelling knowledge (Star schemas, Fact/Dimension tables, Data marts).
• Hands-on experience with dbt or equivalent data transformation framework.
• Experience with workflow orchestration tools such as Airflow or Cloud Composer.
• Solid understanding of ETL/ELT concepts and data warehousing.
• Knowledge of semantic layers, business metrics, and reusable business logic.
• Familiarity with Git/version control, code reviews, testing, CI/CD.
• Ability to troubleshoot data quality and pipeline issues independently.

Responsibilities

• Design, develop, and maintain data pipelines and analytic datasets.
• Develop and optimize SQL-based transformations and data models.
• Build and maintain dimensional data models (fact/dimension tables, star schemas, data marts).
• Develop data transformation workflows using dbt or equivalent frameworks.
• Manage workflows with Airflow, Cloud Composer, or equivalent tools.
• Implement reusable business logic and common metrics.
• Support development of semantic and analytical layers.
• Implement data quality checks, testing, validation, and monitoring.
• Investigate and resolve data, pipeline, and transformation issues.
• Identify root causes and apply corrective actions.
• Follow software engineering best practices (Git, reviews, testing, CI/CD).
• Collaborate with Data Engineers, Analytics Engineers, Developers, Analysts, and Business Stakeholders.
• Understand and migrate legacy/.NET processes as needed.
• Advocate modern cloud-based data engineering and analytics practices.
• Ensure data solutions are reliable, scalable, maintainable, and reusable.
• Support BI and reporting with trusted datasets.

Skills

SQL

Python

Dimensional modelling

dbt

Airflow

ETL/ELT

Data warehousing

Git/CI-CD

Data quality

Data modeling

Education

Degree in CS/IT/Data Analytics

Tools

GCP

dbt

Apache Airflow

Cloud Composer

Job description

Sciente International Pte Ltd is seeking a mid-level Analytics Engineer / Data Engineer to build and modernize data pipelines and analytics platforms for a leading bank. You will craft reliable data flows, analytical models, and reusable logic using modern cloud technologies.

The role requires 3–6 years of data engineering exposure, strong SQL and Python, plus experience with dbt and orchestration tools such as Airflow or Cloud Composer.