At a Glance
- Tasks: Support finance teams with data management and reporting using SQL and Power BI.
- Company: Join a global network of innovative companies within Allegis Group.
- Benefits: Gain valuable experience in finance systems and data analysis.
- Other info: Dynamic contract role with opportunities for professional growth.
- Why this job: Make an impact by ensuring accurate financial reporting and enhancing data capabilities.
- Qualifications: Experience with SQL, Power BI, and financial reporting principles required.
The predicted salary is between 40000 - 50000 € 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:
- Bachelors 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.
Finance Systems Analyst - SQL 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 Finance Systems Analyst role provides ample opportunities for professional growth, with access to cutting-edge technologies and a supportive team environment in the heart of the financial services sector. Join us to be part of a global network where your contributions are valued, and you can make a meaningful impact on our finance operations.
StudySmarter Expert Advice🤫
We think this is how you could land Finance Systems Analyst - SQL in City of London
✨Tip Number 1
Network like a pro! Reach out to folks in the finance and data 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 SQL queries, Power BI dashboards, or any relevant projects. This gives potential employers a taste of what you can do and sets 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 TM1, data modelling, and how you've tackled challenges in past roles. Confidence is key!
✨Tip Number 4
Don't forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive about their job search.
We think you need these skills to ace Finance Systems Analyst - SQL in City of London
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Finance Systems Analyst role. Highlight your SQL, TM1, and Power BI experience, and don’t forget to showcase your strong Excel skills. We want to see how your background fits with 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 skills can help us at StudySmarter. Keep it concise but impactful – we love a good story!
Showcase Relevant Experience:When filling out your application, make sure to highlight any relevant experience you have in financial reporting and data model administration. We’re keen on seeing how you’ve tackled similar challenges in the past!
Apply Through Our Website:Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for the role. Plus, it’s super easy – just a few clicks and you’re done!
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 financial reporting and data integrity.
✨Showcase Your SQL Skills
Since SQL experience is key for this role, prepare to demonstrate your understanding of SQL queries. You might be asked to solve a problem or explain how you would retrieve specific data, so practice some common scenarios beforehand.
✨Understand Financial Reporting Principles
Familiarise yourself with financial management reporting and budgeting principles. Be prepared to discuss how you’ve applied these principles in previous roles and how they relate to the responsibilities of the Finance Systems Analyst position.
✨Engage with Stakeholders
This role involves collaboration with various teams, so think about examples where you've successfully engaged with stakeholders. Be ready to share how you’ve communicated complex data insights to non-technical partners in a clear and effective manner.
