At a Glance
- Tasks: Design and maintain financial reports using Oracle Analytics Cloud and support data analysis.
- Company: Leading financial services firm in the heart of London with a hybrid work model.
- Benefits: Competitive salary of up to £80,000, flexible working, and opportunities for professional growth.
- Why this job: Join a dynamic team and make an impact through data-driven insights in finance.
- Qualifications: Experience with Oracle Fusion ERP and strong SQL skills are essential.
- Other info: Exciting opportunity for career advancement in a supportive environment.
The predicted salary is between 48000 - 64000 £ per year.
A highly successful financial services business based in the City are looking for a technically capable Reporting Analyst to join them on a 12 month FTC.
Key Responsibilities
- Finance Systems Design; build, and maintain financial and operational reports using Oracle Analytics Cloud (OAC), Oracle BI, and Smart View, based on user requirements.
- Deliver ad-hoc reporting and analysis to support the Finance Team's decision‐making needs.
- Maintain and update reporting tables, views, and replications within the Autonomous Data Warehouse (ADW) to ensure data accuracy and availability.
- Perform detailed data analysis to identify trends, validate data integrity, and support business insights.
- Lead and participate in ad‐hoc data cleansing and data‐fixing initiatives, such as supplier merges, multicurrency balance corrections, and prepayment adjustments.
- Support the development and enhancement of Finance systems, contributing to testing, design input, and continuous improvement initiatives.
- Provide reporting and system support via the Finance Helpdesk, troubleshooting user issues and resolving reporting queries in a timely manner.
Candidate Profile
- The ideal candidate will have previous experience of supporting the maintenance of accounting systems.
- Strong knowledge of Oracle Fusion ERP (Finance modules) is essential.
- Advanced Smart View skills, especially for financial reporting, variance analysis, budgeting, and forecasting templates is also required.
- Solid SQL skills for querying, analysing, and troubleshooting data within Fusion, ADW or similar data databases/warehouses.
- Strong proficiency in Oracle Analytics Cloud (OAC) for report building, dashboards, and data modelling.
- Hands‐on experience with Oracle BI / OTBI including subject area analysis and custom report creation.
- Understanding of ADW tables, views, and data structures.
- Ability to analyse large and complex datasets, identify patterns, and produce insights.
The salary on offer for this role is up to £80,000 pro rata and hybrid working is offered.
Reporting Analyst – Data - City of London – Hybrid – 12 month FTC - £80,000 employer: Ashdown Group
Contact Detail:
Ashdown Group Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land Reporting Analyst – Data - City of London – Hybrid – 12 month FTC - £80,000
✨Tip Number 1
Network like a pro! Reach out to your connections in the finance and data sectors. Attend industry events or webinars, and don’t be shy about introducing yourself. You never know who might have the inside scoop on job openings!
✨Tip Number 2
Show off your skills! Create a portfolio showcasing your reporting and data analysis projects. Use platforms like GitHub or even a personal website to display your work with Oracle Analytics Cloud and SQL. This gives potential employers a taste of what you can do.
✨Tip Number 3
Prepare for interviews by practising common questions related to financial reporting and data analysis. Brush up on your knowledge of Oracle Fusion ERP and Smart View. We recommend doing mock interviews with friends or using online resources to boost your confidence.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets noticed. Plus, we love seeing candidates who are proactive and engaged. So, get your application in and let’s get you that Reporting Analyst role!
We think you need these skills to ace Reporting Analyst – Data - City of London – Hybrid – 12 month FTC - £80,000
Some tips for your application 🫡
Tailor Your CV: Make sure your CV speaks directly to the job description. Highlight your experience with Oracle Analytics Cloud and SQL, as these are key for the Reporting Analyst role. 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 the perfect fit for this role. Mention specific projects where you've used financial reporting tools or tackled data analysis challenges. Let us know your passion for finance systems!
Showcase Your Technical Skills: Since this role requires strong technical capabilities, don’t shy away from listing your skills in Oracle BI, Smart View, and data analysis. We love seeing concrete examples of how you've used these tools in past roles, so be specific!
Apply Through Our Website: We encourage you to apply through our website for a smoother application process. It helps us keep track of your application and ensures you don't miss out on any important updates. Plus, we love seeing applications come in directly!
How to prepare for a job interview at Ashdown Group
✨Know Your Tools Inside Out
Make sure you’re well-versed in Oracle Analytics Cloud, Smart View, and SQL. Brush up on your skills and be ready to discuss how you've used these tools in past roles. Being able to demonstrate your technical capabilities will show that you're the right fit for the Reporting Analyst position.
✨Prepare for Scenario-Based Questions
Expect questions that ask you to solve real-world problems related to data analysis and reporting. Think of examples from your previous experience where you’ve had to troubleshoot issues or deliver ad-hoc reports. This will help you showcase your analytical skills and problem-solving abilities.
✨Understand the Business Context
Research the financial services business and understand their operations. Familiarise yourself with common challenges they face in reporting and data management. This knowledge will allow you to tailor your answers and demonstrate how you can contribute to their specific needs.
✨Ask Insightful Questions
Prepare thoughtful questions about the team, the tools they use, and their reporting processes. This not only shows your interest in the role but also gives you a chance to assess if the company is the right fit for you. It’s a two-way street, after all!