Zazz Logo

Zazz

Senior Google Cloud Data & Automation Developer

Posted 3 Days Ago
In-Office or Remote
Hiring Remotely in Seattle, WA
Senior level
In-Office or Remote
Hiring Remotely in Seattle, WA
Senior level
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.
The summary above was generated by AI

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)


Similar Jobs

An Hour Ago
Remote or Hybrid
United States
97K-146K Annually
Senior level
97K-146K Annually
Senior level
Aerospace • Artificial Intelligence • Cloud • Machine Learning • Software • Cybersecurity • Defense
Analyze and automate supplier-quality data using ETL tools, dashboards, KPIs, and statistical techniques. Build actionable insights and predictive reporting for quality, engineering, production, and leadership teams. Collaborate cross-functionally on continuous improvement, coach employees on data-driven decision-making, deliver presentations, and document analytical processes. The role requires expertise in Alteryx or comparable ETL tools, Tableau or Power BI, SQL or Python, UX/UI design, and supplier-quality analytics.
Top Skills: AlteryxPower BIPythonReactSQLTableau
An Hour Ago
Remote
United States
144K-217K Annually
Senior level
144K-217K Annually
Senior level
Artificial Intelligence • Big Data • Cloud • Information Technology • Software • Cybersecurity • Data Privacy
Own regional field marketing strategy and execution for State and Local Government and Education markets across the West and Central regions. Develop full-funnel, multi-touch campaigns; manage events, vendors, budgets, lead flow, and ROI reporting; collaborate with Sales, Product Marketing, Campaigns, Demand Generation, Operations, and Channel teams to generate qualified pipeline and support SLED revenue goals.
Top Skills: GoldcastMarketoSalesforceTableau
An Hour Ago
Remote
US
180K-195K Annually
Senior level
180K-195K Annually
Senior level
Cloud • Software
Own the product direction and execution for NetBox Core, including roadmap intake, backlog management, sprint ceremonies, release planning, open source community engagement, customer research, API and data model evolution, and cross-functional communication. The role requires hands-on technical fluency with infrastructure software, APIs, schemas, backward compatibility, and engineering tradeoffs.
Top Skills: APIsGitGraphQLNetboxNetbox CloudNetbox EnterpriseRest

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account