Sandoz

8 окт

FP&A Modelling & Automation Specialist

ориентир по рынку

вакансия зп не указана

в среднем 282 148 ₽

мэтч

Загрузи резюме, чтобы видеть мэтчи с вакансиейЗагрузи резюме, чтобы видеть мэтч с вакой

подготовься к отклику

ai-инструменты

Чтобы адаптировать резюме под вакансию или составить сопроводительное письмо, загрузи резюме

Рекламный баннер: ОБЩЕСТВО С ОГРАНИЧЕННОЙ ОТВЕТСТВЕННОСТЬЮ "ЦЕНТР НАЦИОНАЛЬНЫХ ИНТЕЛЛЕКТУАЛЬНЫХ СИСТЕМ"

описание

Описания нет

задачи

We're Hiring!

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.

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.

Sandoz compensation is determined by job level, qualifications, niche skills, experience, and location within company salary ranges. Fully proficient and highly effective employees can expect a starting salary around market median, with those new to the level or with less functional depth at the lower end of the range and those with sustained superior or niche skills towards the higher end of the range. Internal equity and external market data inform our range placement. Annual salary reviews consider performance outcomes, market alignment, and business needs.

требования

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.

Ability To Influence Key Stakeholders, AI Driven, Compliance And Controls, Critical Thinking, Data Cleansing / Normalization, Data Visualization, Employee Engagement, Financial And Management, Giving And Receiving Feedback, Insight Generation, Interpersonal Savvy, Managing Ambiguity, Market Understanding, Planning & Analysis, Process Optimization, Rapid Problem Solving, Reporting, Understanding Value Drivers

условия

Generic and Biosimilar medicines are the backbone of the global medicines industry. Sandoz, a leader in this sector, provided more than 900 million patient treatments across 100+ countries in 2024 and while we are proud of this achievement, we have an ambition to do more!

With investments in new development capabilities, production sites, new acquisitions, and partnerships, we have the opportunity to shape the future of Sandoz and help more patients gain access to low-cost, high-quality medicines, sustainably.

Our momentum is powered by an open, collaborative culture driven by our talented and ambitious colleagues, who, in return for applying their skills experience an agile and collegiate environment with impactful, flexible-hybrid careers, where diversity is welcomed and where personal growth is supported!

Join us!

Commitment To Diversity & Inclusion

We are committed to building an outstanding, inclusive work environment and diverse teams representative of the patients and communities we serve.

Hiring decisions are only based on the qualification for the position, regardless of gender, ethnicity, religion, sexual orientation, age and disability.

The law provides for severely disabled / equal applicants the opportunity to involve the local representative body for disabled employees (SBV) in the application process. If you would like to request this, please let us know in advance as a note on your CV.

#Sandoz

навыки

fp&a financial modelling excel power query power bi power automate dax vba office scripts financial planning forecasting p&l cash flow data visualization copilot

Sandoz 6 вакансий

ещё вакансии Все 6 →

Если просят выйти из iCloud, прислать код из SMS, запустить или установить что-то, перевести деньги — не соглашайся: это мошенничество.

FP&A Modelling & Automation Specialist

подготовься к отклику

описание

задачи

требования

условия

навыки

похожие вакансии

похожие вакансии

FP&A Modelling & Automation Specialist

подготовься к отклику

описание

задачи

требования

условия

навыки

похожие вакансии

статьи для финансистов

похожие вакансии

статьи для финансистов