AWS DW Engineer: ETL, DBT & BI Dashboards

Alsons/AWS Information Systems Inc.; Cebu City; On-site; PHP 600,000 - 1,200,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.

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.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or related field.
• Proven experience as a Data Warehouse Developer or similar role.
• Strong experience with AWS services for ETL and data warehousing (AWS Glue, Lambda, Snowflake, etc.).
• Experience in data transformation using DBT.
• Proficient in PostgreSQL and Athena.
• Skilled in Power BI and Tableau for reporting and dashboard development.
• Strong Python programming and development skills.
• Excellent SQL and data modeling skills.
• Strong analytical and problem-solving abilities.
• Leadership experience is an advantage.
• Good communication and interpersonal skills.

Responsibilities

• Design, develop, and maintain scalable data warehouse solutions.
• Build and manage ETL processes using AWS services (AWS Glue, Lambda, Snowflake).
• Perform data transformation and modeling using DBT.
• Develop and optimize SQL queries, stored procedures, and database structures.
• Manage and support PostgreSQL and Athena databases.
• Create dashboards and reports using Power BI and Tableau.
• Develop automation scripts using Python.
• Monitor data pipelines and troubleshoot data issues for accuracy.
• Collaborate with business users and technical teams to deliver data solutions.
• Lead technical initiatives and mentor team members.
• Ensure data governance, security, and performance standards.

Skills

Data warehousing

AWS ETL

DBT

PostgreSQL

Athena

Power BI

Tableau

Python

SQL

Data modeling

Leadership

Education

Bachelor's degree in Computer Science/IT

Tools

Snowflake

AWS Glue

AWS Lambda

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.