Data Engineer – Integration & ETL | WFH - Nightshift

Satellite Office; Metro Manila; Remote; PHP 1,200,000 - 1,800,000; Full time

Job summary

Satellite Office is seeking an experienced Integration & Data Movement Engineer to design, build, and operate robust data flows across CRM, ERP, finance, HR, analytics, and partner platforms. You will implement ELT/ETL pipelines, leverage Snowflake, and apply Medallion Architecture across data layers for reliable, scalable ingestion and transformation.

You will work with SQL and Python to craft transformations, ensure data quality, and partner with analytics teams to enable trusted downstream

Qualifications

• 5–10+ years of experience designing and implementing system integrations and data pipelines.
• Strong SQL expertise including Stored Procedures.
• Strong Python development skills for data ingestion, transformation, automation, and operational support.
• Hands-on experience with Snowflake.
• Experience ingesting and transforming data from APIs, relational databases, flat files, and external systems.
• Experience implementing ELT/ETL solutions and data quality controls.
• Strong understanding of REST/SOAP APIs, authentication mechanisms, and integration patterns.

Responsibilities

• Design and implement integrations and ELT/ETL pipelines across APIs, databases, file-based sources, SaaS platforms, and enterprise applications.
• Build and maintain Snowflake-based data ingestion and transformation processes.
• Apply Medallion Architecture principles to organize data across raw, curated, and business-ready layers.
• Develop data transformation logic using both SQL and Python, selecting the best tool based on business and technical requirements.
• Create scalable and reusable ingestion frameworks supporting batch and incremental loads.
• Implement data quality checks, validation rules, monitoring, and error handling.
• Partner with analytics and reporting teams to ensure data is trusted and optimized for downstream consumption.
• Document integration designs, lineage, dependencies, and operational procedures.

Skills

SQL

Python

REST/SOAP APIs

Tools

Snowflake

DBT

Azure

AWS

GCP

Kafka

Service Bus

Job description

Work for our global clients and immerse in our rich and diverse company culture where you can thrive, grow and just be aweSOme!

WHAT IS AN INTEGRATION & DATA MOVEMENT ENGINEER?

We are seeking a highly skilled Integration & Data Movement Engineer to design, implement, and operate reliable data flows between enterprise platforms. This role is responsible for ensuring that data moves accurately, securely, and efficiently across systems such as CRM, ERP, finance, HR, analytics, and external partner platforms.

In addition to strong integration expertise, this role requires deep experience with modern data engineering practices, including Snowflake, Medallion Architecture (Bronze, Silver, Gold layers), data ingestion, transformation, and orchestration. The engineer will work with structured and semi-structured data from APIs, databases, files, and third-party platforms, ensuring high-quality and scalable data movement solutions.

WHAT WILL BE YOUR MAIN RESPONSIBILITIES?

• Design and implement integrations and ELT/ETL pipelines across APIs, databases, file-based sources, SaaS platforms, and enterprise applications.
• Build and maintain Snowflake-based data ingestion and transformation processes.
• Apply Medallion Architecture principles to organize data across raw, curated, and business-ready layers.
• Develop data transformation logic using both SQL and Python, selecting the best tool based on business and technical requirements.
• Create scalable and reusable ingestion frameworks supporting batch and incremental loads.
• Implement data quality checks, validation rules, monitoring, and error handling.
• Partner with analytics and reporting teams to ensure data is trusted and optimized for downstream consumption.
• Document integration designs, lineage, dependencies, and operational procedures.

WHAT ARE WE LOOKING FOR?

Required Qualifications

• 5–10+ years of experience designing and implementing system integrations and data pipelines.
• Strong SQL expertise including Stored Procedures.
• Strong Python development skills for data ingestion, transformation, automation, and operational support.
• Hands‑on experience with Snowflake.
• Experience ingesting and transforming data from APIs, relational databases, flat files, and external systems.
• Experience implementing ELT/ETL solutions and data quality controls.
• Strong understanding of REST/SOAP APIs, authentication mechanisms, and integration patterns.

Preferred Qualifications

• Experience with DBT, including models, testing, lineage, documentation, and data quality frameworks.
• Experience with cloud‑native integration patterns and services (Azure, AWS, or GCP).
• Familiarity with Kafka, Service Bus, or other event streaming technologies.