Data Engineer

HedgeServ; Makati; On-site; PHP 600,000 - 1,200,000; Full time

Job summary

HedgeServ in Makati, Philippines is seeking a skilled ETL/Data Engineer to design, build, and maintain Python-based ETL pipelines using Jupyter notebooks. You will transform data from multiple sources, document processes, support incidents with SLA commitments, and contribute to automation and modernization initiatives within a distributed global team.

You will also author guidelines, playbooks, and root‑cause analyses, and collaborate with business and technical teams.

Qualifications

• Bachelor’s degree in Computer Science, Information Systems, or equivalent professional experience.
• Strong proficiency in Python; experience with SQL and Bash is also required.
• Solid knowledge of data‑science libraries such as Pandas, NumPy, and SciPy.
• Advanced Excel skills, including complex formula construction.
• Ability to read and interpret XML schemas and understand XML‑based workflows.
• Experience and knowledge using AWS technologies including Kibana and APM for troubleshooting.
• Deep grasp of object‑oriented programming, design patterns, and core software engineering concepts.
• Experience in agile software development, release and change management, and frequent deployments into production environments.
• Experience in the financial services industry and some knowledge of financial products is a plus.
• Excellent written and verbal communication skills in English.

Responsibilities

• ETL Development – Design, build, test, and evolve ETL pipelines using Python and Jupyter notebooks.
• Data Transformation – Convert raw data streams from multiple external sources into formats suitable for ingestion by proprietary applications.
• Documentation – Produce and maintain clear, detailed documentation for both new and existing ETL processes.
• Support & Incident Response – Deliver rapid, SLA‑compliant assistance for tickets and incidents, with the ability to rapidly push fixes to production when needed.
• Continuous Improvement – Keep up‑to‑date with industry best practices, tools, and emerging technologies relevant to ETL and data engineering, and apply them to the team’s workflows.
• Communication - Translating complicated problems and processes into streamlined solutions for various internal audiences, including senior management.

Skills

Python

SQL

Bash

Pandas

NumPy

SciPy

Excel

XML Schemas

Kibana

APM

OOP

Agile

Education

Bachelor's degree in CS/IS

Tools

Kibana

APM

XML tools

Job description

The Product and Portfolio Support Team provide around the clock coverage for the creation, deployment, and upkeep of enterprise‑wide Extract-Transform-Load (ETL) mappings. Key responsibilities include writing and maintaining Python‑based Jupyter notebooks, designing workflows that ingest and transform incoming vendor and client files, and migrating legacy Excel logic into robust Python code.

This role involves transitioning legacy operations to more efficient and modern systems, while working with multiple business, technical and support teams for the development and maintenance of critical ETL mappings. They will use analytical skills to process and understand data, answer business questions, and be able to work independently and as part of a distributed global team.

The role offers the chance to author new guidelines, best‑practice playbooks, and root‑cause analysis procedures whenever incidents arise. On top of the day‑to‑day support tasks and ongoing long-term projects, team members will contribute to short‑term projects for internal initiatives or cross‑functional business units. The engineer will support process automation, data extraction, and customized solutions across various business units. Moreover, the candidate will be able to learn about the financial services/hedge fund industry.

Job Responsibilities

• ETL Development – Design, build, test, and evolve ETL pipelines using Python and Jupyter notebooks.
• Data Transformation – Convert raw data streams from multiple external sources into formats suitable for ingestion by proprietary applications.
• Documentation – Produce and maintain clear, detailed documentation for both new and existing ETL processes.
• Support & Incident Response – Deliver rapid, SLA‑compliant assistance for tickets and incidents, with the ability to rapidly push fixes to production when needed.
• Continuous Improvement – Keep up‑to‑date with industry best practices, tools, and emerging technologies relevant to ETL and data engineering, and apply them to the team’s workflows.
• Communication - Translating complicated problems and processes into streamlined solutions for various internal audiences, including senior management.

Job Requirements

• Bachelor’s degree in Computer Science, Information Systems, or equivalent professional experience.
• Strong proficiency in Python; experience with SQL and Bash is also required.
• Solid knowledge of data‑science libraries such as Pandas, NumPy, and SciPy.
• Advanced Excel skills, including complex formula construction.
• Ability to read and interpret XML schemas and understand XML‑based workflows.
• Experience and knowledge using AWS technologies including Kibana and APM for troubleshooting.
• Deep grasp of object‑oriented programming, design patterns, and core software engineering concepts.
• Experience in agile software development, release and change management, and frequent deployments into production environments.
• Experience in the financial services industry and some knowledge of financial products is a plus.
• Excellent written and verbal communication skills in English.
• All qualifications are equally important; the ideal candidate will blend technical expertise with a proactive, service‑oriented mindset.

Please note that this role requires working during U.S. business hours.