Campaigns Management Reporting Supervisor

at  Ford Motor Company

CAMPAIGNS MANAGEMENT IS A LARGE TEAM WITHIN THE EUROPEAN REVENUE MANAGEMENT TEAM AND ITS MAIN OBJECTIVE IS TO SET UP AND MANAGE INCENTIVE PROGRAMS THAT SUPPORT VEHICLE SALES THROUGH FORD’S EUROPEAN DEALER NETWORK AND THROUGH THE INTERNET. THE TEAM ALSO MANAGES AND KEEPS DEVELOPING ITS OWN SYSTEM: MPS2. CAMPAIGNS MANAGEMENT WORKS CLOSELY WITH FORD’S NATIONAL SALES COMPANIES AND MANY CENTRAL FORD EUROPE TEAMS. THE REPORTING TEAM INTERACTS DAILY WITH THE BROADER CAMPAIGNS MANAGEMENT TEAM, WHICH CONSISTS OF TWO LARGE OPERATIONS TEAMS, A BUSINESS SUPPORT & DEVELOPMENT TEAM AND A TEAM MANAGING INCENTIVES IN THE DIGITAL MARKETPLACE (E-COMMERCE). THE REPORTING SUPERVISOR REPORTS TO THE HEAD OF CAMPAIGNS MANAGEMENT, EUROPE.

• BA/MA degree, preferably in Marketing, Economics, Mathematics or IT
• At least 3-4 years experience in a reporting team or reporting role or relevant CMT reporting experience
• Excellent analytical skills and thinking, ability to proactively progress an issue, develop options and recommendations and see through to resolution
• Skills in report creation based on a set of criteria
• In-depth SQL and Visual Basic Programming knowledge, Python is an advantage
• Accuracy with the ability to comply with deadlines
• Work independently with limited supervision
• Fluency in English
  Working hours: 40 hours / week

Reporting, Analysis and Efficiency Optimisation Actions

• Maintain existing reports (daily reports, Monthly Market Decks, log and archive tool) to support the daily work of the Operations Team
• Develop new reports (automated and self-service reports upon request) to support business needs
• Seek opportunities to reporting system and process enhancements
• Analyse variable marketing programs’ effectiveness based on financial data, sales volumes and market share. Review data, processes and incentive structures to identify opportunities for re-engineering/complexity reduction
• Support delivery of the efficiency optimisation projects with new reports
• Support reviews and meetings with NSCs and Ford of Europe management
• Ensure report quality: peer reviews and control checklist, where necessary
• Ensure CMT reporting compliance with audit requirements

Supervisor role

• Supervise the daily work of the reporting specialist
• Manage team’s personnel related tasks (Objective setting, Development Plan, etc.)
• Train and mentor new team members/new users of MPS2 system relating reporting

Relationship and interface

• The role provides an insight into senior level decision making and long term strategic planning

• Supervise the daily work of the reporting specialist
• Manage team’s personnel related tasks (Objective setting, Development Plan, etc.)
• Train and mentor new team members/new users of MPS2 system relating reportin