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 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:
- 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 employer: Teksystems
At TEKsystems, we pride ourselves on fostering a collaborative and innovative work culture that empowers our Finance Systems Analysts to thrive. Located in a dynamic environment, we offer competitive benefits, continuous professional development opportunities, and the chance to work with cutting-edge technologies like TM1 and Power BI, ensuring our employees are well-equipped to advance their careers while contributing to meaningful financial insights for our partners.
StudySmarter Expert Advice🤫
We think this is how you could land Finance Systems Analyst - SQL
✨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 data models you've worked on. 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, SQL, and data modelling. Practising your answers will help you feel more confident when it’s showtime!
✨Tip Number 4
Don’t forget to apply through our website! We’ve got loads of opportunities that might be perfect for you. Plus, applying directly shows your enthusiasm and commitment to joining our team.
We think you need these skills to ace Finance Systems Analyst - SQL
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 Inside Out
Make sure you’re familiar with the data models and reporting systems mentioned in the job description, especially TM1 and Power BI. Brush up on your SQL skills too, as they’ll likely come up during technical questions.
✨Showcase Your Problem-Solving Skills
Prepare examples of how you've tackled data issues or improved reporting processes in the past. Be ready to discuss specific challenges you faced and how you resolved them, as this will demonstrate your analytical abilities.
✨Understand the Business Context
Research the company’s financial operations and how the Finance Systems Analyst role fits into their overall strategy. This will help you answer questions more effectively and show that you’re genuinely interested in contributing to their success.
✨Practice Common Interview Questions
Anticipate questions related to financial reporting, data management, and system administration. Practising your responses will help you feel more confident and articulate during the interview.
