Senior Financial Analyst: Forecasting, Automation & Insights

Fresenius; Lake Zurich (IL); Hybrid; USD 88,000 - 99,000; Full time

Benefits offered by this job

401(k) plan

Health benefits

Paid vacation & holidays

Wellness program

Job summary

Fresenius Kabi in Lake Zurich, IL is seeking a Senior Financial Analyst to support and analyze financials in sales and other business areas. You will help manage forecasting processes and present results to upper management and Corporate Germany, using SAP and SQL to automate reporting.

The role emphasizes advanced analytics, data automation, and visualizations, with on-site work three days a week and a comprehensive benefits package. Strong English communication is essential.

Qualifications

• Bachelor’s degree in accounting, finance or relevant working experience. MBA, master’s degree in data science, and/or CPA a plus.
• 5+ years of accounting and financial analysis experience.
• Strong Microsoft Excel skills (PivotTables, Macros).
• Execute analysis using SQL, R / Python, or other statistical programming languages and BI tools (e.g., Power BI, Tableau, Qlik Sense) preferred.
• Knowledge of ERP systems; SAP & TM1 Cognos preferred.
• High attention to detail and strong data science skills.
• Ability to communicate complex analysis and conclusions/recommendations in a concise, easily understandable manner.
• The Company’s primary business language is English. The successful candidate must be able to effectively speak, read, write, and understand English to perform the essential functions of the position, including independently understanding policies, procedures, training materials, and workplace communications written in English due to our heavily regulated work environment.

Responsibilities

• Lead in preparation of Annual Budget, Long Range Plan, and quarterly Forecasts for cost centers and revenue as well as help prepare related management presentations.
• Prepare, analyze, report, and reconcile monthly actual results compared to budget, forecasts, and prior year for North America. Execute analytics projects using Python, Power Query, R, or SQL to prepare and/or merge internal data assets and perform advanced analysis.
• Collect and analyze business functions and product lines’ monthly and/or weekly Sales reports and ensure for accuracy.
• Contribute to multiple internal data initiatives, including but not limited to new tool development, automation, simulation, data integration and visualization dashboards.
• Manage the relationship with department managers and communicating financial results.
• Assist in reviewing costs and performing cost/benefit analyses related to proposed projects/programs in order to improve operational and financial effectiveness of the company.
• Prepare and analyze financial actuals, budget, forecasts, and variance reports on a monthly, quarterly, and annual basis. Develop reports for forecasting/trending and results analysis. Standardize reporting using Power BI, implementing new technical capabilities.
• Assist with month-end close activities and reporting.
• Responsible for loading and maintaining portions of P20, TM1, BCS, and FKGAN for actual results, as well as quarterly forecasts and annual budgets.
• Assist with coaching of Financial Development Program Associate.
• Lead efforts on ad hoc and special projects within finance team.

Skills

Advanced Excel

SQL

Python

R

Power BI

Tableau

Qlik Sense

SAP

TM1 Cognos

Education

Bachelor’s in Accounting/Finance

MBA

CPA

Data Science Master

Tools

SAP TM1 Cognos

Power Query

Job description

Fresenius Kabi in Lake Zurich, IL is seeking a Senior Financial Analyst to support and analyze financials in sales and other business areas. You will help manage forecasting processes and present results to upper management and Corporate Germany, using SAP and SQL to automate reporting.

The role emphasizes advanced analytics, data automation, and visualizations, with on-site work three days a week and a comprehensive benefits package. Strong English communication is essential.