Data Engineer (Python x BigQuery) - WFH/Remote

Complete Development (CoDev); Metro Manila; A distancia; PHP 1.200.000 - 1.800.000; Jornada completa

Descripción de la vacante

Complete Development (CoDev) is seeking a highly skilled Data Engineer to own the transformation and modeling layers of a new data warehouse project. This role centers on expert-level mastery of Google BigQuery (including Dataform) and Python to architect clean, reliable, and scalable data models using Kimball principles for BI and analytics.

You will build sophisticated transformation pipelines, optimize performance, and ensure data quality for trusted reporting datasets.

Formación

• Experience designing dimensional data warehouses using Kimball principles.
• Proven ability to design and implement Dataform-based transformation workflows.
• Advanced SQL skills including window functions, CTEs, and joins.
• Proficiency in Python for data engineering tasks.
• Hands-on BigQuery experience including partitioning, clustering, and performance tuning.
• Knowledge of data warehousing schemas (Star, Snowflake).
• Experience preparing data for Looker/Tableau/Power BI.
• Familiarity with ML workflows in BigQuery (BQML) is a plus.
• Git version control for SQL and Dataform projects.

Responsabilidades

• Lead the data transformation lifecycle using Dataform to build high‑quality datasets.
• Build and maintain scalable, well‑documented data pipelines for reporting.
• Conduct Exploratory Data Analysis to identify quality issues and unlock value.
• Write performant BigQuery SQL for complex queries and data manipulation.
• Implement data quality checks to ensure accuracy of reporting datasets.

Conocimientos

Kimball Methodology

Dataform

SQL

Python

Google BigQuery

Data Modeling

EDA

BI Tool Integration

AI in Data Engineering

Git

Herramientas

Dataform Studio

BigQuery SQL

Descripción del empleo

POSITION SUMMARY

We are seeking a highly skilled Data Engineer to own the transformation and modeling layers of a new data warehouse project. This role is centered around an expert-level mastery of Google BigQuery (including Dataform) and Python. You will be responsible for taking raw data and architecting clean, reliable, and performant data models by applying Kimball methodology principles to power business intelligence and analytics. Your expertise in building sophisticated, scalable transformation pipelines with Dataform will be vital in transforming complex datasets into actionable insights and ensuring the analytical integrity of our dimensional data warehouse.

KEY RESPONSIBILITIES

• Lead the development, maintenance, and optimization of the entire data transformation lifecycle using Dataform to produce high-quality, trusted datasets.
• Build and manage scalable, well-documented, and tested data transformation pipelines that are critical for business reporting.
• Conduct Exploratory Data Analysis (EDA) on new and existing datasets to identify quality issues, understand data structures, and unlock business value.
• Write highly performant BigQuery SQL for complex queries, aggregations, and data manipulation, with a focus on cost and speed optimization.
• Implement rigorous data quality and validation checks within the transformation process to ensure accuracy and trust in our reporting datasets.

CORE REQUIRED SKILLS

• Kimball Methodology: Demonstrable, in-depth experience designing and building dimensional data warehouses using Kimball's principles.
• Dataform Expertise: Mastery of Dataform for developing, testing, and deploying complex SQL-based data transformation workflows in a production environment.
• Expert-Level SQL & Python: Demonstrable mastery of advanced SQL, including window functions, CTEs, and complex joins, with proficiency in Python for data engineering and transformation tasks.
• Google BigQuery: Deep, hands-on experience with BigQuery, including performance tuning, cost optimization, and partitioning/clustering.
• Database Schema Concepts: Strong, practical knowledge of data warehousing schemas (Star Schema, Snowflake Schema, Data Marts).
• Exploratory Data Analysis (EDA): Ability to analyze and profile datasets to derive insights and assess quality.
• Business Intelligence (BI) Tool Integration: Experience preparing data for consumption by BI tools like Looker, Tableau, or Power BI.
• AI Expertise: Demonstrable hands-on experience applying AI technologies and tools in data engineering, analytics, or data transformation workflows.
• BigQuery ML (BQML): Experience with building and deploying machine learning models using BQML is a significant plus.
• Version Control (Git): Proficiency in using Git for managing SQL and Dataform code.