Data Engineer (Project Based)

Flexisource IT; Makati; Hybrid; PHP 1.000.000 - 1.800.000; Vollzeit

Zusammenfassung

Flexisource Information Technology Inc. is seeking a Data Engineer to design, build, and optimize data pipelines and a semantic layer.

You will work with software developers, analysts, and business stakeholders to define core metrics, transform raw data into useful models, and establish a scalable analytics infrastructure using modern tools like SQLMesh (or dbt) and Cube. You will design and implement robust data pipelines, apply dbt for transformations, and collaborate with teams to define KPIs

Qualifikationen

• 3+ years in analytics, data, or BI engineering.
• Strong SQL skills and data modelling (Star/Snowflake).
• Hands-on experience with dbt, SQLMesh, or similar.
• Knowledge of semantic layers (Cube, LookML, MetricFlow).
• Experience with data warehouses (BigQuery, Snowflake, Redshift).
• Familiarity with ETL/ELT and orchestration (Airflow, Dagster).
• Strong understanding of governance, testing, and version control.
• Ability to define meaningful metrics with business teams.
• Excellent communication and focus on scalable data systems.

Aufgaben

• Design, build, and optimize data pipelines and semantic layer.
• Implement dbt for transformations and data versioning.
• Collaborate with stakeholders to define KPIs and reporting needs.
• Optimize models for performance, scalability, and cost.
• Ensure data governance with testing, monitoring, and docs.
• Integrate data from multiple sources into Redshift.
• Improve query performance and enable real-time analytics when needed.

Kenntnisse

SQL

Data modeling

dbt

SQLMesh

Cube

LookML

MetricFlow

Data warehouse

ETL/ELT

CI/CD for data

Stakeholder communication

Data governance

Tools

dbt

SQLMesh

Cube

LookML

MetricFlow

Airflow

Dagster

Kafka

Flink

Python

Metabase

Tableau

Power BI

Looker

BigQuery

Snowflake

Redshift

Jobbeschreibung

Client: Australian & New Zealand company that designs custom window furnishings for beautiful spaces.

About the role

The client is a growing Window Furnishings company that relies on data to drive key decisions. We are looking for an Data Engineer to design, build, and optimize our data pipelines and semantic layer, ensuring our teams have reliable, well-defined business metrics at their fingertips.

You will work closely with software developers, analysts, and business stakeholders to define core metrics, transform raw data into useful models, and build a scalable analytics infrastructure using modern data tools like SQLMesh (or dbt) and Cube.

Key Responsibilities

• Design & build robust data pipelines to ingest, transform, and model data efficiently.
• Implement dbt for transformation workflows and data versioning.
• Collaborate with stakeholders to understand reporting needs and define clear KPIs.
• Optimize data models for performance, scalability, and cost efficiency.
• Ensure data governance and quality by implementing testing, monitoring, and documentation.
• Integrate data from multiple sources into our Redshift data warehouse.
• Improve query performance and ensure real-time analytics capabilities as needed.

Requirements:

• 3+ years of experience in Analytics Engineering, Data Engineering, or BI Engineering.
• Strong SQL skills and experience with data modelling (Star/Snowflake schema).
• Hands-on experience with dbt, SQLMesh, or similar transformation frameworks.
• Knowledge of Cube, LookML, MetricFlow, or other semantic layer tools.
• Experience working with data warehouses (BigQuery, Snowflake, Redshift, etc.).
• Familiarity with ETL/ELT processes and workflow orchestration (Airflow, Dagster).
• Strong understanding of data governance, testing, and version control (e.g., CI/CD for data).
• Ability to work closely with business teams to define meaningful and actionable metrics.
• Excellent communication skills and a passion for scalable, high-quality data systems.

Nice to have:

• Experience with streaming data pipelines (Kafka, Flink, etc.)
• Familiarity with Python for data engineering
• Experience with data visualization tools (Metabase, Tableau, Power BI, Looker)
• Work Schedule: Monday – Friday 5:30AM – 2:30PM
• Work Setup: Hybrid | Trafalgar Bldg. Salcedo Village, Makati City