BigQuery Architect

Job Title: BigQuery Architect

Location: NY/NJ(Preference is local candidate as candidate need to be in office 2days a week but for right candidate Remote is a possibility)

Duration: 6+ Months

We are seeking an experienced BigQuery Architect with 12+ years exp to lead the design, architecture, and implementation of enterprise-scale dataplatforms on Google Cloud Platform (GCP). The ideal candidate will have deep expertise in BigQuery, data warehousing, data engineering, real-time analytics, data governance, and cloud modernization initiatives.

The architect will be responsible for defining enterprise data strategies, designing scalable data solutions, optimizing performance andcosts, and providing technical leadership across data engineering and analytics teams.

Key Responsibilities

Data Architecture & Design

Design and implement enterprise-scale data warehouse and Lakehouse solutions using BigQuery.

Create scalable, secure, and high-performance data architectures for structured and unstructured data.

Define canonical data models, dimensional models, and enterprise information architectures.

Lead cloud data modernization and migration initiatives from on-premises platforms to GCP.

BigQuery Engineering

Architect large-scale data ingestion, transformation, and reporting solutions.

Design partitioning, clustering, materialized views, and query optimization strategies.

Implement BigQuery performance tuning and cost optimization best practices.

Establish enterprise standards for data storage, querying, and lifecycle management.

Data Integration & ETL

Design batch and real-time data pipelines using:

Dataflow

Dataproc

Pub/Sub

Cloud Composer (Airflow)

Data Fusion

Implement ELT frameworks leveraging BigQuery and SQL-based transformations.

Build metadata-driven and reusable ingestion frameworks.

Data Governance & Security

Define enterprise data governance frameworks.

Implement IAM, row-level security, column-level security, and data masking.

Ensure compliance with GDPR, HIPAA, CCPA, and industry-specific regulations.

Establish data quality, lineage, metadata, and audit controls.

Leadership & Stakeholder Management

Lead architecture reviews and technical governance boards.

Mentor data engineers, architects, and technical leads.

Collaborate with business, product, analytics, and infrastructure teams.

Drive solution proposals, technical estimations, and pre-sales activities.

Preferred Experience

Large-scale data platform modernization programs.

Migration from Oracle, Teradata, SQL Server, Snowflake, Redshift, Netezza, Hadoop, or Azure platforms to BigQuery.

Insurance, Banking, domain experience.

Experience handling petabyte-scale datasets.

AI/ML integration with BigQuery ML and Vertex AI.

Data Mesh and Data Product implementation experience.

Certifications (Preferred)

Google Professional Data Engineer

Google Professional Cloud Architect

Google Cloud Digital Leader