Senior Data Engineer

OPTIMUM SOLUTIONS (SINGAPORE) PTE LTD; Singapore; In loco; SGD 120.000 - 180.000; Tempo pieno

Descrizione del lavoro

OPTIMUM SOLUTIONS (SINGAPORE) PTE LTD seeks a Senior Data Engineer to design, build, deploy and maintain reliable data pipelines on a cloud-based platform using AWS and Databricks. Lead data ingestion, transformation, quality, lineage and observability for analytics, reporting and ML workloads.

You will architect Bronze/Silver/Gold layers, implement incremental ingestion and CDC, and ensure scalable, secure data products. Strong Python, PySpark, SQL and AWS/Databricks experience are essential.

Competenze

• Degree in Computer Science, Software Engineering, Data Engineering, Information Systems or a related technical discipline.
• 6+ years of relevant data or software engineering experience, including hands‑on design and operation of production data pipelines and at least 2 years with cloud platforms.
• Strong Python, PySpark and SQL capabilities for distributed processing, transformations, testing and debugging.

Mansioni

• Data Pipeline Architecture and Delivery: design and implement maintainable batch and streaming pipelines across AWS and Databricks.
• Lakehouse and Data Product Engineering: design Bronze, Silver, Gold data layers and reusable data products with clear ownership.
• Source Integration: implement ingestion from databases, files, APIs and event streams with full-load, incremental and CDC patterns.
• Data Quality and Contracts: enforce schemas, data contracts, automated validation and anomaly checks.
• Orchestration and Deployment: build parameterised workflows with Databricks Workflows or Lakeflow; integrate CI/CD and IaC.
• Metadata, Lineage and Governance: implement metadata, lineage and access controls using Unity Catalog, AWS Glue Data Catalog or Lake Formation.

Conoscenze

Python

PySpark

SQL

Data modeling

Data quality

Data governance

CI/CD

Terraform

Git

Distributed processing

Formazione

Degree in Computer Science, Software Engineering, Data Engineering, Information Systems or related technical discipline

Strumenti

Databricks

Apache Spark

Delta Lake

AWS S3

AWS Glue

Lake Formation

IAM

KMS

Lambda

Step Functions

EventBridge

CloudWatch

Redshift

MSK/Kinesis

Terraform

CI/CD

Git

Descrizione del lavoro

Role Overview

The Senior Data Engineer is responsible for designing, building, deploying and maintaining reliable data pipelines and reusable data products on a cloud-based data platform using AWS and Databricks. The role provides technical leadership across data ingestion, transformation, modelling, quality, lineage, orchestration, observability and performance, ensuring data remains dependable for analytics, reporting and ML/AI workloads.

Key Responsibilities

• Data Pipeline Architecture and Delivery: Lead the design and implementation of maintainable batch and streaming pipelines that ingest, validate, transform and publish structured, semi-structured and unstructured data across AWS and Databricks.
• Lakehouse and Data Product Engineering: Design Bronze, Silver and Gold data layers using Delta Lake or equivalent patterns; develop reusable domain data models, curated datasets and data products with explicit ownership, definitions and service expectations.
• Source Integration and Incremental Processing: Implement reliable ingestion from databases, files, APIs and event streams using full-load, incremental, change-data-capture and replayable processing patterns appropriate to each source.
• Data Quality and Contracts: Establish schema enforcement, data contracts, automated validation, reconciliation and anomaly checks covering completeness, validity, consistency, uniqueness, timeliness and referential integrity.
• Orchestration and Deployment Automation: Build parameterised workflows using Databricks Workflows or Lakeflow and relevant AWS services; integrate automated testing, infrastructure as code and CI/CD controls across development, test and production environments.
• Metadata, Lineage and Governance: Implement technical metadata, business definitions, end-to-end lineage, classification, ownership and access controls using Unity Catalog, AWS Glue Data Catalog, Lake Formation or approved platform capabilities.
• Pipeline Monitoring and Reliability: Define dashboards, alerts, logging, operational metrics and runbooks for pipeline health, freshness, data-quality failures, latency, throughput and downstream impact; lead troubleshooting and root-cause analysis.
• Performance and Cost Optimisation: Optimise Spark and SQL workloads, file sizes, partitioning, clustering, caching, compaction, cluster configuration and workload scheduling to improve runtime, reliability and AWS/Databricks cost efficiency.
• Security and Data Protection: Apply least-privilege IAM, encryption, secrets management, environment separation, audit logging, sensitive-data controls and secure data-sharing patterns in line with applicable security and compliance requirements.
• Technical Leadership and Quality: Set engineering standards, review designs and code, mentor engineers, manage technical debt and promote reusable components rather than project-specific pipelines.
• Stakeholder Collaboration: Work with data owners, stewards, analysts, data scientists, architects, product teams and governance stakeholders to translate analytical and operational needs into implementable data specifications.
• Documentation and Knowledge Transfer: Maintain architecture decisions, source-to-target mappings, data models, contracts, operating procedures and support documentation, and transfer knowledge to the internal team throughout the engagement.

Requirements & Qualifications

Education: Degree in Computer Science, Software Engineering, Data Engineering, Information Systems or a related technical discipline.

Experience: Minimum 6 years of relevant data or software engineering experience, including hands‑on design and operation of production data pipelines and at least 2 years working with cloud-based data platforms. Candidates should demonstrate technical leadership through architecture, engineering standards, code review, mentoring or ownership of critical data services.

Essential (Must-Have)

• Strong Python, PySpark and SQL capability, including distributed processing, complex transformations, query optimisation, debugging and automated testing.
• Hands‑on experience with Databricks, Apache Spark and Delta Lake for production-scale batch or streaming data engineering.
• Hands‑on AWS data engineering experience with a relevant combination of services such as S3, Glue, Lake Formation, IAM, KMS, Lambda, Step Functions, EventBridge, CloudWatch, Redshift and MSK/Kinesis.
• Experience designing lakehouse or data-lake architectures, including layered data patterns, dimensional or domain data modelling and reusable curated datasets.
• Experience implementing incremental ingestion, change data capture, idempotency, late-arriving data handling, backfills, replay and recovery.
• Experience implementing data quality, schema validation, reconciliation, metadata and lineage as automated parts of production pipelines.
• Experience with workflow orchestration, Git-based development, CI/CD, infrastructure as code such as Terraform, and environment promotion controls.