Data Engineer

AMCS Group; Cebu City; Hybrid; PHP 900,000 - 1,700,000; Full time

Benefits offered by this job

Flexible work options

Career development

Global collaboration

Wellness programs

Sustainable impact

Job summary

AMCS Group is seeking a Data Engineer in Cebu to join our analytics team. You will build a unified data platform by integrating CRM, ERP, and internal tools into a governed data lake, using the latest tech and methodologies.

You will design robust data pipelines, migrate legacy logic, and collaborate with BI to deliver trusted data for dashboards, with hybrid/onsite options in Cebu.

Qualifications

• 5+ years hands-on experience with a SQL-based transformation framework (e.g. dbt or similar) building layered models (staging → marts).
• Strong SQL — comfortable with CTEs, window functions, and dimensional modeling patterns (facts, dimensions, surrogate keys, slowly changing dimensions).
• Experience building data ingestion/extraction pipelines from APIs or databases.
• Experience with a cloud data warehouse or lakehouse platform like Databricks, Microsoft Fabric.
• Experience with a workflow orchestration tool.
• Comfortable working in a Git-based CI/CD workflow.
• Understanding of layered/medallion data architecture and why cleaning logic belongs in one shared layer.

Responsibilities

• Design, develop, and maintain robust data pipelines and ELT processes using Azure Data Factory, Databricks, Fabric, and other Azure services.
• Build and maintain a layered transformation project from raw data to cleansed marts.
• Migrate legacy reports' transformation logic to the new framework and validate outputs.
• Create ingestion pipelines landing data into the data lake with CDC and retries.
• Build and maintain orchestration workflows that sequence data extraction across systems.
• Collaborate with BI/Analytics to curate data feeds for dashboards and reports.
• Apply data quality tests and maintain grain definitions.
• Monitor performance and address issues early.

Skills

SQL

dbt

Data pipelines

Dimensional modeling

Azure Data Factory

Databricks

Git CI/CD

Tools

Databricks

Microsoft Fabric

Job description

Build what matters. Grow where it counts.

Who We Are

At AMCS, sustainability means business — and careers that create impact. From our roots in Ireland to our teams across Europe, North America and Australasia, we are bringing together ambitious people to help reshape the industries that sustain our world.

What We Build

We build intelligent, cloud-based SaaS solutions that turn complex operations into smarter, more sustainable performance. Powered by AI, data and deep industry expertise, our technology helps customers optimise routes, manage recycling, improve compliance, unlock insight and move faster toward a more efficient, circular future.

Why Join AMCS

Join AMCS and be part of a global team where purpose meets performance. Here, you can grow your career, challenge what’s possible and work on technology that makes a measurable difference — for our customers, our communities and the planet.

Data Engineer

Location: Cebu — onsite or hybrid

We are seeking a skilled and motivated Data Engineer to join our analytics team. We're building a Unified data platform that brings together data from our core business systems — CRM, ERP, and internal engineering tools — into a governed, layered data lake. This is an opportunity to contribute to the design and build out of our Data platform using the latest technology advancements and methodologies.

What you’ll work on

• Design, develop, and maintain robust data pipelines ELT processes using Azure Data Factory, Databricks, Microsoft Fabric, Streaming Solutions, and other Azure services.
• Build and maintain a layered transformation project — raw data through cleaned staging models into a dimensional model — following standard dimensional modelling practices, including history-tracking techniques applied selectively where business need calls for it.
• Migrate a set of legacy reports' existing transformation logic into the new framework, validating each against current output before cutover.
• Build and maintain the ingestion pipelines that land raw data from our business systems into the data lake — extraction logic, incremental/CDC handling, schema drift, and retries — using either managed connectors or custom code.
• Build and maintain orchestration workflows that sequence data extraction from multiple business systems through cleaning and modelling layers.
• Work within our Azure DevOps CI/CD setup: repositories, branch policies, pipelines, and environment promotion.
• Partner with the BI/analytics team on how curated data feeds dashboards and reports, and help track which reports depend on which models.
• Apply data quality tests and keep model documentation and grain definitions current.
• Watch for performance issues on the underlying platform and flag them early.

What we’re looking for

Must-have

• 5+ years hands-on experience with a SQL-based transformation framework (e.g. dbt or similar) building layered models (staging → marts).
• Strong SQL — comfortable with CTEs, window functions, and dimensional modeling patterns (facts, dimensions, surrogate keys, slowly changing dimensions).
• Experience building data ingestion/extraction pipelines from APIs or databases (custom code, managed connectors, or CDC tooling).
• Experience with a cloud data warehouse or lakehouse platform like Databricks, Microsoft Fabric.
• Experience with a workflow orchestration tool.
• Comfortable working in a Git-based CI/CD workflow.
• Understanding of layered/medallion data architecture and why cleaning logic belongs in one shared layer, not duplicated per downstream consumer.

Nice-to-have

• Experience with a BI/visualization tool from the data-provider side.
• Exposure to CRM or ERP systems as data sources.
• Python, for orchestration/ingestion code beyond SQL.
• Experience migrating legacy ETL (stored procedures, scripts, or manual processes) into a modern transformation framework.

What We Offer

• Flexible and hybrid working options
• Career development and learning opportunities
• Global collaboration and exposure
• Employee wellness and support programs
• The opportunity to help build a more sustainable future

Ready to Make an Impact?

At AMCS, your work helps businesses operate more efficiently while contributing to a more sustainable future. If you are passionate about technology, innovation, and creating solutions that matter, we would love to hear from you.