FP&A Analytics Lead: Power BI, SAP & ZBB

Jobtailor; California (MO); On-site; USD 120,000 - 180,000; Full time

Job summary

Jobtailor is seeking an experienced FP&A professional to translate finance needs into scalable Power BI solutions, connecting SAP data, building semantic models, and delivering self-service dashboards for planning, forecasting, and actuals analysis.

You will collaborate with FP&A, ZBB, and stakeholders to define KPIs, automate data pipelines, and leverage AI tools to speed insights and strengthen the reporting backbone.

Qualifications

• 6–8+ years of experience in FP&A, financial reporting, BI, data analytics, or systems enablement.
• Critical FP&A experience including P&L drivers, planning, forecasting, variance analysis, and monthly reporting.
• Hands-on Power BI programming, modeling, automation, and deployment.
• Experience linking Power BI to SAP finance data including extraction, transformation, reconciliation, and troubleshooting.
• Strong analytical, communication, and stakeholder-management skills.
• Preference for SAP S/4HANA Finance data experience (P&L structures, GL accounts, cost centers, profit centers).
• Experience with enterprise planning/data platforms like Anaplan or Databricks is a plus.

Responsibilities

• Partner with FP&A, ZBB, and stakeholders to define reporting needs, KPIs, P&L drivers, and decision requirements.
• Govern KPI definitions, reporting standards, master data, and metric hierarchies across FP&A and ZBB.
• Translate Finance requirements into scalable Power BI models, dashboards, and self-service views for planning, forecasting, actuals analysis, and ZBB reporting.
• Build and maintain Power BI semantic models, measures, dashboards, and visualizations using SAP as a primary data source.
• Design and automate data pipelines, transformations, mappings, reconciliations, and controls across SAP, Power BI, Excel, and related sources.
• Reduce manual work and create repeatable reporting processes to improve reporting speed, quality, and consistency.
• Support monthly performance routines with insights on actuals, forecast changes, variances, risks, opportunities, and business impact.
• Leverage Microsoft Copilot and related AI-enabled automation tools to improve reporting efficiency and accelerate insight generation.
• Establish and maintain the reporting, analytics, and systems backbone for ZBB.
• Transform finance and operational data into decision-ready insights for investment prioritization, resource allocation, benefits realization, and business performance improvement

Skills

Power BI Programming

SAP Data Engineering

Financial Reporting

Variance Analysis

ZBB Resource Allocation

Tools

Power BI

SAP

Excel

Anaplan

Databricks

Job description

Jobtailor is seeking an experienced FP&A professional to translate finance needs into scalable Power BI solutions, connecting SAP data, building semantic models, and delivering self-service dashboards for planning, forecasting, and actuals analysis.

You will collaborate with FP&A, ZBB, and stakeholders to define KPIs, automate data pipelines, and leverage AI tools to speed insights and strengthen the reporting backbone.