> Markdown version of [/jobs/ext/3028851-google-bigquery-data-lake-architect-consultant](https://www.wearedevelopers.com/jobs/ext/3028851-google-bigquery-data-lake-architect-consultant). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Google BigQuery Data Lake Architect Consultant - **Company:** E-Volve Systems, L.L.C. - **Location:** United States (Remote available) - **Experience:** Expert - **Contract:** Temporary to permanent - **Skills:** Application Programming Interfaces (APIs), Artificial Intelligence, Airflow, Architectural Patterns, BigQuery, Software as a Service, Cloud Storage, Cyber Security, Databases, Continuous Integration, Data Architecture, Information Engineering, Data Governance, Data Infrastructure, Extract Transform Load (ETL), Data Warehousing, Data Flow Control, Identity and Access Management, Machine Learning, Metadata, Netsuite, Reference Data, Cloudera, Shopify, SQL Databases, Data Streaming, Google Cloud, Enterprise Software Applications, Snowflake, Git, Data Layers, Data Lakes, Infrastructure Automation Frameworks - **Published:** September 22, 2026 - **Apply:** https://evolvesquads.com/jobs/google-bigquery-data-lake-architect-consultant ## About the Role * 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. ## Description * Initial duration: 3 to 6 months, with strong possibility of extension. * US-based candidates only. * Must be able to work in the Pacific Time Zone. * Consulting role requiring hands-on architecture and implementation leadership. The consultant should be comfortable integrating data from a heterogeneous retail technology environment, including platforms such as: * Shopify Plus * Manhattan POS * Aptos Merchandising and Allocation * Aptos WMS * Aptos CRM * Aptos Sales Audit * NewStore OMS * NetSuite Financials * Listrak * ProShip * Google Cloud Platform, * 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. * Establish architectural patterns using BigQuery, Cloud Storage, Dataflow, Dataproc, Pub/Sub, Cloud Composer / Airflow, 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., * 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 ## Related Videos - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [WeAreDevelopers LIVE - Markdown, Liquid and Checkouts](https://www.wearedevelopers.com/videos/1814-wearedevelopers-live-markdown-liquid-and-checkouts) - [How a Small Team Shrank a Microsoft Monorepo by 94%](https://www.wearedevelopers.com/videos/1236-how-a-small-team-shrank-a-microsoft-monorepo-by-94) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [Teini - an extremely small webshop leveraging awesome and free tech](https://www.wearedevelopers.com/videos/286-teini-an-extremely-small-webshop-leveraging-awesome-and-free-tech) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Got AI ideas but no money? Here are 10 free ways to level up your AI skills with Google Cloud](https://www.wearedevelopers.com/magazine/600-got-ai-ideas-but-no-money-here-are-10-free-ways-to-level-up-your-ai-skills-with-google-cloud) - [Top Big Data Technologies That You Need to Know](https://www.wearedevelopers.com/magazine/108-top-big-data-technologies-that-you-need-to-know) - [7 Cloud Computing Trends Coming in 2025 for Developers](https://www.wearedevelopers.com/magazine/412-7-cloud-computing-trends-coming-in-2025-for-developers) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers)