Data Engineer (Project Based)

About the role

The client is a growing Window Furnishings company that relies on data to drive key decisions. We are looking for a Data Engineer to design, build, and optimize data pipelines and semantic layer, ensuring 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 Redshift data warehouse.

• Improve query performance and ensure real-time analytics capabilities as needed.

About you

• 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 Details:

· Work Schedule: Monday – Friday 5:30AM – 2:30PM

· Work Setup: Hybrid | Trafalgar Bldg. Salcedo Village, Makati City

· Full-Time: Project based (3-6mos duration)