At a Glance
- Tasks: Support finance teams with data management and reporting to drive business insights.
- Company: Join a global leader in financial services with a focus on innovation.
- Benefits: Competitive pay, flexible working options, and opportunities for professional growth.
- Other info: Dynamic role with potential for career advancement in a collaborative environment.
- Why this job: Make an impact by ensuring accurate financial reporting and enhancing data capabilities.
- Qualifications: Experience in data administration, strong Excel skills, and familiarity with TM1 and Power BI.
The predicted salary is between 35000 - 45000 β¬ per year.
This is a registered role (e.g. certification employee or certified function): No
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.
WME Ledger maintenance at month end, which involves:
- 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:
- Support the management reporting and planning processes.
- Daily monitoring and troubleshooting of data loads.
- Ad-hoc investigations / reporting on behalf of the business.
- Maintain data model documentation.
Data model administrator for Coupa and Opera GL systems, which involves:
- Daily monitoring and troubleshooting of overnight integrations.
- Maintaining the data models to ensure smooth operation across Finance and the wider business.
- Assist with system upgrades and regression testing where required.
Data model administrator for the Power BI reporting models used by Finance, which involves:
- Refreshing & re-publishing Power BI data models and dashboards.
- Daily monitoring and troubleshooting of overnight refreshes.
AUTHORITIES, IMPACT, RISK:
- Key requirement to ensure changes in data control frameworks are implemented.
- Help ensure accurate financial reporting.
Qualifications:
- Data Science Bachelor's degree or equivalent, with experience applying data science principles and methodologies.
- Advanced MS Excel Skills.
- Basic knowledge of financial management reporting and budgeting principles.
- 1 to 2 years TM1 administration/end-user experience, being familiar with latest version of TM1 (Planning Analytics).
- Good understanding of approaches to system development life cycle, including change and configuration management.
- SQL experience/understanding.
- Power BI experience/understanding.
- Financial Services experience.
- Ability to use financial reporting systems (ideally TM1 & Power BI).
- Strong Excel skills.
- Accounting.
- Data modelling.
- Data administrator.
- Power BI.
IT Finance Systems Analyst in City of London employer: Teksystems
At TEKsystems, we pride ourselves on being an exceptional employer, offering a dynamic work culture that fosters collaboration and innovation. Our commitment to employee growth is evident through comprehensive training programmes and opportunities for advancement within our global network. Located in a vibrant area, we provide a supportive environment where you can thrive as an IT Finance Systems Analyst, contributing to meaningful projects while enjoying a healthy work-life balance.
StudySmarter Expert Adviceπ€«
We think this is how you could land IT Finance Systems Analyst in City of London
β¨Tip Number 1
Network like a pro! Reach out to folks in the finance and IT sectors on LinkedIn or at industry events. You never know who might have the inside scoop on job openings or can put in a good word for you.
β¨Tip Number 2
Show off your skills! Create a portfolio showcasing your data modelling projects, especially with TM1 and Power BI. This will give potential employers a taste of what you can do and set you apart from the crowd.
β¨Tip Number 3
Prepare for interviews by brushing up on common finance systems questions. Be ready to discuss your experience with SQL, Excel, and any troubleshooting you've done. Confidence is key, so practice makes perfect!
β¨Tip Number 4
Don't forget to apply through our website! We love seeing applications directly from candidates who are eager to join us. Plus, it gives you a better chance to stand out in the hiring process.
We think you need these skills to ace IT Finance Systems Analyst in City of London
Some tips for your application π«‘
Tailor Your CV:Make sure your CV is tailored to the IT Finance Systems Analyst role. Highlight your experience with data modelling, TM1 administration, and any relevant financial reporting systems like Power BI. We want to see how your skills match what we're looking for!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about this role and how your background in finance and data science makes you a perfect fit. We love seeing enthusiasm and a personal touch!
Showcase Your Technical Skills:Donβt forget to mention your advanced Excel skills and any SQL experience you have. Weβre looking for someone who can hit the ground running, so make sure we know about your technical prowess right from the start!
Apply Through Our Website:We encourage you to apply through our website for a smoother application process. It helps us keep everything organised and ensures your application gets the attention it deserves. Plus, itβs super easy!
How to prepare for a job interview at Teksystems
β¨Know Your Data Models
Make sure you brush up on your knowledge of data models, especially TM1 and Power BI. Be ready to discuss how you've used these tools in the past and how they can help improve reporting capabilities.
β¨Excel Skills on Point
Since advanced Excel skills are a must for this role, practice using functions, pivot tables, and data analysis techniques. Bring examples of how you've used Excel to solve problems or streamline processes in previous roles.
β¨Understand Financial Reporting
Familiarise yourself with financial management reporting and budgeting principles. Be prepared to explain how youβve contributed to accurate financial reporting in your past experiences.
β¨Engage with Stakeholders
This role involves collaboration with various teams. Think of examples where you've successfully engaged with stakeholders to gather requirements or troubleshoot issues. Show that you can communicate effectively across departments.