Data Engineer – Financial Analytics (FP&A)
Company DescriptionEngineering the AI-powered enterprise. With AI and cloud-native solutions, BETSOL accelerates cloud transformation for enterprises across 17+ countries. BETSOL holds several engineering patents, and is recognized with industry awards. BETSOL maintains a net promoter score that is 2x the industry average.
BETSOL’s open source backup and recovery product line, Zmanda (Zmanda.com), delivers up to 50% savings in total cost of ownership (TCO) and delivers best-in-class performance.
BETSOL Global IT Services (BETSOL.com) builds and supports end-to-end enterprise solutions, reducing time-to-market for customers.
We take pride in being an employee-centric organization, offering comprehensive benefits and opportunities.
Learn more at betsol.com
Job DescriptionAbout the Role
We are hiring a mid-level Data Engineer to build the financial data foundation behind executive reporting, working directly with the Head of FP&A on Google BigQuery. This role turns scattered financial and operational data into a single, trusted reporting model that leadership uses to run the business. You will act as the technical partner to the Head of FP&A, translating planning, forecasting and performance questions into well-designed data models and repeatable metrics.
You will own the path from source systems to executive dashboards: gathering data from ERP, CRM, billing, HR and spreadsheet sources, modeling it in BigQuery, and delivering metrics such as revenue, gross margin, operating expense, budget-versus-actual variance and cash position. The aim is to reduce manual spreadsheet effort in monthly close and planning cycles, and to give leadership faster, consistent answers.
Responsibilities
Partnering with FP&A
Work day to day with the Head of FP&A to understand reporting needs across budgeting, forecasting, month-end close and board reporting.Translate business questions into data requirements, metric definitions and model designs, and document them clearly.Support planning cycles with timely, reconciled data and ad hoc analysis for leadership requests.Data integration and transformation
Gather data from multiple sources such as ERP, CRM, billing, payroll/HR systems, bank feeds and Excel or Google Sheets workbooks.Build and maintain ELT pipelines into BigQuery, using SQL, scheduled queries and orchestration tools (for example Dataform, dbt or Cloud Composer).Cleanse, standardize and reconcile data, including chart-of-accounts mapping, currency conversion and intercompany eliminations.Multidimensional data modeling
Design star and snowflake schemas with conformed dimensions (time, entity, account, cost center, product, customer, region) and well-defined fact tables.Handle slowly changing dimensions, account hierarchies, fiscal calendars and actuals-versus-budget-versus-forecast scenarios.Optimize BigQuery models for cost and performance through partitioning, clustering and materialized views.Financial metrics and reporting
Build a governed semantic layer of financial KPIs: revenue, ARR/MRR where relevant, gross margin, EBITDA, OpEx by function, headcount cost, cash flow and variance analysis.Deliver reporting models that feed executive dashboards in Looker, Looker Studio, Power BI or Connected Sheets.Produce Excel-ready outputs and pivot-friendly extracts for finance users who work in spreadsheets.Data quality and governance
Implement reconciliation checks between source systems, the general ledger and reported figures.Apply access controls appropriate to sensitive financial data and maintain a data dictionary for every published metric.Monitor pipeline health and resolve data issues before they reach leadership reports.Looking For
4-8 years of experience in Data Engineering or Analytics Engineering.Minimum 2 years of hands-on experience working with Google BigQuery Strong experience building data pipelines, dimensional data models, and financial reporting solutions.Experience working with finance, FP&A, or business analytics teams.Strong understanding of financial reporting concepts such as P&L, Balance Sheet, Cash Flow, Budget vs Actuals, and Forecast Variance analysis. Mandatory Skills
Technical Skills
Expert SQL: complex joins, window functions, CTEs, aggregations, query tuning and BigQuery-specific features (partitioning, clustering, nested and repeated fields, scheduled queries).Proven experience designing multidimensional (dimensional) data models using Kimball methodology: facts, dimensions, hierarchies and slowly changing dimensions.Advanced Excel: Power Query, pivot tables, XLOOKUP/INDEX-MATCH, dynamic arrays and building finance-ready reporting templates.Hands-on experience integrating data from at least three types of source systems (for example ERP, CRM, flat files, APIs).Working knowledge of financial statements and FP&A concepts: P&L, balance sheet, cash flow, chart of accounts, budget-versus-actual and forecast variance.Experience with at least one BI tool such as Looker, Looker Studio or Power BI.Clear communicator who can explain data logic to finance leaders and document metric definitions precisely.Soft Skills
Strong analytical and problem-solving skillsAbility to work directly with senior finance stakeholdersClear communicator who can explain data logic to finance leaders and document metric definitions precisely.Stakeholder management and business partnering capabilityAbility to translate business requirements into technical solutionsGood to Have Skills
Experience with dbt or Dataform for version-controlled, tested SQL transformations.Familiarity with LookML or a comparable semantic modeling layer.Exposure to ERP finance modules (for example NetSuite, SAP, Oracle or Microsoft Dynamics) and planning tools (for example Anaplan, Adaptive Planning or Pigment).Python for data processing, API ingestion or automation.Experience with Git, CI/CD and Google Cloud services such as Cloud Storage, Cloud Functions and Cloud Composer.Google Cloud Professional Data Engineer certification.Prior work in a SaaS, IT services or multi-entity, multi-currency businessQualificationsBachelor's degree in Computer Science, Information Systems, Engineering, Finance, Statistics or a related field
Additional InformationUK business hours with overlap till 1 pm EST
BETSOL’s open source backup and recovery product line, Zmanda (Zmanda.com), delivers up to 50% savings in total cost of ownership (TCO) and delivers best-in-class performance.
BETSOL Global IT Services (BETSOL.com) builds and supports end-to-end enterprise solutions, reducing time-to-market for customers.
We take pride in being an employee-centric organization, offering comprehensive benefits and opportunities.
Learn more at betsol.com
Job DescriptionAbout the Role
We are hiring a mid-level Data Engineer to build the financial data foundation behind executive reporting, working directly with the Head of FP&A on Google BigQuery. This role turns scattered financial and operational data into a single, trusted reporting model that leadership uses to run the business. You will act as the technical partner to the Head of FP&A, translating planning, forecasting and performance questions into well-designed data models and repeatable metrics.
You will own the path from source systems to executive dashboards: gathering data from ERP, CRM, billing, HR and spreadsheet sources, modeling it in BigQuery, and delivering metrics such as revenue, gross margin, operating expense, budget-versus-actual variance and cash position. The aim is to reduce manual spreadsheet effort in monthly close and planning cycles, and to give leadership faster, consistent answers.
Responsibilities
Partnering with FP&A
Work day to day with the Head of FP&A to understand reporting needs across budgeting, forecasting, month-end close and board reporting.Translate business questions into data requirements, metric definitions and model designs, and document them clearly.Support planning cycles with timely, reconciled data and ad hoc analysis for leadership requests.Data integration and transformation
Gather data from multiple sources such as ERP, CRM, billing, payroll/HR systems, bank feeds and Excel or Google Sheets workbooks.Build and maintain ELT pipelines into BigQuery, using SQL, scheduled queries and orchestration tools (for example Dataform, dbt or Cloud Composer).Cleanse, standardize and reconcile data, including chart-of-accounts mapping, currency conversion and intercompany eliminations.Multidimensional data modeling
Design star and snowflake schemas with conformed dimensions (time, entity, account, cost center, product, customer, region) and well-defined fact tables.Handle slowly changing dimensions, account hierarchies, fiscal calendars and actuals-versus-budget-versus-forecast scenarios.Optimize BigQuery models for cost and performance through partitioning, clustering and materialized views.Financial metrics and reporting
Build a governed semantic layer of financial KPIs: revenue, ARR/MRR where relevant, gross margin, EBITDA, OpEx by function, headcount cost, cash flow and variance analysis.Deliver reporting models that feed executive dashboards in Looker, Looker Studio, Power BI or Connected Sheets.Produce Excel-ready outputs and pivot-friendly extracts for finance users who work in spreadsheets.Data quality and governance
Implement reconciliation checks between source systems, the general ledger and reported figures.Apply access controls appropriate to sensitive financial data and maintain a data dictionary for every published metric.Monitor pipeline health and resolve data issues before they reach leadership reports.Looking For
4-8 years of experience in Data Engineering or Analytics Engineering.Minimum 2 years of hands-on experience working with Google BigQuery Strong experience building data pipelines, dimensional data models, and financial reporting solutions.Experience working with finance, FP&A, or business analytics teams.Strong understanding of financial reporting concepts such as P&L, Balance Sheet, Cash Flow, Budget vs Actuals, and Forecast Variance analysis. Mandatory Skills
Technical Skills
Expert SQL: complex joins, window functions, CTEs, aggregations, query tuning and BigQuery-specific features (partitioning, clustering, nested and repeated fields, scheduled queries).Proven experience designing multidimensional (dimensional) data models using Kimball methodology: facts, dimensions, hierarchies and slowly changing dimensions.Advanced Excel: Power Query, pivot tables, XLOOKUP/INDEX-MATCH, dynamic arrays and building finance-ready reporting templates.Hands-on experience integrating data from at least three types of source systems (for example ERP, CRM, flat files, APIs).Working knowledge of financial statements and FP&A concepts: P&L, balance sheet, cash flow, chart of accounts, budget-versus-actual and forecast variance.Experience with at least one BI tool such as Looker, Looker Studio or Power BI.Clear communicator who can explain data logic to finance leaders and document metric definitions precisely.Soft Skills
Strong analytical and problem-solving skillsAbility to work directly with senior finance stakeholdersClear communicator who can explain data logic to finance leaders and document metric definitions precisely.Stakeholder management and business partnering capabilityAbility to translate business requirements into technical solutionsGood to Have Skills
Experience with dbt or Dataform for version-controlled, tested SQL transformations.Familiarity with LookML or a comparable semantic modeling layer.Exposure to ERP finance modules (for example NetSuite, SAP, Oracle or Microsoft Dynamics) and planning tools (for example Anaplan, Adaptive Planning or Pigment).Python for data processing, API ingestion or automation.Experience with Git, CI/CD and Google Cloud services such as Cloud Storage, Cloud Functions and Cloud Composer.Google Cloud Professional Data Engineer certification.Prior work in a SaaS, IT services or multi-entity, multi-currency businessQualificationsBachelor's degree in Computer Science, Information Systems, Engineering, Finance, Statistics or a related field
Additional InformationUK business hours with overlap till 1 pm EST