Back to jobs

Senior Google Cloud Data & Automation Developer

Pay
Pay not listed
Work setting
Remote — work setting source
Work setup in the employer’s posting: Remote
From the employer’s posting
Employment
Full-time — employment source
Employment type in the employer’s posting: Full time
From the employer’s posting

What you’ll work on

Full posting
  • Build ingestion pipelines from ERP, CRM and HRIS systems into BigQuery

  • Write and maintain the canonical dimensional model and fact tables in BigQuery

  • Build multi-entity consolidation with FX translation and intercompany elimination

  • Own Connected Sheets integration points for finance users

  • Maintain data quality and reconciliation checks such as freshness and referential integrity

From the employer’s posting
Build and maintain ingestion pipelines from source systems (ERP, CRM, HRIS) into BigQuery
Write and maintain the canonical dimensional model in BigQuery
Build multi-entity consolidation logic — FX translation, intercompany elimination, entity-level rollups
Own Connected Sheets integration points so finance users work in familiar Sheets while queries run against BigQuery
Maintain data quality and reconciliation tooling — freshness monitoring, schema validation, not-null/unique/referential integrity checks

Tools in this posting

  • SQL
  • BigQuery
  • dbt
  • Snowflake
Source — Tool mentions in context
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)
Check the employer’s page ↗

Posting record

Report an error

Actively hiringFirst seen by us 3 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20263 days ago
Recorded sightings
4
Last seen by us
Nov 21, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Time since we first saw it

Day 3

Early. Similar jobs usually come down between day 6 and day 56.

From 14,766 similar postings that came down. Coming down is not always a hire.

Zazz is hiring

1 open job

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

Your next step

Check the employer’s posting for the current role and application details.

Already applied? Track this application

Job description

View original posting ↗

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)

Demand for Data Engineer roles

New Data Engineer postings at the employers we follow are up 13% over the last 6 weeks compared with the 6 before.

Weekly new Data Engineer postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 845, the most 1,344, and the latest week had 1,007.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Engineer, by the work the posting describes.

Data engineers build and run the pipelines that copy data out of apps and outside services into a warehouse or lake, and fix them when a source changes or a load fails.

Expect SQL, Python, a cloud platform, a scheduler such as Airflow, and often tools for large data such as Spark or Kafka.

An analytics engineer works one step later, turning the raw data a data engineer lands into clean tables people can query.

US government figures for database architects

Median yearly pay, May 2025
$139,500
Expected change, 2025 to 2035
9.4% more jobsagainst 3.5% for all jobs

The government has no code for data engineers, so these figures are for the closest group, database architects, which includes data integration and data warehousing specialists.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 15-1243.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

Location not supplied.

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

AI answers unavailable

We couldn’t identify enough role detail in this saved description to support an AI answer. Read the full posting