Description This is a registered role (e.g. certification employee or certified function): No Position Purpose: Ensure the WME Finance team have the data they need, when they need it, and can present robust numbers and insight to business partners in a timely and routine manner Ensure the Finance owned elements of the data model (within both legacy BD and 'The Bank's' enterprise IT networks) are robust, relevant, logical and do not degrade as applications from which Finance consume data evolve Support WME Finance to advance their reporting capability and control framework through data model administration and engagement with IT, Ops & CFT stakeholders PRIMARY RESPONSIBILITIES: WME Ledger maintenance at m/end, which involves: o Close the period in Opera GL o Maintain the Banks reporting hierarchies (GL, Cost Centre, Transit, Project) and other finance master reference data sets (TTCs) Data model administrator for the BD TM1 system, which involves: o Support the management reporting and planning processes o Daily monitoring and troubleshooting of data loads o Ad-hoc investigations / reporting on behalf of the business o Maintain user access model o Maintain data model documentation Data model administrator for Coupa and Opera GL systems, which involves: o Daily monitoring and troubleshooting of overnight integrations o Maintaining the data models to ensure smooth operation across Finance and the wider business o Assist with system upgrades and regression testing where required Data model administrator for the Power BI reporting models used by Finance, which involves: o Refreshing & re-publishing Power BI data models and dashboards o Daily monitoring and troubleshooting of overnight refreshes Opportunities to undertake TM1 development will be available over time AUTHORITIES, IMPACT, RISK: Key requirement to ensure changes in data control frameworks are implemented Help ensure accurate financial reporting KEY RELATIONSHIPS: WME Finance Systems Manager WME Financial Control & Performance Management teams Group Tax team Data Office WORKING CONDITIONS, COMPLIANCE: Tight deadlines and the ability to actively manage workload is a pre-requisite of the role Ability to demonstrate strong problem-solving skills and attention to detail Ability to use initiative and to pro-actively recognize and implement improvements EDUCATION AND/OR xp: Essential Qualifications & xp: Data Science Bachelors degree or equivalent, with xp applying data science principles and methodologies Advance MS Excel Skills Basic knowledge of financial management reporting and budgeting principles Beneficial Qualifications & xp; 1 to 2 years TM1 administration/end-user xp, being familiar with latest version of TM1 (Planning Analytics) Good understanding of approaches to system development life cycle, including change and configuration management SQL xp/ understanding Power BI xp/ understanding Financial Services xp COMPETENCIES: Behavioral: Critical thinking skills Strong problem-solving skills Well organized and have ability to meet exacting deadlines Good communication skills Ability to make decisions and use initiative Strong collaboration Excellent attention to detail Excellent analytical reporting skills Technical Ability to use financial reporting systems (ideally TM1 & Power BI) Strong Excel skills Skills
Read the overview of this opportunity to understand what skills, including and relevant soft skills and software package proficiencies, are required.
tm1
Accounting
DATA
Data modelling
data administrator
power bi
Job Title: Finance Systems Analyst - TM1
Location: London, UK
Job Type: Contract