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

About the Position

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 Description

The consultant will be responsible for:

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

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.

Nice 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.

We Offer

• 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
• Reduction in commute time
• Design your ideal daily schedule.
• Build a career, not just a job.
• Work smarter, not longer.
• More time with family and friends

Job Details

• Job Category: Data Lake Architect
• Job Location: LATAM (Remote)
• Skills: GCP, BigQuery

For more job openings, please follow Evolve Squads on LinkedIn.