Senior FP&A Modelling & Automation Specialist

Sandoz is a global market leader in Biosimilar and Generics medicine, a market leader in a sector is helped pioneer. Our Vision is to be the world’s leading and most valued generic and biosimilar medicine company.

We are pursuing access to medicine goals in two areas:

• ensuring responsible access to critical antibiotics which is seen as the backbone of modern medicine, and
• democratizing access to biologic therapies through healthy competition

The Senior FP&A Modelling & Automation Specialist designs, builds and maintains driver based financial planning models, management reports, dashboards and automated processes for the FP&A community and other business teams. The role develops scalable long term and detailed planning solutions that connect operational assumptions to P&L, balance sheet and cashflow outcomes across products, markets and planning periods.

The role requires hands on expertise in advanced excel modelling, Power Query, Power BI and Power Automate. The specialist builds models with dynamic formulas, structured inputs, scenario and sensitivity functionality, automated data consolidation, controls, documentation and clear ownership.

The role translates finance and business requirements into maintainable solutions, supports forecasts and multi year plans and uses approved Microsoft 365, Copilot and AI tools where appropriate.

• 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.

Data, Reporting & Analytics

• Understand business and finance questions and translate them into clear reporting requirements, measures and model specifications.
• Build, maintain and improve Power BI dashboards, Excel models, planning tools and recurring management reports.
• Use Power Query and approved company sources to combine, clean, transform and validate data for reporting and analysis.
• Build and maintain Power BI data models, relationships, DAX measures, refresh processes, reconciliation checks and documentation as required by the solution.
• Analyze trends, variances, scenarios and business drivers across products, pipeline stages, therapeutic areas, technologies, countries and other agreed dimensions.
• Create clear report views, definitions and checks so users can understand source data, assumptions and calculations.
• Apply consistent definitions and calculations across recurring reports and planning solutions.

Automation & Process Improvement

• Design, build and maintain automated processes using Power Automate, Power Query, VBA, Office Scripts and other approved tools.
• Automate recurring data preparation, validation, approvals, notifications, file handling and report…