Google BigQuery Data Lake Architect Consultant (Remote, USA)

Evolvesquads inc.; Northern (KY); Hybrid; USD 150,000 - 210,000; Full time

Job summary

Evolvesquads inc. is seeking an experienced Google Cloud / BigQuery Data Lake Architect Consultant to design and implement a modern enterprise data platform for a large omnichannel retailer.

The role centers on defining target architecture, ingestion patterns, data modeling, security, governance, and an actionable implementation roadmap for a Google Cloud-based data lake / lakehouse with BigQuery at its core.

Qualifications

• 10+ years in enterprise data architecture, data engineering, or data-platform work.
• 5+ years of Google Cloud Platform experience.
• Hands-on BigQuery in production environments.
• Experience architecting cloud data lakes/lakehouses or modern data warehouses.
• Strong knowledge of BigQuery, SQL, data modeling, ETL/ELT, pipelines, APIs, CDC, streaming, data quality, metadata, lineage and security.
• Experience with data governance within GCP and scalable data architectures.
• Ability to lead while staying hands-on with engineering teams.

Responsibilities

• Design the Google Cloud data lake / lakehouse architecture with BigQuery at the core.
• Define ingestion patterns for batch, near real-time, streaming, API, file-based data, and DB sources.
• Develop a strategy to ingest data from SaaS and enterprise apps into Google Cloud.
• Establish raw, standardized, curated, and consumption data layers.
• Define enterprise data models supporting analytics, AI/ML, and GenAI use cases.
• Set BigQuery standards for datasets, partitioning, clustering, retention and performance.
• Create scalable patterns for historical data, CDC, and slowly changing dimensions.
• Define data quality, lineage, observability, and monitoring frameworks.
• Design security architecture including IAM, service accounts, RLS, column security, encryption, and PII protection.

Skills

BigQuery

Google Cloud

Data Lake / Lakehouse

ELT/ETL

Data modeling

Security & governance

SQL

Datastream

Dataform

dbt

Airflow

CI/CD

Tools

Datastream

Dataplex

Cloud Run

Cloud Functions

Git

CI/CD

Job description

Google BigQuery Data Lake Architect Consultant (Remote, LATAM) #26593

... create world-changing products using God-given talents . .

PROJECT DESCRIPTION:

We are seeking an experienced Google Cloud / BigQuery Data Lake Architect Consultant to help design and implement a modern enterprise data platform for a large omnichannel retail organization. The consultant will define the target architecture, ingestion patterns, data modeling approach, security framework, governance standards, and implementation roadmap for a Google Cloud-based data lake / lakehouse centered on BigQuery.

PROJECT STACK and TEAM:

• Initial duration: 3 to 6 months, with strong possibility of extension.
• Must be able to work in the Pacific Time Zone.
• Consulting role requiring hands‑on architecture and implementation leadership.

MAIN REQUIREMENTS:

• 10+ years of enterprise data architecture, data engineering, or data-platform experience.
• 5+ years of significant Google Cloud Platform experience.
• Deep hands-on experience with BigQuery in production environments.
• Proven experience architecting a cloud enterprise data lake, lakehouse, or modern data warehouse.
• Strong knowledge of BigQuery architecture and optimization, SQL, data modeling, ELT/ETL, pipelines, APIs, CDC, streaming, data quality, metadata, lineage, and security.
• Experience designing platforms that process large transaction volumes.
• Experience with dbt and/or Dataform.
• Experience with Airflow / Cloud Composer or similar orchestration tooling.
• Experience with Git-based development and CI/CD.
• Experience implementing data governance within GCP.
• Ability to develop architecture while remaining hands‑on with engineering teams.
• Strong communication skills with technical and business stakeholders.

GOOD TO HAVE:

• Retail industry experience, especially fashion, specialty, or omnichannel retail.
• Experience implementing enterprise retail data models.
• Experience migrating from legacy merchandising / ERP platforms.
• Experience building data foundations for AI, machine learning, and GenAI.
• Snowflake experience and ability to compare Snowflake and BigQuery architectural patterns.
• Experience defining semantic layers and supporting BI platforms.
• Experience managing offshore or systems‑integrator development teams.

JOB RESPONSIBILITIES:

• Design the overall Google Cloud data lake / lakehouse architecture, with BigQuery as the core enterprise analytical platform.
• Define ingestion patterns for batch, near-real-time, streaming, API, file-based, and database-source integrations. Datastream, Cloud Run / Cloud Functions, dbt and/or Dataform, and Dataplex.
• Develop a strategy for ingesting data from SaaS and enterprise applications into Google Cloud.
• Establish raw, standardized, curated, and consumption data layers.
• Design enterprise data models supporting analytics, reporting, AI/ML, and GenAI use cases.
• Define BigQuery standards for datasets, tables, partitioning, clustering, retention, and performance.
• Define scalable patterns for historical data, incremental processing, CDC, and slowly changing dimensions.
• Establish master and reference data standards.
• Define data-quality frameworks, reconciliation controls, observability, lineage, and monitoring.
• Establish security architecture including IAM, service accounts, row‑level security, column‑level security, policy tags, encryption, PII protection, and environment separation.
• Establish BigQuery cost‑management and optimization practices.
• Develop standards for CI/CD, infrastructure as code, testing, deployment, and environment management.
• Work across BI, data engineering, application, infrastructure, security, and business teams.
• Provide technical leadership and mentoring to internal engineering resources and implementation partners.
• Develop a phased migration and implementation roadmap.

SUMMARY:

Work your way– Enjoy the freedom to work from anywhere, with flexible hours that match your natural rhythm.

Work with global clients– Collaborate directly with international teams to create real impact.

Great people, no micromanagement– Join a supportive, results-focused team where you’re trusted to do your best work.

This flexibility allows developers…

A better work-life balance

Increased productivity

The ability to work any time around the clock