Data Warehouse Engineer

1 day ago

Bacolod City, Western Visayas, Philippines CoDev Full time


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

  • Warehouse Supervisor

    2 weeks ago

    Iloilo City, Western Visayas, Philippines ILOILO SOUTHPRIME DEVELOPERS Full time

    WAREHOUSE SUPERVISORJOB DESCRIPTIONMaintains warehouse inventory and accuracya. Ensures the accuracy of the quantity of all incoming and outgoing deliveries.b. Informs the Materials Controller regarding ordering products as needed to maintain sufficient inventory levels.c. Maintains inventory accuracy by cycle counting, physical inventories, implementing...

  • Project Engineer

    2 weeks ago

    Bacolod City, Western Visayas, Philippines Isk Tech Supplies and General Services, Inc. Full time

    Requirements and Qualifications ·Minimum of a bachelor's degree in electrical engineeringStrong leadership and problem-solving skillsExcellent organizational skills and attention to detailExcellent verbal and written communication skillsA desire to continually upgrade technical knowledge.Ability to use specialized software for collaboration and time...

  • Data Engineer

    2 weeks ago

    Cebu City, Central Visayas, Philippines RAFI MICRO-FINANCE Full time

    What You'll DoBuild and maintain data pipelines (ETL/ELT) to move and process data efficiently.Create and manage data models and warehouses for reporting and analytics.Integrate data from multiple systems while keeping it clean and reliable.Automate workflows for timely data delivery.Ensure data security, integrity, and compliance.Collaborate with teams to...

  • Digital Building Engineer

    6 days ago

    Bacolod City, Western Visayas, Philippines CoDev Full time

    OverviewImportant Requirement: configured HVAC analytics and built digital twin models of HVAC equipment in the past.The Ideal Candidate· Has a bachelor's in mechanical engineering (or a related technical degree) and an interest in building systems or has significant field experience in a controls or services company serving the buildings industry.· Has a...

  • Devops Engineer

    2 weeks ago

    Bacolod City, Western Visayas, Philippines CoDev Full time

    OverviewRole OverviewWe 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...

  • Technical Marketing Engineer

    2 weeks ago

    Bacolod City, Western Visayas, Philippines CoDev Full time

    OverviewWe are looking for a Technical Marketing Engineer who sits at the intersection of engineering, product, and marketing. This role is responsible for translating complex technical concepts into clear, compelling, and technically accurate messaging that supports go-to-market efforts, sales enablement, and customer adoption. You will work closely with...

  • Senior Software Engineer

    1 week ago

    Bacolod City, Western Visayas, Philippines Orange and Bronze Software Labs, Inc. Full time

    CAREER OPPORTUNITY:Senior Software Engineer – BacolodJOB DESCRIPTIONWe are seeking a Senior Java Engineer to join our high-performing engineering team. This role is ideal for someone who is passionate about building scalable backend systems, mentoring junior developers, and driving best practices in software design and development.As a senior member of the...

  • Make Ready Engineer

    2 weeks ago

    Bacolod City, Western Visayas, Philippines Expander Outsourcing Services, Inc. Full time

    Job Title: Make Ready EngineerJob Description:We are seeking a skilled Make Ready Engineer to join our team. This role focuses on assessing, designing, and preparing existing utility structures and poles to accommodate new network deployments safely and efficiently. The ideal candidate will have a strong understanding of structural engineering principles,...

  • Senior Backend Engineer

    1 week ago

    Bacolod City, Western Visayas, Philippines CoDev Full time

    OverviewWe are seeking Senior Backend Engineers to form the core of the development team,responsible for building the microservices, APIs, and business logic that drive our platform.As a Senior Backend Engineer, you will architect and implement the backend services thatpower our applications. Your work will include building CRM-like functionality, developing...

  • Fleet Supervisor

    1 week ago

    Bacolod City, Western Visayas, Philippines PM Consulting Full time

    We are looking for a Fleet Supervisor who will lead and oversee the logistics and fleet operations of a growing food and restaurant group. The role will manage transportation, delivery scheduling, vehicle maintenance, and day-to-day logistics activities to ensure timely distribution of supplies across multiple branches.Key ResponsibilitiesLead and supervise...