Senior FP&A Modelling & Automation Architect

Sandoz Iberia; Madrid; Hybrid; EUR 70,000 - 95,000; Full time

Job summary

Sandoz Iberia is seeking an experienced Senior FP&A Modelling & Automation Specialist to design, build, and maintain driver-based planning models and reporting tools in Excel and Power BI. You will connect operational assumptions to P&L, balance sheet, and cash flow across products and markets in a detailed, scalable way.

You will use Power Query, Power BI, Power Automate, and AI-assisted tools to automate data flows, validate results, and deliver clear management reports and dashboards for the

Qualifications

• Bachelor's or Master's degree in Finance, Economics, Business, Engineering, Information Systems, Data Analytics or a related field.
• 5-7+ years of experience in FP&A, financial modelling, planning systems, reporting, analytics or automation.
• Demonstrated experience designing and building driver-based long-term or detailed planning models in Excel from business requirements through implementation and handover.
• Advanced hands on Excel modelling skills, including structured tables, dynamic arrays, XLOOKUP, SUMIFS, LET, LAMBDA, FILTER, UNIQUE, SORT, error handling, data validation, PivotTables, slicers and model performance optimization.
• Strong hands on experience with Power Query, Power BI and Power Automate.
• Practical experience with Power BI data modelling and DAX, and with building controlled automated workflows.
• Strong understanding of P&L and cash-flow drivers, with working knowledge of balance sheet, working capital, capital expenditure, forecasting and multi-year planning.
• Ability to reconcile model outputs to source data, identify inconsistencies and explain the financial impact of assumptions and changes.
• Experience documenting model architecture, calculations, dependencies, controls, ownership and user instructions.
• Ability to turn business requirements into practical solutions that are scalable, controlled and maintainable.
• Experience with VBA, Office Scripts and approved Copilot or AI tools is preferred.
• Experience in pharma, healthcare or another regulated industry is preferred.
• Ability to communicate clearly with FP&A and other stakeholder groups and manage several priorities with agreed timelines.

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

Financial modelling

Power BI

Power Query

Power Automate

Scenario analysis

Sensitivity analysis

DAX measures

Education

Bachelor's or master's degree in Finance, Economics, Business, Engineering, Information Systems, Data Analytics or related field

Tools

VBA

Office Scripts

Copilot / AI tools

Job description

Sandoz Iberia is seeking an experienced Senior FP&A Modelling & Automation Specialist to design, build, and maintain driver-based planning models and reporting tools in Excel and Power BI. You will connect operational assumptions to P&L, balance sheet, and cash flow across products and markets in a detailed, scalable way.

You will use Power Query, Power BI, Power Automate, and AI-assisted tools to automate data flows, validate results, and deliver clear management reports and dashboards for the