IT.Developer - Data Engineer

Citco; Philippines; On-site; PHP 900,000 - 1,500,000; Full time

Job summary

Citco in Makati, Philippines seeks an IT Developer – Data Engineer to design, develop, and maintain ETL/ELT pipelines using Databricks Delta Lake and Apache Spark. You will migrate data assets to Databricks on AWS, build AWS-based pipelines, and implement data quality and governance, collaborating across teams.

A strong background in SQL, Python, PySpark, and Databricks, with 3–5 years of experience, is required. This is a full-time, on-site role in a dynamic global fintech environment.

Qualifications

• 3–5 years of hands-on data engineering experience, with at least 2–3 years on Databricks including notebooks, clusters, jobs, and Delta features.
• Strong hands-on Databricks core components knowledge: Delta Lake, DLT, Workflows, Unity Catalog, AutoLoader, Structured Streaming.
• Proficiency with SQL, Python, PySpark, or Scala within Databricks.
• Experience integrating Databricks with AWS services (S3, Glue, Athena, Lambda).
• Hands-on experience building ETL/ELT jobs in AWS (Glue Jobs/Crawlers/Data Catalog).
• Experience with real-time and batch data processing using Databricks.
• PL/SQL knowledge and creating SQL scripts with stored procedures.
• Familiarity with BI tools such as Power BI and/or Qlik.

Responsibilities

• Design, develop, and maintain ETL/ELT pipelines using Databricks Delta Lake and Apache Spark
• Support data platform migration activities, migrating pipelines and data assets to Databricks on AWS
• Assess, plan, and execute end-to-end migration strategies with data integrity
• Build and manage AWS-based data pipelines using AWS Glue, S3, and related ETL services
• Implement data workflows using Databricks notebooks, jobs, and AWS Glue workflows
• Create and optimize data models for batch and streaming data processing
• Develop and maintain data quality frameworks and monitoring during and after migration
• Collaborate with cross-functional teams to capture data requirements and scale solutions
• Write efficient SQL queries and optimize performance of existing queries
• Implement data security and governance practices per standards
• Build and maintain runbooks and architectures documentation (e.g., Medallion Architecture)
• Explore and apply Gen AI / ML capabilities on data pipelines where applicable
• Stay current with features of Databricks, AWS, and emerging data tools
• Attend meetings across time zones as needed to support business needs

Skills

SQL

Python

PySpark

Scala

Databricks

AWS services

ETL/ELT design

Real-time data processing

Data governance

Data visualization

Education

Bachelor's degree or equivalent experience

Tools

Databricks Delta Lake

Delta Live Tables

Unity Catalog

AWS Glue

S3

Athena

Lambda

Power BI

Qlik

Databricks Workflows

Job description

About Citco:

Armed with superior services, smart people, and strong technology, we tackle our customers’ complicated challenges by developing sophisticated solutions driven directly by their demands. The result? Innovation that generates tangible value and makes a real difference for our clients and their companies.

IT Developer – Data Engineer

Makati, Philippines

About Citco

Citco is a global leader in fund services, corporate governance and related asset services with staff across 80 offices worldwide. With more than $1 trillion in assets under administration, we deliver end-to-end solutions and exceptional service to meet our clients’ needs.

For more information about Citco, please visit www.citco.com

About the Team & Business Line:

Proprietary software solutions and innovation are at the core of what differentiates Citco in the alternative investment space. Through our network of global development centers, Citco invests heavily in technology development, security, and infrastructure to ensure our clients continue to receive award-winning products that underpin our commitment to service excellence.

As a core member of our Innovation Development team, you will work with dedicated professionals to ensure our clients maintain access to their critical information assets while keeping Citco ahead of industry trends.

Your Role:

• Design, develop, and maintainETL/ELT pipelinesusing Databricks Delta Lake and Apache Spark
• Supportdata platform migration activities, including migrating pipelines, workflows, and data assets from legacy or alternative platforms (e.g., on-premise, other cloud platforms)to Databricks on AWS
• Assess, plan, and executeend-to-end migration strategiesensuring minimal disruption and data integrity throughout
• Build and manageAWS-based data pipelinesusingAWS Glue,S3, and related ETL services
• Implement data workflows using Databricks notebooks, jobs, andAWS Glue workflows
• Create and optimize data models for bothbatch and streamingdata processing
• Develop and maintaindata quality frameworksand monitoring systems during and post-migration
• Collaborate with cross-functional teams to understand data requirements and implement scalable solutions
• Write efficientSQL queriesand optimize performance of existing queries
• Implementdata security and governancepractices aligned with organizational standards
• Build and maintain documentation for data processes, migration runbooks, and architectures (e.g.,Medallion Architecture)
• Explore and applyGen AI / Machine Learningcapabilities on data pipelines where applicable
• Stay current with new and upcoming features ofDatabricks, AWS, and emerging data tools
• Demonstrate flexibility to attend meetings across different time zones, with openness to varying schedules based on business needs

About You:

Experience and Technical Skills

• 3–5 yearsof hands-on experience in data engineering, with at least2–3 yearsofdedicated Databricks hands-on experienceincluding notebooks, clusters, jobs, Delta Live Tables, and Unity Catalog

• Strong hands-on experience withDatabricks core components:

  • Delta Lake & Delta Live Tables (DLT)

  • Databricks Workflows & Job Orchestration

  • Unity Catalog & Data Governance

  • Databricks AutoLoader & Structured Streaming

• In-depth knowledge ofSQL, Python, PySpark, and/or Scala within the Databricks environment

• Strong expertise integrating Databricks withAWS servicesincludingS3, AWS Glue, Athena, andLambda

• Hands-on experience building and managingETL/ELT jobs in AWS(Glue Jobs, Glue Crawlers, Glue Data Catalog)

• Demonstrable experience inreal-time and batch data processingusing Databricks

• Experience withPL/SQL programming, creating SQL scripts and writing stored procedures

  • Familiarity withBI Toolssuch as Power BI and/or QLIK

Education

• Bachelors' degree or equivalent experience
• Demonstrated commitment to continuous improvement and training

Desired skills and expertise

• Databricks Data Science/Engineer certifications
• PowerBI, Predictive Analytics, AI/ML, Medallion architecture
• Exposure to or working knowledge ofGenerative AI, LLMs, or Machine Learningin a data context (e.g., MLflow, feature stores, model serving) —nice to have

Our Benefits

Your wellbeing is of paramount importance to us, and central to our success. We provide a range of benefits, training and education support, and flexible working arrangements to help you achieve success in your career while balancing personal needs. Ask us about specific benefits in your location.

We recognize diversity as a source of organizational pride and strength. We have made it a priority to reflect our nation’s evolving diversity in the people we hire, and the culture we create in our organization.

Citco welcomes and encourages applications from people with disabilities. Accommodations are available upon request for candidates taking part in all aspects of the selection.