Sandoz is a integral 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.
Your Responsibilities Will Include 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 creation across Excel, SharePoint, Outlook and connected systems.
Include exception handling, monitoring, ownership, documentation and controlled change processes in automated solutions.
Replace repetitive manual activities with reliable solutions that are easy to maintain and support.
Monitor automated processes, investigate failures, resolve issues and keep user instructions and technical documentation current.
Assess automation opportunities based on business need, maintenance effort, access, security, privacy, compliance and expected benefit.
Use approved Microsoft Copilot and AI tools for analysis, formula or code support, testing and documentation when appropriate.
Primarily with the FP&A; community to build and maintain planning, forecasting, scenario analysis and performance reporting solutions.
Support forecasts, budgets and multi-year plans using agreed business assumptions, financial definitions and timelines.
Build and maintain financial models covering P&L;, balance sheet, cash flow, working capital and capital expenditure.
Analyze Net

📌 Senior Fp&A Modelling (España)
🏢 Sandoz
📍 España