At a Glance
- Tasks: Lead the design and development of BI solutions, creating impactful reports and dashboards.
- Company: AFH Financial Group is a dynamic financial services firm focused on innovation and teamwork.
- Benefits: Enjoy flexible working, competitive holidays, hybrid options, and health perks like MediCash.
- Why this job: Join a collaborative team, mentor others, and make a real impact with your insights.
- Qualifications: Experience in BI management, SQL scripting, and Power BI is essential; Agile methodology knowledge is a plus.
- Other info: Celebrate your achievements with annual parties and enjoy shopping discounts!
The predicted salary is between 43200 - 72000 £ per year.
AFH Financial Group are seeking a Lead BI Analyst to join our established BI. Your role will be to support our BI Team in creating several key reports as well as ad-hoc analysis for our Board, which will also involve supporting the project end-to-end as well as the maintenance of these reports and dashboards.
The Role
As the Lead BI Analyst, you will work with our suite of reporting tool kits, including Power BI for the creation of reports and dashboards for the Groups stakeholders. You will work collaboratively with our Technical team to ensure that requirements delivered via robust solutions. Your role will be to produce quality reporting and dashboards in line with the Stakeholders requirements, as well as to provide ad-hoc analysis where required and any support they require in answering questions or queries with these. Your role will also include oversight of other technical members and help in running sprints and making sure projects are delivered within the deadlines. This role will report to Head of Data & BI.
The key responsibilities of this job include:
- Lead the design, development, and maintenance of scalable and efficient BI solutions and dashboards.
- Manage and mentor Senior BI and BI Analysts and pinpointing areas for improvement within the team.
- Deep dive data analysis, finding and presenting deeper and more layered insights.
- Analyse complex data to determine correlation and data integrity issues.
- Work closely with Stakeholders on reporting requirements ensuring the solution is delivered to spec.
- Manage and support queries from Stakeholders and SMEs for any amendments or issues relating to this reporting.
- To be pro-active in suggesting and proposing creative solutions or new technologies to support the Board and wider business teams involved.
- Ability to deliver compelling and clear insight to the wider business.
- Work closely with other BI and Data Team members to enable reporting to be automated.
- Maintenance and creation of supporting documentation to products developed.
- Mentor other team members within the team.
What you will bring to the team:
- Experience managing or supervising a team of BI Analysts.
- Experience in reporting professional with a good understanding of SQL scripting and data modelling gained in a BI and reporting development environment.
- Extensive experience in using Power BI (Desktop and Online, as well as Excel (to a lesser degree).
- Comfortability working with an Agile methodology using Kanban boards.
- Experienced in collaboratively with those around you, proactively building exceptional working relationships with internal and external stakeholders - you are equally able to shape the decisions with well-informed views.
- Experience with dimensional modelling (warehouses, data vaults, etc.) would be desirable.
What we can offer you:
- Flexible working & holidays - Enjoy flexible working and competitive holiday allowance, with annual buy & sell scheme options and your birthday off. Plus, additional holiday days for long service.
- Hybrid working - One day per week in our Bromsgrove Head Office.
- Social perks - To recognise and celebrate employees' great work we are all invited to our annual Christmas and Summer parties.
- Pension - We offer a contributory pension scheme with Royal London as well as death-in-service benefit.
- Bonus scheme - All AFH employees are offered a competitive salary and a discretionary annual bonus, following completion of a year's service.
- Health and wellbeing - The MediCash app puts your health in the palm of your hands. Claim cashback on a wide selection of health and wellbeing initiatives, including discounted health club memberships and free healthcare benefits.
- Professional development - We are committed to helping you reach your potential by offering tailored learning and development programmes to pursue your career goals.
- Shopping discounts - Our employees can choose from many retailers to get discounts or cashback on everyday purchases from our favourite high street clothing stores to our go-to supermarkets, as well as access to free online training courses.
To learn more about this opportunity and the culture of AFH Wealth Management, please visit our Careers website or email the People Resourcing team. We look forward to hearing from you!
Lead BI Analyst | Bromsgrove, UK employer: AFH Financial Group
Contact Detail:
AFH Financial Group Recruiting Team
recruitment@afhgroup.com
StudySmarter Expert Advice 🤫
We think this is how you could land Lead BI Analyst | Bromsgrove, UK
✨Tip Number 1
Familiarise yourself with Power BI and its advanced features. Since this role heavily relies on creating reports and dashboards using Power BI, showcasing your expertise in this tool during the interview can set you apart from other candidates.
✨Tip Number 2
Brush up on your SQL scripting skills. As the job requires a good understanding of SQL for data modelling, being able to discuss your experience with SQL queries and how you've used them in past projects will demonstrate your technical proficiency.
✨Tip Number 3
Prepare examples of your leadership experience. Since you'll be managing and mentoring other BI Analysts, think of specific instances where you've successfully led a team or project, and be ready to share these stories during your interview.
✨Tip Number 4
Understand Agile methodologies, particularly Kanban. Being comfortable with Agile practices is essential for this role, so be prepared to discuss how you've applied Agile principles in your previous work and how it has benefited your projects.
We think you need these skills to ace Lead BI Analyst | Bromsgrove, UK
Some tips for your application 🫡
Tailor Your CV: Make sure your CV highlights relevant experience in BI analysis, particularly with Power BI and SQL. Emphasise any leadership roles or mentoring experiences you've had, as this is a key aspect of the Lead BI Analyst position.
Craft a Compelling Cover Letter: In your cover letter, express your enthusiasm for the role and the company. Mention specific projects or achievements that demonstrate your ability to lead BI initiatives and collaborate with stakeholders effectively.
Showcase Your Technical Skills: Clearly outline your technical skills related to BI tools, especially Power BI and SQL. Provide examples of how you've used these tools to create reports and dashboards that meet stakeholder requirements.
Highlight Team Collaboration: Discuss your experience working in Agile environments and how you've successfully collaborated with technical teams and stakeholders. This will show that you can manage projects and deliver solutions effectively.
How to prepare for a job interview at AFH Financial Group
✨Showcase Your BI Expertise
Make sure to highlight your experience with Power BI and SQL during the interview. Be prepared to discuss specific projects where you've created reports or dashboards, as this will demonstrate your technical skills and understanding of BI solutions.
✨Demonstrate Leadership Skills
Since the role involves managing and mentoring other analysts, be ready to share examples of how you've successfully led a team in the past. Discuss your approach to mentoring and how you handle team dynamics to ensure everyone is working effectively.
✨Prepare for Stakeholder Interaction
The job requires close collaboration with stakeholders, so think of instances where you've worked with different teams to gather requirements or resolve issues. Show that you can communicate complex data insights clearly and build strong relationships.
✨Emphasise Problem-Solving Abilities
Be proactive in discussing how you've tackled challenges in previous roles, especially regarding data integrity or reporting issues. Highlight your ability to suggest creative solutions and new technologies that could benefit the team and the wider business.