Finance Systems Analyst - TM1

Description

This is a registered role (eg 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 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

• tm1
• Accounting
• DATA
• Data modelling
• data administrator
• power bi

Job Title: Finance Systems Analyst - TM1

Location: London, UK

Job Type: Contract

Trading as TEKsystems. Allegis Group Limited, Bracknell, RG12 1RT, United Kingdom. No 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. If you apply, your personal data will be processed as described in the Allegis Group Online Privacy Notice available at our website.

To access our Online Privacy Notice, which explains what information we may collect, use, share, and store about you, and describes your rights and choices about this, please go our website.

We are part of a global network of companies and as a result, the personal data you provide will be shared within Allegis Group and transferred and processed outside the UK, Switzerland and European Economic Area subject to the protections described in the Allegis Group Online Privacy Notice. We store personal data in the UK, EEA, Switzerland and the USA. If you would like to exercise your privacy rights, please visit the "Contacting Us" section of our Online Privacy Notice on our website for details on how to contact us. To protect your privacy and security, we may take steps to verify your identity, such as a password and user ID if there is an account associated with your request, or identifying information such as your address or date of birth, before proceeding with your request. commitments under the UK Data Protection Act, EU-U.S. Privacy Shield or the Swiss-U.S. Privacy Shield.