Find a job 
Featured Companies 
Featured Universities 
For Companies At a Glance
- Tasks: Create impactful reports using SQL Server, Power BI, and Excel.
- Company: Join a dynamic team focused on delivering top-notch Management Information.
- Benefits: Enjoy flexible work options and opportunities for professional growth.
- Why this job: Be part of innovative projects that shape client solutions and enhance your data skills.
- Qualifications: Advanced Excel and Power BI skills required; SQL knowledge is a must.
- Other info: Experience with investment instruments and data governance is a plus.
The predicted salary is between 36000 - 60000 £ per year.
-
Leveraging SQL Server data-hub to create reports through Power BI and Excel (using Power Query)
-
Assist with various Change and Onboarding projects, focusing on the production and delivery of Management Information in an automated environment
-
Providing solutions to meet the ever evolving client requirements around MI
-
Preparation of monthly, quarterly MI reporting and Annual reporting for all clients including head office reporting
-
Preparation of the Performance Reporting
-
Advanced Excel skills
-
Strong knowledge of Power BI (paginated reporting a bonus)
-
Strong SQL – SSRS
-
Experience of improving MI processes
-
Strong understanding of investment instruments across multiple asset classes (especially Fixed Income)
-
Strong understanding of data management best practice, data governance and quality assurance
-
Focus on emerging risks, how to identify and mitigate these
-
Language M experience (nice to have).
BI Data Reporting Analyst employer: Investigo Limited
Contact Detail:
Investigo Limited Recruiting Team
StudySmarter Expert Advice 🤫
We think this is how you could land BI Data Reporting Analyst
✨Tip Number 1
Familiarize yourself with the latest features of Power BI and Excel, especially Power Query. This will not only enhance your reporting skills but also show us that you're proactive in keeping up with industry tools.
✨Tip Number 2
Brush up on your SQL skills, particularly with SQL Server Reporting Services (SSRS). Being able to demonstrate your ability to create efficient queries will set you apart from other candidates.
✨Tip Number 3
Gain a solid understanding of investment instruments, especially Fixed Income. This knowledge will help you provide better insights and solutions tailored to our clients' needs.
✨Tip Number 4
Stay updated on data management best practices and governance. Showing us that you can identify and mitigate emerging risks will highlight your strategic thinking and problem-solving abilities.
We think you need these skills to ace BI Data Reporting Analyst
Some tips for your application 🫡
Highlight Relevant Skills: Make sure to emphasize your advanced Excel skills, strong knowledge of Power BI, and SQL expertise in your CV and cover letter. Tailor your application to showcase how your experience aligns with the job requirements.
Showcase Reporting Experience: Detail your experience with management information reporting, especially any work related to monthly, quarterly, or annual reports. Provide specific examples of how you've contributed to improving MI processes.
Demonstrate Understanding of Investment Instruments: Include any relevant experience or knowledge you have regarding investment instruments, particularly in Fixed Income. This will help illustrate your understanding of the financial context in which you'll be working.
Focus on Data Management Practices: Discuss your familiarity with data governance, quality assurance, and best practices in data management. Highlight any specific projects where you identified and mitigated emerging risks.
How to prepare for a job interview at Investigo Limited
✨Showcase Your SQL and Power BI Skills
Be prepared to discuss your experience with SQL Server and Power BI in detail. Bring examples of reports you've created and be ready to explain your thought process and the challenges you faced.
✨Demonstrate Your Understanding of MI Reporting
Highlight your experience with Management Information reporting. Discuss how you've automated processes in the past and any specific tools or methodologies you've used to improve MI processes.
✨Discuss Your Knowledge of Investment Instruments
Since the role requires a strong understanding of investment instruments, especially Fixed Income, be ready to talk about your knowledge in this area. Prepare to give examples of how this knowledge has influenced your reporting or analysis.
✨Prepare for Questions on Data Governance
Expect questions related to data management best practices, data governance, and quality assurance. Be ready to share your experiences in these areas and how you've ensured data integrity in your previous roles.
