Logo
Synstack Technologies

BI Architect – Looker & GCP

Synstack Technologies, San Ramon, California, United States, 94583

Save Job

Role:

Looker + Google Big Query Architect

Experience:

7–10 years (minimum 3+ years in Looker & GCP Data Stack)

About the Role We are looking for an experienced Looker + GBQ Architect to lead analytics solutioning, architecture design, and performance optimization across our enterprise-scale data ecosystem. The ideal candidate should have a strong foundation in data Modeling, Look ML, and GCP (Big Query, Cloud Composer, Dataflow, Pub/Sub) with the ability to work directly with business stakeholders, data engineers, and visualization teams.

This role will anchor our BI modernization journey for Data Engineering AMS and Looker Functional teams, ensuring scalable, secure, and performant data analytics delivery.

Key Responsibilities

Design and implement end-to-end Looker + GBQ architecture, ensuring scalability and alignment with enterprise data strategy.

Define semantic layer, LookML models, and reusable data components for cross-functional BI use cases.

Create and enforce best practices for data Modeling, partitioning, and optimization in Big Query.

Development & Implementation

Lead Looker dashboard and data model development for business-critical functions (Finance, Sales, Product).

Collaborate with DE & BI teams to define data pipelines feeding Looker, ensuring freshness, lineage, and consistency.

Enable parameterized and governed exploration within Looker for end-users and analysts.

Governance, Security & Performance

Implement row-level and column-level security models in Looker and GBQ.

Optimize query performance and cost management within GBQ.

Drive monitoring, logging, and SLA adherence for Looker reports and data sources.

Establish automated health checks and observability dashboards across BI environments.

Work closely with product owners, business analysts, and DE teams to translate business KPIs into scalable data models.

Mentor and guide the Looker Functional Team and ensure alignment with global data architecture standards.

Contribute to the data governance framework, ensuring compliance with enterprise and regulatory guidelines.

Evaluate and integrate AI/ML and advanced analytics within Looker/GBQ ecosystem where applicable.

Identify opportunities to automate operational reporting and ticket workflows (e.g., integration with Wolken or JIRA).

Drive adoption of modern Looker features (Looker Blocks, Looker API, embedded analytics).

Required Skills

Looker, LookML, and Looker API

SQL optimization and cost-efficient query structuring

Soft Skills

Excellent communication, stakeholder management, mentoring, and problem-solving ability.

Preferred Qualifications

Looker Certification (LookML Developer / Looker Business Analyst)

Experience in AMS / Managed Service environment or data product operations.

Exposure to Snowflake / DBT migration to GBQ is a plus.

Synstack Technologies is an Equal Opportunity Employer. All qualified applicants, including individuals with disabilities and protected veterans, are encouraged to apply.

#J-18808-Ljbffr