Commercial Finance Analyst

Ogilvy
Madrid
Workplace: OnsiteFull timeFunction: Finance & AccountingExperience: 1-2 yearsEducation: bachelorsSkills: ["Proactive","Data-driven decision making","Cross-functional communication","Adaptability","Teamwork"]

Support commercial pricing and scoping by building budgets, ensuring correct tariff application, and protecting contribution margins. Analyze client and departmental profitability to drive P&L impact through resource allocation improvements. Partner with Finance leadership on revenue forecasting, pipeline analysis, and strategic operating and margin plan presentations. Control budget deviations, identify risks, and improve efficiency by automating finance workflows with AI tools. Build and maintain KPI dashboards using Power BI/Tableau.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
Ogilvy
Ogilvy
1 day ago

Commercial Finance Analyst

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 10 hours agoStatus: Live

Job Summary

Support commercial pricing and scoping by building budgets, ensuring correct tariff application, and protecting contribution margins. Analyze client and departmental profitability to drive P&L impact through resource allocation improvements. Partner with Finance leadership on revenue forecasting, pipeline analysis, and strategic operating and margin plan presentations. Control budget deviations, identify risks, and improve efficiency by automating finance workflows with AI tools. Build and maintain KPI dashboards using Power BI/Tableau.
Location: Madrid
Workplace: Onsite
Employment Type: Full time
Job Function: Finance & Accounting
Seniority: Mid level

Key Responsibilities

  • •Develop pricing and scoping support through pricing models, budgeting, and correct tariff application to protect contribution margins.
  • •Analyze profitability across clients, departments, and profiles; propose action plans to improve P&L results through better resource allocation.
  • •Assist Finance leadership with revenue forecast, New Business pipeline analysis, and preparation of key financial presentations (Operating Plan, Margin Plan).
  • •Monitor and report budget deviations and ensure compliance with financial policies in commercial agreements to identify and mitigate risks proactively.
  • •Incorporate AI tools (Copilot, LLM, Power Automate) to automate finance processes and improve operational efficiency; create and maintain interactive KPI dashboards.

Key Requirements

  • •Degree/Licenciatura in Economics, Business Administration, or a related field.
  • •1-2 years of experience in financial analysis, pricing, or similar roles, ideally in multinational environments or agencies.
  • •High/bilingual English proficiency (required); other languages such as German or Mandarin are valued.
  • •Advanced Microsoft Excel skills (e.g., pivot tables, VLOOKUP, Power Query).
  • •Experience with data visualization tools such as Power BI or Tableau, plus interest in applying AI to financial processes.
Experience:1-2 yearsMultinationalAdvertising agency
Education:Bachelor's in Economía, Administración y Dirección de Empresas (or related)
Skills:ProactiveData-driven decision makingCross-functional communicationAdaptabilityTeamwork
Languages:English
Tech Stack:Microsoft ExcelVLOOKUPPower QueryPower BITableauCopilotLLMPower AutomateERPDashboardsData visualization

Company Brief

Ogilvy
Global advertising, marketing, and public relations agency offering brand strategy, creative services, digital marketing, media planning, and customer experience solutions for multinational clients across industries.
Industry: Advertising Media Groups
Company Size: Enterprise (1,001+ employees)
Growth: Established Company
Headquarters: New York, United States
Founded: 1948
WebsiteLinkedIn