AWS Data Warehouse Engineer ETL DBT And BI Dashboards

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

Job summary

Alsons/AWS Information Systems Inc. is seeking a Data Warehouse Developer to design, build, and maintain scalable data warehouse solutions in Cebu City, Philippines. 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.

Qualifications

• Design, build and maintain scalable data warehouse solutions.
• 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 and ensure data governance and security standards.

Responsibilities

• Design, build, and maintain scalable data warehouse solutions.
• 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

Data warehousing

ETL

SQL

Data governance

Security

Dashboards development

Tools

AWS Glue

Lambda

DBT

PostgreSQL

Athena

Power BI

Tableau

Python

Job description

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.

Requirements: