* The Reporting & Systems Analyst is responsible for
* overall Management Information reporting.
* key reports to inform colleagues and stakeholders of activities within their business, and portfolios, to make meaningful and cost effective decisions.
* using wider IT skills to build, maintain and improve these reports, extracting data from TEM UK company systems.
* working as part of the wider Back Office team, assisting colleagues to simplify data entry into the SAP system
* ensuring rebate agreements are correctly set up and administered, to satisfy customer needs and expectations, while ensuring the amounts paid out as a rebate are correct and in line with TEM legal agreements.
Activities The regular activities of the Reporting & Systems Analyst include
* Maintain, build and develop reporting solutions to allow the business to achieve efficiencies
* Promote and provide a high level and quality reporting service
* Ensure that all MI reports are produced and delivered to stakeholders accurately and on time
* Work to ensure reporting remains stable and any issues are investigated and resolved
* Provide technical support to the stakeholders on their reporting questions/issues
* Analyse and work with the business stakeholders to understand their needs and requirements and prioritise accordingly.
* Manage ongoing maintenance of existing reporting, as well as the provision of new reports
* Work closely with colleagues to improve working procedures to ensure accuracy and timeliness of reports
* Develop and maintain good working relationships with internal and external stakeholders
* Deliver enhancements/bug fixes to existing reporting
* Design and develop new solutions for new reporting
* Understand business problems/goals and design and implement appropriate models
* Independently design and/or code and lead others in the development of cost-effective application and program solutions
* Lead or act as a technical contributor in the design of new applications or enhancements including integration of purchased solutions
* Communicate well to ensure stakeholders are fully informed and aware of progress, as well as being able to provide advice on best practice
* Ensure good standards, working practices and governance is in place to provide a consistent approach to reporting delivery going forward
* Work with the wider Lubricants teams to manage and action any ad hoc requests from internal and external stakeholders
* Understand root causes of issues and helps to design and implement robust solutions
* The Reporting & Systems Analyst jointly manages the Lubes rebates process, to ensure that correct values are accrued and paid out in accordance with legal contracts, and to release over accrued funds back into the TEMUK result at the end of the rebate period.
Local rebate activities include
* Creating rebates in SAP, to match the requirements defined in the legal contracts
* Releasing accrued rebates to customers, at the times specified in the legal contracts
* Liaising with the Finance team to make refunds where needed and agreed.
* Closing down rebates at the end of the rebate period, and releasing over accrued funds, or unpaid monies, back into the TEM UK result Investigating and correcting any discrepancies between the accrued values, and amount to be paid out as a rebate.
Advanced Microsoft Excel experience, including complex formulae and VBA.
* Power BI
* SQL
* SAP scripting
* Experience of Business Objects with SAP
* Experience with large scale data manipulation and analysis
* Experience in application program development
* High level of accuracy and good attention to detail
* Excellent written and verbal communication skills
* Ability to manage own workload and adhere to strict deadlines
* Ability to work alone and with stakeholders
* Ability to work under pressure and multitask