Description
This is a registered role ( 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:
oClose the period in Opera GL
oMaintain 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:
oSupport the management reporting and planning processes
oDaily monitoring and troubleshooting of data loads
oAd-hoc investigations / reporting on behalf of the business
oMaintain user access model
oMaintain data model documentation
•Data model administrator for Coupa and Opera GL systems, which involves:
oDaily monitoring and troubleshooting of overnight integrations
oMaintaining the data models to ensure smooth operation across Finance and the wider business
oAssist with system upgrades and regression testing where required
•Data model administrator for the Power BI reporting models used by Finance, which involves:
oRefreshing & re-publishing Power BI data models and dashboards
oDaily 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 Bachelor’s 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
1. tm1
2. Accounting
3. DATA
4. Data modelling
5. data administrator
6. power bi
Job Title: Finance Systems Analyst - TM1
Location: London, UK
Job Type: Contract
Trading as TEKsystems. Allegis Group Limited, Maxis 2, Western Road, Bracknell, RG12 1RT, United Kingdom. No. 2876353. Allegis Group Limited operates as an Employment Business and Employment Agency as set out in the Conduct of Employment Agencies and Employment Businesses Regulations 2003. TEKsystems is a company within the Allegis Group network of companies (collectively referred to as "Allegis Group"). Aerotek, Aston Carter, EASi, Talentis Solutions, TEKsystems, Stamford Consultants and The Stamford Group are Allegis Group brands.