Logo for Zazz.io

Senior Google Cloud Data & Automation Developer

Role overview

Summary

This role focuses on developing a custom AI-native FP&A platform for a B2B SaaS client, ensuring robust data engineering and backend automation. You will work closely with a Principal Consultant to deliver precise specifications and maintain high data quality, supporting financial processes and integration with Google technologies.

Qualifications

  • Strong Google Apps Script experience (triggers, Advanced Services, HTML Service for sidebars/dialogs, quota-aware design)
  • Strong SQL and BigQuery experience — partitioning, clustering, cost-aware query design, scheduled queries; dbt Core experience a plus
  • Experience integrating with REST APIs from ERP/CRM/HRIS systems
  • Comfort with financial data structures: chart of accounts, GL postings, cost centers, headcount/comp data
  • Discipline with version control (Git) for SQL, dbt models, and Apps Script code

Responsibilities

  • Build and maintain ingestion pipelines from source systems into BigQuery via Apps Script and/or Cloud Functions.
  • Write and maintain the canonical dimensional model in BigQuery, including dimension and versioned fact tables.
  • Build multi-entity consolidation logic, handling the client's global subsidiary structure.
  • Maintain data quality and reconciliation tooling, including freshness monitoring and integrity checks.

Key facts

  • Remote from: Canada, North America
  • Full time
  • Senior (5-10 years)
  • Data Warehouse Developer
  • English

Hard skills

Key skills for this role

Other skills

  • Detail Oriented
  • Problem Solving

About the company

Zazz.io logo

Zazz.io

  • IT Services & Consulting
  • SME
  • 201–500
We at Zazz are triggering a Digital & Mobile revolution, by using code, passion, ideas, emotions, and the world’s most powerful technological platforms. We believe in crafting incredible experiences for the users, and our mission is to unleash unstoppable success and sustainable growth for our clients, all across the globe. Our 275+ strong team of UI/UX experts, talented programmers and dedicated business analysts, marketing mavericks, mobile app architects, solution engineers etc, based globally across the world. Wecreate scalable, powerful, and aesthetically stunning mobile apps and websites, powered with futuristic technologies such as Artificial Intelligence, Machine Learning, Internet Of Things, Metaverse and a lot more. If you’re still wondering Why Zazz? Well, because we are the change-makers, the disruptors of the status quo. We’re determined to provide the best in the class technological services to startups, SMEs, enterprises, and corporations all across the US and Canada. We’re the unfair advantage that you can have for the success of your company. Led by strong leadership, we at Zazz have incorporated a growth mindset, an agile working model, and a passion for delivering solutions and success, no matter how hard the challenge is. Team Zazz invites you to join forces with us because together, we can create a better, more beautiful, and breathtaking future. Join us, and experience the future of mobile and digital, right here, right now!

Your match analysis

See how your profile stacks up against this role.

We compared the job requirements to your profile to show where you're strong and where you fall short.

Job description

This is a remote position.

About the role

One of our client is building a custom AI-native FP&A platform delivered on Google Sheets, Google Apps Script, BigQuery, and the Anthropic Claude API — deliberately built with no third-party dependencies. We're deploying it for a live client engagement: a $500M-revenue, ~1,200-employee, multi-entity B2B SaaS company (US/UK HQ plus several international subsidiaries, PE-backed and pre-IPO). We need a hands-on developer to own the data engineering and backend automation layer so the Principal Consultant can focus on financial design, client relationship, and the AI/context
layer.

What you'll do

  • Build and maintain ingestion pipelines from source systems (ERP, CRM, HRIS) into BigQuery via Apps Script and/or Cloud Functions — handling OAuth, API rate limits, scheduled triggers, and idempotent retries
  • Write and maintain the canonical dimensional model in BigQuery: dimension tables (accounts, departments, employees, customers, fiscal calendar) and versioned fact tables (fact_actuals, fact_forecast, fact_budget, fact_headcount, fact_pipeline, fact_quota)
  • Build multi-entity consolidation logic — FX translation, intercompany elimination, entity-level rollups — correctly handling the client's global subsidiary structure
  • Own Connected Sheets integration points so finance users work in familiar Sheets while queries run against BigQuery
  • Solve the Snowflake connectivity requirement (JWT key-pair auth via raw UrlFetchApp, since Apps Script has no native Advanced Service for Snowflake) if/when that source system comes into scope
  • Maintain data quality and reconciliation tooling — freshness monitoring, schema validation, not-null/unique/referential integrity checks (dbt Core or scheduled BigQuery queries)
  • Support monthly close, forecast, and quota cycles from the engineering side: fixing pipeline breaks, tuning query performance, managing BigQuery cost (partitioning, pre-aggregation)
  • Work from exact specifications provided by the Principal Consultant (column names, SQL, schema definitions) with high fidelity — this is a precision-driven build, not a loose one

What we need

  • Strong Google Apps Script experience (triggers, Advanced Services, HTML Service for sidebars/dialogs, quota-aware design)
  • Strong SQL and BigQuery experience — partitioning, clustering, cost-aware query design, scheduled queries; dbt Core experience a plus
  • Experience integrating with REST APIs from ERP/CRM/HRIS systems (e.g., NetSuite, Salesforce, HubSpot, BambooHR, Rippling, Xero/QuickBooks) — auth flows, pagination, rate-limit handling
  • Comfort with financial data structures: chart of accounts, GL postings, cost centers, headcount/comp data, pipeline/opportunity data — you don't need to be a finance person, but you need to not be scared of a trial balance
  • Experience with multi-entity / multi-currency data models is a strong plus given this client's structure
  • Discipline with version control (Git) for SQL, dbt models, and Apps Script code
  • Comfort working to exact, detailed specs and flagging deviations rather than improvising around them
  • No dependency on third-party iPaaS, ETL SaaS, or vector database tooling — this stack is Google + Claude only, by design

Nice to have

  • Prior experience in FP&A, EPM, or financial systems implementation (Vena, Anaplan, Adaptive Insights, Datarails, etc.)
  • Experience with SOC 2 / data governance documentation in a client-facing consulting context
  • Familiarity with the Anthropic Claude API (not required to build with it, but useful to understand what it's querying against)


Related jobs

See all Data Warehouse Developer jobs

Other jobs at Zazz.io