For Employers

Zazz

Senior Google Cloud Data & Automation Developer

Posted 28 minutes ago
Worldwide
5-10 years experience
Apply Now

Please mention DailyRemote when applying

?Not checked yet0100
Resume Match Score

See how much of this job your resume covers, and what’s missing.

Want a recruiter to go through it line by line?

Get professional review

Tailor your resume to this job

One click makes a copy of your resume for this role, scores it against the posting, and proposes edits line by line. Your default resume is never changed.

  • Job match score for this posting
  • Edits you accept or skip, no invented facts
  • Download it when it reads right: TXT free, PDF with Premium

Create a cover letter for this job

Upload your resume and we draft a letter for this exact role, tailored to what it asks for.

  • Tailored to this role
  • Based on your resume
  • Fully editable
AI Summary

The developer will own the data engineering and backend automation layer, building ingestion pipelines and maintaining canonical dimensional models in BigQuery. They will also support monthly financial cycles by managing data quality, reconciliation, and query performance.

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)


Automatically Apply to the Best Remote Jobs

Stop the endless job search. Our AI finds and applies to the best jobs for you.

Try it Now
Keep looking

Similar Jobs

See all Remote Software Development jobs →

Senior C/Unix Developer (Healthcare)

Full Time United States $72800 - $104K per year Software Development

Senior DevOps and Systems Engineer

Full Time United Kingdom Software Development

Data Analyst

Full Time United States $100K - $110K per year Software Development

DESENVOLVIMENTO - Desenvolvedor Baixa Plataforma - Java

Full Time Worldwide Software Development

Desenvolvedor Sr (python + angular)

Full Time Worldwide Software Development

Business Intelligence Sr Principal

Full Time Australia Software Development
Apply Now

Personalize your Remote Job Search in 3 Easy Steps!

Featuring 213,064+ Jobs in Software Development

Answer easy questions

Answer easy questions

213,064+ jobs across 15+ categories

Get your best job matches

Get your best job matches

Only hand-screened, legit jobs

Find a remote job faster

Find a remote job faster

No ads, scams, or junk

“I was the first applicant for a remote marketing position that got listed on the company website the same day I applied. Had an interview within 48 hours!”

Sarah J. — Sarah J. · Marketing Manager ★★★★★ Verified