Senior FP&A Modelling & Automation Specialist

Job Description Summary

We're Hiring!

Job Description

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

Th e 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

Planning Model Design & Development

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

Financial Planning & Analysis

• •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 Sales, volume, price, COGS, gross profit, gross margin, development costs and other agreed financial measures.
• •Connect operational and commercial assumptions to financial results and explain changes, dependencies, limitations and data gaps.
• •Support portfolio and performance reporting across generics, biosimilars and mature brands when required.
• •Separate facts, assumptions and recommendations in analyses and management outputs.

Controls, Governance & Documentation

• •Agree and maintain model and reporting definitions, calculations, checks, assumptions, ownership and approval requirements with stakeholders.
• •Include appropriate data quality, reconciliation and reasonableness checks in models, dashboards and automated processes.
• •Apply clear version control, change documentation and approval processes to planning models and reporting solutions.
• •Create standard templates, reusable components and clear user guidance.
• •Work with IT, data owners and control teams on access, information security, privacy and compliance requirements.
• •Reduce dependency on undocumented logic, manual workarounds and single-person knowledge.

Stakeholder Support

• •Work with FP&A, Corporate Strategy, Business Development, Commercial, Manufacturing, Supply Chain, IT and other teams as required.
• •Gather requirements, challenge unclear assumptions, agree priorities and maintain a transparent work plan.
• •Explain financial, analytical and technical topics clearly to finance and non-technical stakeholders.
• •Provide tool guidance, quality reviews, knowledge transfer and user support.
• •Promote consistent planning, reporting and automation practices across supported teams.

What you'll bring to the role

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