AWS Data Warehouse Engineer | ETL, DBT & BI Dashboards

Alsons/AWS Information Systems Inc.; Cebu City; On-site; PHP 600,000 - 900,000; Full time

Job summary

Alsons/AWS Information Systems Inc. in Cebu City is seeking a Data Warehouse Developer to design, build, and maintain scalable data warehouse solutions. You will lead ETL pipelines using AWS Glue and Lambda, and optimize SQL queries across PostgreSQL and Athena.

You will transform data with DBT, create dashboards in Power BI and Tableau, write Python automation scripts, and ensure data governance and security standards are upheld.

Qualifications

• Experience designing and maintaining data warehouse solutions.
• Knowledge of AWS Glue, Lambda and DBT is preferred.
• Strong SQL skills across PostgreSQL and Athena.

Responsibilities

• Design, build, and maintain scalable data warehouse solutions in Cebu City.
• Lead ETL processes using AWS Glue and Lambda.
• Transform data with DBT and optimize SQL queries across PostgreSQL and Athena.
• Create dashboards in Power BI and Tableau; write Python automation scripts.
• Ensure data governance and security standards are upheld.

Skills

ETL pipelines

AWS Glue

AWS Lambda

DBT

SQL optimization

PostgreSQL

Amazon Athena

Power BI

Tableau

Python scripting

Data governance

Security standards

Tools

Power BI

Tableau

Python

SQL

AWS

Job description

Alsons/AWS Information Systems Inc. is seeking a Data Warehouse Developer to design, build, and maintain scalable data warehouse solutions in Cebu City. You will lead ETL processes using AWS Glue and Lambda, transform data with DBT, and optimize SQL queries across PostgreSQL and Athena.

You will create dashboards in Power BI and Tableau, write Python automation scripts, and ensure data governance and security standards are upheld.