Data Warehouse Engineer

1 day ago

Bacolod City, Western Visayas, Philippines CoDev Full time ₱1,200,000 - ₱2,400,000 per year


Overview

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.



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.



Qualifications

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.



Required Skills

SQL, Data Warehousing, Data Build Tool (DBT), Google Cloud Platform (GCP), PowerBI, Data Modeling

  • Senior Cloud Data Engineering Lead

    3 days ago

    Bacolod City, Western Visayas, Philippines Zylun Philippines, Inc. Full time ₱1,200,000 - ₱2,400,000 per year

    Overview:Reporting to the Chief Technology Officer - NA, the Senior Cloud Data Engineer is responsible for leading initiatives in a cross functional team, playing a critical role architecting and delivering custom cloud solutions with our clients. You will work collaboratively with our experienced Google Cloud and Google Marketing Platform experts to deliver...

  • Maintenance Engineer-Electrical

    2 weeks ago

    Bacolod City, Western Visayas, Philippines San Miguel Corporation Full time ₱30,000 - ₱60,000 per year

    JOB SUMMARY• Responsible for an effective implementation of maintenance program for Electrical System.For 480V: Motor Control Center and Feeder lines, Electric Motors;For 220V : Lighting Transformers, Lighting Panels and FixturesJOB DUTIES & RESPONSIBILITIESA. Primary FunctionsPlanning1. Reviews the SAP Maintenance Schedule and updates as necessary.2....

  • Regional Warehousing Lead for Visayas

    2 weeks ago

    Bacolod City, Western Visayas, Philippines Fortem Cement Corp. Full time ₱240,000 - ₱360,000 per year

    Job SummaryWe are seeking a proactive and results-driven Regional Warehouse Lead to oversee and manage warehouse operations across the Visayas region, primarily in Bacolod, Iloilo, and Cebu. The role is responsible for ensuring efficient inventory management, accurate stock control, timely distribution, compliance with company standards, and alignment with...

  • Warehouse Team Lead

    3 days ago

    Iloilo City, Western Visayas, Philippines La Filipina Uy Gongco Group of Companies Full time ₱250,000 - ₱500,000 per year

    JOB DESCRIPTIONCandidate must possess at least Bachelor's/College Degree in Industrial Engineering or equivalent.At least 2 Year(s) of working experience in the related field is required for this position.Preferably 1-4 Yrs Experienced Employee specialized in Purchasing/Inventory/Material & Warehouse Management or equivalent.Preferably with previous...

  • Warehouse Operator

    3 days ago

    Iloilo City, Western Visayas, Philippines La Filipina Uy Gongco Group of Companies Full time

    QUALIFICATIONSCandidate must possess at least Bachelor's/College Degree, Business Administration, Accountancy, Engineering (Others) or equivalent.At least 1 Year(s) of working experience in the related field is required for this position.Preferably Less than 1 year experience specialized in WarehousingWith 1 to 4 years cumulative experienced in any Logistics...

  • Devops Engineer

    7 days ago

    Bacolod City, Western Visayas, Philippines CoDev Full time ₱80,000 - ₱120,000 per year

    OverviewRole Description:We are looking for a skilled DevOps Engineer that would set up and maintain CI/CD pipelines, manage cloud environments on Google Cloud Platform (GKE or Cloud Run), implement monitoring and logging solutions, and ensure that the platform remains secure, scalable, and reliable. The ideal candidate is proactive, detail-oriented, and...

  • Digital Building Engineer

    7 days ago

    Bacolod City, Western Visayas, Philippines CoDev Full time $30,000 - $60,000 per year

    ResponsibilitiesCore Responsibilities· Ensuring clients and partners are delivered and supported with the highest quality fault detectionand diagnostics product.· Collaboratively completing onboarding projects and communicating timelines and milestones toensure Clockworks analytics fulfills its role in a timely manner at a high level of quality.·...

  • Data Engineer

    2 weeks ago

    Iloilo City, Western Visayas, Philippines LifeBank Microfinance Foundation, Inc Full time ₱900,000 - ₱1,200,000 per year

    LifeBank Microfinance Foundation, Inc. (LBF)we excel, we care, we shareLifeBank Microfinance Foundation, Inc. is a non-stock and non-profit organization engaged in micro-financing initiatives that advance comprehensive and sustainable development in rural and urban areas through integrated social services. We are a major catalyst in breaking the chains of...

  • Data Engineer

    2 weeks ago

    Iloilo City, Western Visayas, Philippines LifeBank Microfinance Foundation Full time ₱900,000 - ₱1,200,000 per year

    LifeBank Microfinance Foundation, Inc. (LBF)we excel, we care, we shareLifeBank Microfinance Foundation, Inc. is a non-stock and non-profit organization engaged in micro-financing initiatives that advance comprehensive and sustainable development in rural and urban areas through integrated social services. We are a major catalyst in breaking the chains of...

  • Data Engineer

    3 days ago

    Cebu City, Central Visayas, Philippines Prince Retail Group of Companies Full time ₱900,000 - ₱1,200,000 per year

    About the roleAs a Data Engineer at the Prince Retail Group of Companies', you will be responsible for designing, building, and maintaining the data infrastructure that supports the organization's data-driven decision making. The Data Engineer is responsible for raising data quality levels at PRG by helping data stewards converting business rules to code and...