2,305,927open jobs
146,300companies
271,009added this week
Browse all
Location
Remote (location not specified)
Seniority
Senior
Employment
Full-Time

Confirmed on the employer's own hiring board on Nov 16, 2026. First seen by Alion on Nov 6, 2026.

Overview
Company
Impact
Profile match
Zazz is an IT services company delivering consulting, engineering, cloud, cybersecurity, and managed solutions to enterprise environments and.

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)
Free account
Stop reading job ads. Get the ones that fit.
One free account turns this page into a shortlist built around your stack, your level and your pay.
Match on every job. Stack, seniority, pay and location, scored against your profile.
2,305,927 open roles. Read straight off company career pages, refreshed every day.
Unlimited applications. Every one you send is tracked in one place, on-site or on a company board.
3 tailored CVs a month. Rewritten for the exact job you are applying to. Included free.
Create a free account Continue with Google
Free forever. No card. Under a minute.

Your match

How well do you fit this role?
Two answers are enough for a real match. No account needed.
Check my fit
Answers stay in this browser until you create an account.

Recommended for you based on this role

Data Science
Similar stack
Same company
In your city
Data Engineer 1 hour ago
Remote (United States) · Public Trust · 5+ years exp · Bachelor's Degree
PHP
SQL
PHP
Drupal
DevOps
Azure
GitLab
Analytics
Power BI
ETL/ELT
Management
ServiceNow
SharePoint
Agile
Apply
Remote (Guatemala) · Full-Time · 5+ years exp · Bachelor's Degree · Guatemala
Python
SQL
AI/ML
Copilot Studio
Machine Learning
DevOps
GCP
Azure
AWS
Analytics
Power BI
Apply
Remote (Brazil) · Full-Time · 4+ years exp · São Paulo
Python
Databases
Snowflake
Databricks
AI/ML
Copilot
DevOps
Terraform
GitHub Actions
Prometheus
CI/CD
AWS
Kubernetes
Amazon EKS
AWS Lambda
Cortex
Incident Management
Amazon S3
IAM
Linux
Analytics
Tableau
Apply
$78k – $132k per year · Remote (United States) · Full-Time · 2+ years exp · Bachelor's Degree · Phoenix
Python
SQL
Databases
Databricks
Delta Lake
AI/ML
dbt
LLM
Analytics
Tableau
Power BI
Dimensional Modeling
Apply
Remote (Germany) · Full-Time · Neuss
Java
SQL
DevOps
Rest API
GCP
Git
Analytics
ETL/ELT
Talend
Management
Confluence
Jira
Scrum
Apply
See all jobs
This is one of many
2,305,927 more open roles from verified company boards, updated every day.