Commercial Finance Analyst
Core
Strategic analytical partner translating regional financial data into actionable commercial insights and modernizing reporting capabilities for a portfolio of 15+ legal entities.
Role type
Senior Commercial Finance Analyst (Financial Transformation & Reporting)
Builds
Automated regional performance reporting packages, commission/rebate models, and financial planning frameworks.
Domain
Advertising technology / Media buying / DACH region
Deliverable
production ML models | dashboards & analysis | client delivery
Required skills
Advanced Excel (Power Query, dynamic arrays, PivotTables), Financial modeling, ERP systems (Microsoft Dynamics 365), Financial planning tools (Planful, Adaptive), Variance analysis, Budget vs. Actual analysis, P&L and Balance Sheet review, Commission calculation, Rebate operations, Data validation, Scenario modeling, Stakeholder management
Preferred skills
AI/RPA tool implementation, Python or SQL scripting, System migration leadership, International matrix business experience, Generative AI applications
Technologies
Microsoft Excel, Microsoft Dynamics 365, Planful, Adaptive, Python, SQL
Responsibilities
Orchestrate automation and standardization of regional performance reporting using modern modeling techniques and AI; Re-architect legacy Excel models into scalable, automated reporting solutions; Manage and deliver monthly regional performance reporting packages and KPI dashboards; Prepare detailed Budget vs. Forecast vs. Actual variance analyses and management commentary; Run structured analytical reviews of P&Ls and Balance Sheets during monthly close; Direct regional sales commission calculation, data validation, accrual support, and agency rebate reconciliations; Provide high-impact analytical support to Managing Directors and Sales Leaders to optimize pricing and profitability.
Seniority
Mid-Senior, hands-on IC