Senior Google Cloud Data & Automation Developer

ZAZZ

India

Remote

INR 600.000 - 1.200.000

Vollzeit

Vor 3 Tagen
Sei unter den ersten Bewerbenden

Erhalte eine Antwort von diesem Arbeitgeber

Dein Lebenslauf und dein Anschreiben, genau auf das zugeschnitten, was gesucht wird.

Schaffe es an den ATS-Filtern vorbei

Zusammenfassung

ZAZZ is hiring a hands-on data engineer to join its remote team. The role focuses on building data ingestion pipelines and data models using Google Apps Script, BigQuery, and SQL to support a live client project.

You will own the data engineering and backend automation layer, collaborate with a Principal Consultant on financial design, and ensure data quality, performance, and cost management across multi-entity, multi-currency data structures.

Qualifikationen

  • 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
  • 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

Aufgaben

  • 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
  • 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

Kenntnisse

Google Apps Script
SQL
BigQuery
REST API integration
Git/version control
dbt Core

Tools

Google Apps Script
BigQuery
dbt Core

Jobbeschreibung

Job Information
  • Date Opened 11/06/2026
  • Job Type Full time
  • Work Experience Fresher
  • Industry Services
  • Remote Job
About Us

Welcome to the Cutting‑Edge of Innovation: ZAZZ

Step into the world of ZAZZ, a realm where innovative design meets software development brilliance. We’re not your average tech company; we’re trendsetters shaping the future, crafting digital masterpieces, and redefining boundaries.

At ZAZZ, technology isn’t just a tool— it’s our canvas, our playground. Our passionate, ingenious team doesn’t just adapt to the latest technologies; we shape them. Join us, and you’ll be at the heart of a revolution, influencing, and driving technological advancements.

Empowering People. Transforming Experiences.

Ever dreamed of putting your mark on the digital universe? ZAZZ is the place. We breathe life into a bottom‑up approach where our employees and users are the stars. Here, you won’t just be creating software—you’ll be part of a grand journey to revolutionize digital experiences.

Dive into the Tech Spectrum

With ZAZZ, you don’t just get a job; you get an open ticket to a roller‑coaster of challenges and opportunities. From Product Strategy, IoT App Development to the bleeding‑edge Blockchain tech, we cover the entire spectrum of tech innovation. Prepare to ignite your creativity and fuel your passion in an environment buzzing with groundbreaking ideas and projects.

Shaping the Future, Together

It doesn’t matter if our client is a fledgling startup, a dynamic SME, or a Fortune 500 titan—we’ve partnered with them all. At ZAZZ, you’ll gain unparalleled exposure and experience in diverse sectors and technologies. You’ll not just grow; you’ll evolve.

Why Join ZAZZ?

If you’re seeking a place where your curiosity is celebrated, your skills valued, and your growth accelerated, look no further. ZAZZ offers a thriving work environment, opportunities for continuous learning, and the chance to work with some of the best minds in the industry. Plus, our team loves to get geeky over a coffee chat on the latest tech!

So, are you ready to leave a lasting footprint in the tech world? Join the ZAZZ family, and together, let’s create the future.

Job Description

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)
Hol dir deinen kostenlosen, vertraulichen Lebenslauf-Check.

oder ziehe deine Datei hierhin.

Similar jobs

Ähnliche Jobs, die dir auch gefallen könnten

Senior Staff Data Engineer
Senior Staff Data Engineer

MeeruAI Inc. • Hyderabad

Remote
INR 13.170.000 - 18.815.000
Remote work
Flexible engagement
Senior Staff Data Engineer
Senior Staff Data Engineer

Meeru AI Inc • Hyderabad

Remote
INR 3.500.000 - 6.000.000
Remote work
Flexible engagement
Senior Staff Data Engineer
Senior Staff Data Engineer

MeeruAI • Hyderabad

Remote
INR 4.000.000 - 7.000.000
Data & Analytics Engineer
Data & Analytics Engineer

hotsourced • Indien

Remote
INR 1.004.000 - 1.674.000
Data Engineer
Data Engineer

Geniusoffice • Indien

Hybrid
INR 1.500.000 - 2.100.000
Database and Systems Engineer (Remote | Bangalore, India)
Database and Systems Engineer (Remote | Bangalore, India)

Netchex • Bengaluru Urban

Vor Ort
INR 1.800.000 - 3.200.000
Senior Data Engineer
Senior Data Engineer

Zinier • Bengaluru

Vor Ort
INR 3.000.000 - 5.400.000
Data Engineer
Data Engineer

Questhiring • Gurugram District

Vor Ort
INR 1.400.000 - 2.400.000
Senior Data Engineer
Senior Data Engineer

Lifesight • Bengaluru

Vor Ort
INR 2.800.000 - 4.200.000
Data Engineer - Cloud Analytics Jobs
Data Engineer - Cloud Analytics Jobs

FinOpsly • Bengaluru

Vor Ort
INR 1.200.000 - 1.800.000