Business Intelligence Analyst

Role Overview

ABM UK is seeking a Business Intelligence Analyst to join their team in London. This role focuses on creating and maintaining interactive dashboards and reports using Microsoft Power BI. The successful candidate will collaborate with various departments to understand business needs and translate them into effective BI solutions. A strong foundation in data analysis, report generation, and business intelligence principles is essential. The role involves working with Power BI and other ABM and third-party platforms to meet operational demands and drive innovation.

Main Duties

• Develop and maintain Power BI and other dashboards and reports to deliver actionable insights to business stakeholders.
• Perform data modeling, including data cleaning, transformation, and aggregation, to create efficient data structures.
• Integrate data from diverse sources such as databases, cloud services, and APIs, ensuring data integrity and consistency.
• Engage with business users, clients, and third-party partners to gather requirements and translate them into technical specifications and dashboard designs.
• Optimize the performance of Power BI reports and dashboards for fast loading and responsive user experiences.
• Provide training and ongoing support to end-users on platform functionalities and best practices.
• Create and maintain thorough documentation for all Power BI solutions, including data models, reports, and dashboards.
• Stay current with the latest Power BI features, industry trends, and best practices to enhance reporting and analytics capabilities.

Desired Experience

The ideal candidate will possess a Level 4 Data Analyst apprenticeship or equivalent qualification. A minimum of two years of experience in business intelligence and data analytics, with a specific emphasis on Power BI and dashboard development within a client-facing environment, is required.

Technical Skills

• Expertise in Microsoft Power BI, including DAX and Power Query.
• Proficiency in SQL and experience with relational databases.
• Understanding of data warehousing principles and ETL processes.
• Familiarity with Microsoft Power Platforms.
• Experience with other Microsoft BI tools like SSRS, SSIS, and SSAS is advantageous.

Soft Skills

• Strong analytical and problem-solving capabilities.
• Excellent communication and interpersonal skills, suitable for engaging with senior client stakeholders.
• Ability to work effectively both independently and as part of a collaborative team.
• Meticulous attention to detail and a commitment to producing high-quality work.

Preferred Qualifications

• Microsoft Certified: Data Analyst Associate or similar certifications are preferred.
• Experience within the Facilities Management industry is a plus.
• Familiarity with additional data visualization tools and programming languages such as Python or R is beneficial.

Benefits

ABM UK offers a comprehensive benefits package, including:

• 24/7 GP service for employees and their immediate families.
• Mental health support and life event counseling.
• A 'Get Fit' program.
• Access to financial and legal support services.
• Cycle to Work scheme.
• Perks at Work employee app, providing discounts, gift cards, cashback, and exclusive offers, as well as resources for personal and professional development, and crisis support.

Additional Information

ABM is committed to fostering diversity and inclusion in employment. They are a proud member of the Armed Forces Covenant Employer Recognition Scheme.

For more information about ABM's benefits and the company, please visit their website.