Senior FP&A Modeling & Automation Architect

Sandoz; Madrid; On-site; EUR 70,000 - 100,000; Full time

Job summary

Sandoz is seeking an Senior FP&A Modelling & Automation Specialist in Madrid to design, build and maintain driver-based financial planning models and advanced dashboards. The role connects operational and commercial assumptions to P&L, balance sheet and cash flow outcomes across products, markets and planning periods.

You'll use advanced Excel modelling, Power Query, Power BI and Power Automate to deliver scalable planning tools, forecasts and multi-year plans with clear ownership and

Qualifications

• 5–7+ years of FP&A, financial modelling, planning systems, reporting, analytics or automation.
• Design and build driver-based long-term or detailed planning models in Excel from business requirements through implementation.
• Strong hands-on experience with Power Query, Power BI and Power Automate.
• Practical knowledge of P&L and cash-flow drivers, balance sheet and forecasting.
• Ability to document model architecture, calculations, dependencies and user instructions.

Responsibilities

• Design and build driver based long term and detailed financial planning models from initial business requirements through deployment, user handover and ongoing maintenance.
• Build integrated models that connect volume, price, Net Sales, COGS, gross profit, gross margin, operating expenses, working capital, capital expenditure and other agreed business drivers to financial outputs.
• Create dynamic and scalable excel models using structured tables, named formulas, dynamic arrays, advanced lookup and aggregation formulas, scenario controls and automated data flows.
• Design models that accommodate new products, markets, planning years and assumptions without extensive manual formula changes.
• Develop controlled adjustment and override mechanisms, including effective dates, prioritisation rules and a clear distinction between source data, assumptions, adjustments and calculated outputs.
• Create scenario and sensitivity analyses and explain how changes in business assumptions affect financial results.
• Perform model validation, reconciliation, sensitivity testing and error checking before release.
• Document model logic, assumptions, dependencies, controls, ownership and user instructions.

Skills

Excel modelling

Power Query

Power BI

Power Automate

VBA

AI tools

Forecasting

P&L knowledge

Education

Bachelor's or Master's in Finance

Economics or Business

Data Analytics background

Tools

Copilot

Office Scripts

Job description

Sandoz is seeking an Senior FP&A Modelling & Automation Specialist in Madrid to design, build and maintain driver-based financial planning models and advanced dashboards. The role connects operational and commercial assumptions to P&L, balance sheet and cash flow outcomes across products, markets and planning periods.

You'll use advanced Excel modelling, Power Query, Power BI and Power Automate to deliver scalable planning tools, forecasts and multi-year plans with clear ownership and