Data Warehouse (DW) Developer

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

Responsibilities

• Design, develop, and maintain scalable data warehouse solutions.
• Build and manage ETL (Extract, Transform, Load) processes using AWS services such as AWS Glue, Lambda, and Snowflake.
• Perform data transformation and modeling using DBT (Data Build Tool).
• Develop and optimize SQL queries, stored procedures, and database structures.
• Manage and support databases including PostgreSQL and Athena.
• Create dashboards, reports, and data visualizations using Power BI and Tableau.
• Develop automation scripts and data processing solutions using Python.
• Monitor data pipelines and troubleshoot data-related issues to ensure data accuracy and integrity.
• Collaborate with business users, analysts, and technical teams to gather requirements and deliver data solutions.
• Lead technical initiatives, mentor team members, and provide guidance on best practices.
• Ensure compliance with data governance, security, and performance standards.

Minimum Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a 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 skills and experience handling or guiding a team is an advantage.
• Good communication and interpersonal skills.

Preferred Qualifications

• Experience with cloud-based data architecture and big data technologies.
• Familiarity with CI/CD and DevOps practices for data engineering.
• AWS or relevant cloud certifications are an advantage.