SCUK Pricing and Commissions MI Manager
Santander
£45,000-£50,000
Surrey, Redhill
Marketing
Role
- Running commercial and financial month end MI on Working Days 1-3 using database tools such as MS Access and Business Objects to meet stakeholder deadlines and requirements
- Ensuring accuracy of reporting output, investigating and resolving any differences as required
- Interrogating data using a variety of sources to understand any anomalies or resolve queries as required
- Ensuring reporting processes are well documented and up to date in line with governance
- Providing support in developing Excel based tools such as pricing models and customer agreement calculators using advanced formulae, pivot tables and VBA as required
- Edit, amend and create queries and reports to be able to accommodate changing reporting requirements as requested by stakeholders
- Ensuring testing has been fully completed and output is as expected
- Using data to assist with analysis of pricing changes and identification of trends in dealer behaviour
- Being the subject matter expert on data within the team, helping other team members improve reports and analysis
- Helping other team members improve reports and analysis
- Migrating existing month end reporting processes from Access to SAS or Business Objects as appropriate to accommodate new back-end systems
- Build, develop and automate dealer commission reports using tools such as Excel, VBA, Business Objects, Power BI, MS Access and SAS as appropriate
- Ensuring EUC tools and reports are adhering to correct governance and regulation including those relating to data protection, record retention, documentation, access and controls
- Adhering to our commitment to Consumer Duty ensuring we put our customers' needs first and set higher and clearer standards of consumer protection