Data Warehouse Engineer

3 days ago

Makati City, National Capital Region, Philippines Complete Development (CoDev) Full time ₱1,200,000 - ₱2,400,000 per year

Position Summary

We are seeking a highly technical Data Warehouse Engineer with deep expertise in database administration and data transformation. This role is crucial for building and maintaining the foundation of our data stack, focusing on data warehouse development and performance optimization. You will be responsible for architecting relational data models, ensuring database performance, and building clean, reliable data sources that agnostically power BI products (Looker Studio, Power BI, Tableau etc). Your expertise will be vital in creating a high-performance, well-documented, and scalable data warehouse.

Key Responsibilities

  • Perform advanced PostgreSQL optimization, including query tuning, index management, and analyzing EXPLAIN plans to resolve bottlenecks.
  • Develop, manage, and optimize our entire data transformation layer using dbt, ensuring models are efficient, tested, and well-documented.
  • Design and implement robust, scalable data models using data warehousing strategies (Star Schema, Snowflake Schema).
  • Collaborate directly with BI developers and analysts to build and optimize data sources for various dashboard design tools (e.g., Looker Studio, Looker, Power BI).
  • Write and maintain DDL and DML scripts, manage database migrations, and enforce data quality standards.
  • Manage our dbt project in source control (GitLab/GitHub), managing branching and CI/CD pipelines.

Core Required Skills

  • DBT Expertise: Expert-level proficiency in dbt for building and managing complex data transformation pipelines.
  • SQL & Query Optimization: Mastery of advanced SQL (DDL, DML) and the ability to interpret and act on EXPLAIN plans to tune performance.
  • Data Warehousing Concepts: Strong, practical knowledge of relational databases and data warehousing strategies (Star Schema, Snowflake Schema).
  • Postgres Features: Proven experience with advanced PostgreSQL features, including partitioned tables, views, and materialized views.
  • BI Data Modeling: Strong experience designing data models to support general dashboard design tools (Looker Studio, Looker, Power BI, etc.).
  • GitLab/GitHub: High level of competency in using Git for version control, especially for managing a dbt project.

  • Data Engineer – Data Warehouse

    1 day ago

    Quezon City, National Capital Region, Philippines I2S Business Solution Inc. Philippines Full time ₱960,000 - ₱1,440,000 per year

    Job Title: Data Engineer – Data WarehouseWork Set-up & Location: Hybrid (3 days RTO) | UP Ayala Land Technohub, Quezon CityWork Schedule: 04:00 PM to 01:00 AM (Mid-shift)Employment Type: 1-Year Contract (Highly Subject for Renewal)Salary Offer: Up to ₱120,000KEY EXPERIENCES & QUALIFICATIONS:Proven hands-on experience with ETL toolsStrong proficiency in...

  • Data Engineer

    2 weeks ago

    Makati City, National Capital Region, Philippines Maxicare Healthcare Corporation Full time ₱1,200,000 - ₱2,400,000 per year

    Position Accountability StatementWe are seeking a skilled Data Engineer with a strong foundation in data engineering, DevOps practices, data governance, and data warehousing. The ideal candidate will be responsible for designing, building, and maintaining scalable data pipelines, optimizing data workflows, implementing best practices for data governance, and...

  • Data Engineer

    3 days ago

    Makati City, National Capital Region, Philippines HRTX Full time ₱900,000 - ₱1,200,000 per year

    Key ResponsibilitiesDesign, build, and maintain scalable ETL (Extract, Transform, Load) pipelines and data architectures.Integrate and consolidate data from multiple internal and external systems into centralized repositories or data warehouses.Ensure data accuracy, consistency, and quality across different business units.Collaborate with cross-functional...

  • Data Engineer

    2 days ago

    Makati City, National Capital Region, Philippines Icon Executive Asia Full time ₱600,000 - ₱1,200,000 per year

    We are seeking a skilled and experienced Data Engineer to join our team and take responsibility for developing and governing our Data Platform. You will oversee the implementation and management of our solution on Azure Data Platform, with a strong focus on Azure services and technologies.The ideal candidate will have extensive knowledge of Azure Data...

  • Snowflake Data Warehouse Developer

    2 weeks ago

    Mandaluyong City, National Capital Region, Philippines NYGC Services, Inc. Full time ₱1,200,000 - ₱2,400,000 per year

    We are seeking a skilled and experienced Snowflake Data Warehouse Developer to design, develop, and maintain our cloud-based data warehousing solutions. You will work closely with data engineers, analysts, and business stakeholders to build scalable and high-performing data models and pipelines using Snowflake. The ideal candidate will have hands-on...

  • Data Engineer

    2 weeks ago

    Makati City, National Capital Region, Philippines ATOS Information Technology Inc. Full time ₱900,000 - ₱1,200,000 per year

    Role: Data EngineerLocation: Makati CityRole type: Project based (6+ Months with high chances of extension)Schedule: 9AM-6PMWork Setup: Hybrid (3x RTO & 2x WFH)Hire Type: ContractTechnologies: Big Data and data warehouses Azure Databricks (Pyspark, Python, Spark SQL) Azure Data factory Unity Catalog Open AI/Gen AI service Various Azure Resource (e.g.,...

  • Data Engineer

    5 days ago

    Makati City, National Capital Region, Philippines 048c2d60-f1ac-4ed1-872b-09adc98e52e3 Full time ₱900,000 - ₱1,200,000 per year

    Role: Data EngineerLocation: Makati CitySchedule: 9AM-6PMWork Setup: Hybrid (3x RTO & 2x WFH)Hire Type: PermanentTechnologies: Big Data and data warehouses Azure Databricks (Pyspark, Python, Spark SQL) Azure Data factory Unity Catalog Open AI/Gen AI service Various Azure Resource (e.g., storage, key vault, log analytics) Azure Synapse (SQL) CI/CD-Jenkins or...

  • Data Engineer

    5 days ago

    Makati City, National Capital Region, Philippines HRTX Full time ₱1,440,000 - ₱2,600,000 per year

    Job Title: Data EngineerLocation: Makati City (Onsite)Schedule: Compressed Workweek Monday to Thursday, 8:00 AM to 6:00 PM; Friday, 8:00 AM to 5:00 PMSalary Range: 30,000 50,000 / monthJob Summary:The Data Engineer will be responsible for designing, building, and maintaining data systems that enable efficient storage, integration, and retrieval of business...

  • Data Engineer

    5 days ago

    Quezon City, National Capital Region, Philippines Accion Labs Full time

    We're looking for a Data Engineer to help us build and maintain data pipelines and warehouse solutions. If you enjoy working with data and creating systems that help teams make smarter decisions, this role is for you. The position offers a salary of up to PHP 110,000 basic plus allowances and other benefits (e.g Healthy Insurance start at Day 1), with a...

  • Data Engineer

    2 weeks ago

    Makati City, National Capital Region, Philippines Nezda Technologies Inc Full time ₱900,000 - ₱1,200,000 per year

    Key Responsibilities:Design and build robust, scalable, and efficient data pipelines using Spark (PySpark, Scala, SQL, etc.).Manage and optimize ETL/ELT processes, including data ingestion, transformation, and integration from multiple sources into data lakes and warehouses.Utilize Azure services such as Azure Data Factory, Azure Databricks, Azure Synapse,...