BigQuery Data Analytics Consultant

Bytespoke; Hinoba-an; On-site; PHP 600,000 - 1,200,000; Full time

Benefits offered by this job

Flexible work options

Job summary

Bytespoke Technology Private Limited, based in the Philippines, seeks a BigQuery Data Analytics Consultant to build, maintain and scale a data infrastructure on Google BigQuery, integrating GA4, Poppulo, and future data sources.

You will design scalable data schemas, write and optimize BigQuery SQL, manage data pipelines, ensure data quality, and collaborate with stakeholders to enable data-driven decisions across the business.

Qualifications

• Google BigQuery expertise is required.
• Strong SQL and data modeling skills.
• Experience with GA4 data exports and GCP.
• Ability to design scalable data architectures.

Responsibilities

• Configure and maintain BigQuery projects, datasets, tables, and data warehouse.
• Integrate GA4 event data exports from internal sources into BigQuery.
• Design scalable data schemas and layered architectures (raw, staging, presentation).
• Write and optimize BigQuery SQL queries.
• Manage partitioning, clustering, performance, and cost optimization.
• Ensure data quality and reliable pipeline operations.
• Document pipelines, data models, schemas, and architecture.
• Design pipelines to accommodate future data sources.
• Support stakeholders in querying and utilizing the data.

Skills

Google BigQuery

Advanced SQL

GA4 Export Schema

GCP

ETL/ELT

Data modeling

Data warehouse architecture

IAM & access controls

Tools

BigQuery

GA4

Job description

Bytespoke Technology Private Limited ·1 day ago

Job Summary

We are looking for a BigQuery Data Analytics Consultant to build, maintain, and scale a data infrastructure on Google BigQuery, integrating data from GA4, Poppulo, and future data sources.

Key Responsibilities

• Configure and maintain BigQuery projects, datasets, tables, and data warehouse.
• Integrate GA4 event data exports from internal/intranet sites into BigQuery.
• Design scalable data schemas and layered architectures (raw, staging, presentation).
• Write and optimize BigQuery SQL queries.
• Manage partitioning, clustering, performance, and cost optimization.
• Ensure data quality, consistency, and reliable pipeline operations.
• Document pipelines, data models, schemas, and architecture.
• Design pipelines that can easily accommodate future data sources.
• Support stakeholders in querying and utilizing the data.

Must-Have Skills

• Google BigQuery
• Advanced SQL
• GA4 & BigQuery Export Schema
• GCP
• Data integration / ETL / ELT
• Data modeling & warehouse architecture
• IAM, Service Accounts & access controls
• Experience with nested/repeated GA4 data

Good to Have