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.
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.
- 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
- 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
- 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
Artificial Intelligence • Cloud • Information Technology • Consulting • Cybersecurity • Infrastructure as a Service (IaaS)
Creates and validates monthly customer invoices using AWS billing and other data sources, syncs invoices with financial systems, resolves discrepancies with Accounting and vendors, and responds to customer inquiries. Supports month-end close, financial reporting, margin analysis, and accounts receivable activities while identifying billing process improvements. Requires strong Excel and macro skills, attention to detail, communication, organization, and relevant billing, invoicing, or accounts receivable experience.
Top Skills:
AWSErp SystemsExcelVba Macros
Cloud • Fintech • Software • Business Intelligence • Consulting • Financial Services
Leads R&D tax credit consulting engagements for clients, including client interviews, tax research, technical analysis, computations, data gathering, project coordination, and drafting opinion letters, IRS responses, ruling requests, and technical memoranda. Collaborates with operations, finance, accounting, and engineering personnel while managing multiple projects and developing industry expertise.
Top Skills:
Internal Revenue Code Sections 174 And 41Microsoft AccessExcelMS OfficeMicrosoft Word
Machine Learning • Payments • Security • Software • Financial Services
Administers and supports enterprise Informatica ETL platforms across cloud and on-premises environments. Installs, configures, upgrades, secures, and troubleshoots Informatica components on Linux, including LDAP, authentication, performance, and job issues. Coordinates incident resolution across infrastructure, network, database, and security teams; supports development teams and vendors; documents platforms; enforces security policies; and meets disaster recovery objectives. The role also provides technical guidance on platform engineering standards, scalable solutions, and reliable delivery.
Top Skills:
ArtifactoryAs400Ca7Cloud ComputingConnect:DirectControl-MDb2Flat FilesHiveHttpsIbm MqIdmc ApiInfacmdInformatica Data Management CloudInformatica Data Processor TransformationInformatica Intelligent Data Management CloudInformatica PowercenterInformatica PowerexchangeInformatica Test Data ManagementInfrastructure As CodeKafkaLdapLinuxMainframeMongoDBMySQLNasNdmOraclePmcmdPmrepRed Hat LinuxSASServicenowSQL ServerTeradataUdeployVirtualizationWeb Services
What you need to know about the Austin Tech Scene
Austin has a diverse and thriving tech ecosystem thanks to home-grown companies like Dell and major campuses for IBM, AMD and Apple. The state’s flagship university, the University of Texas at Austin, is known for its engineering school, and the city is known for its annual South by Southwest tech and media conference. Austin’s tech scene spans many verticals, but it’s particularly known for hardware, including semiconductors, as well as AI, biotechnology and cloud computing. And its food and music scene, low taxes and favorable climate has made the city a destination for tech workers from across the country.
Key Facts About Austin Tech
- Number of Tech Workers: 180,500; 13.7% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Dell, IBM, AMD, Apple, Alphabet
- Key Industries: Artificial intelligence, hardware, cloud computing, software, healthtech
- Funding Landscape: $4.5 billion in VC funding in 2024 (Pitchbook)
- Notable Investors: Live Oak Ventures, Austin Ventures, Hinge Capital, Gigafund, KdT Ventures, Next Coast Ventures, Silverton Partners
- Research Centers and Universities: University of Texas, Southwestern University, Texas State University, Center for Complex Quantum Systems, Oden Institute for Computational Engineering and Sciences, Texas Advanced Computing Center



