Senior Google Cloud Data & Automation Developer

Posted 6 Days Ago
Hiring Remotely in Seattle, WA, USA
In-Office or Remote
Senior level
Virtual Reality
The Role
Own the data engineering and backend automation layer for an AI-native FP&A platform. Build ingestion pipelines into BigQuery, dimensional and multi-entity financial models, Connected Sheets integrations, data quality tooling, and Snowflake connectivity. Support financial close, forecasting, and quota cycles through pipeline maintenance, query optimization, cost management, and reconciliation. Work precisely from detailed specifications while integrating ERP, CRM, and HRIS APIs.
Summary Generated by Built In

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)


Skills Required

  • Strong Google Apps Script experience, including triggers, Advanced Services, HTML Service, and quota-aware design
  • Strong SQL and BigQuery experience, including partitioning, clustering, cost-aware query design, and scheduled queries
  • Experience integrating REST APIs from ERP, CRM, or HRIS systems, including authentication, pagination, and rate-limit handling
  • Comfort working with financial data structures such as chart of accounts, GL postings, cost centers, headcount, compensation, and pipeline data
  • Experience with multi-entity or multi-currency data models
  • Discipline with Git version control for SQL, dbt models, and Apps Script code
  • Ability to work to exact, detailed specifications and flag deviations rather than improvise
  • Prior experience in FP&A, EPM, or financial systems implementation
  • Experience with SOC 2 or data governance documentation in a client-facing consulting context
  • Familiarity with the Anthropic Claude API
  • dbt Core experience
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Seattle, WA
1,000 Employees
Year Founded: 2019

Similar Jobs

Qualtrics Logo Qualtrics

Senior Consultant

Artificial Intelligence • HR Tech • Information Technology • Software • Business Intelligence
Remote
United States
7500 Employees
126K-153K Annually

Qualtrics Logo Qualtrics

Senior Industry XM Advisor - Restaurants & Retail

Artificial Intelligence • HR Tech • Information Technology • Software • Business Intelligence
Remote
United States
7500 Employees
94K-130K Annually

Qualtrics Logo Qualtrics

Consultant

Artificial Intelligence • HR Tech • Information Technology • Software • Business Intelligence
Remote
United States
7500 Employees
149K-197K Annually

Qualtrics Logo Qualtrics

Enterprise Account Executive

Artificial Intelligence • HR Tech • Information Technology • Software • Business Intelligence
Remote
United States
7500 Employees
110K-144K Annually

Similar Companies Hiring

Snap Inc. Thumbnail
Artificial Intelligence • Cloud • Machine Learning • Mobile • Software • Virtual Reality • App development
Santa Monica, CA
5000 Employees
Sandbox VR Thumbnail
Events • Gaming • News + Entertainment • Retail • Virtual Reality
Tsim Sha Tsui East, Kowloon
650 Employees
Red 6 Thumbnail
Aerospace • Hardware • Software • Virtual Reality • Defense
Orlando, Florida
186 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account