Business intelligence Analyst - SQL/ Power BI

SHIFT PATTERN: Mon - Fri 0800 - 1700
We're here to help!
The Business Intelligence Analyst will be responsible for designing, developing and maintaining interactive and informative dashboards and reports using Microsoft Power BI. The ideal candidate should have a strong background in data analysis, report generation, and a deep understanding of business intelligence concepts. This role requires collaboration with various departments to gather requirements and ensure the effective use of Power BI and other ABM & third-party platforms to meet & align operational demands & other innovations.
Design, develop, and maintain Power BI and other dashboards and reports to provide actionable insights for business stakeholders.

• Data Modelling: Create and maintain efficient data models, including data cleaning, transformation, and aggregation.
• Data Integration: Integrate data from various sources, including databases, cloud services, and APIs, ensuring data accuracy and consistency.
• Requirement Gathering: Collaborate and align with business users, clients and third party service partners to understand their needs and translate them into technical requirements and dashboard solutions.
• Performance Optimisation: Optimise the performance of Power BI reports and dashboards, ensuring quick load times and responsive interactions.
• User Training and Support: Provide training and support to end-users on all platforms, functionalities and best practices.
• Maintain comprehensive documentation for Power BI solutions, including data models, reports, and dashboards.
• Keep up to date with the latest Power BI features, tools, industry innovations and best practices to continuously improve reporting, analytics capabilities and client experience.

Level 4 Data Analyst apprenticeship or equivalent.

~ Experience: Minimum of 2 years of experience in business intelligence and data analytics, with a strong focus on Power BI, dashboards within a client environment

Proficiency in Microsoft Power BI, including DAX and Power Query.

• Experience with SQL and relational databases.
• Knowledge of data warehousing concepts and ETL processes.
• Knowledge of Microsoft Power Platforms.
• Familiarity with other Microsoft BI tools, such as SSRS, SSIS, and SSAS, is a plus.

Strong attention to detail and commitment to delivering high-quality work.

Certifications: Microsoft Certified: Data Analyst Associate or similar certifications.

• Experience in Facilities Management Industry is a plus.
• Additional Skills: Familiarity with other data visualization tools and programming languages such as Python or R.

24/7 GP: Both you and your immediate family can speak to a UK-based GP from the comfort of your own home

• Mental Health support and Life Event Counseling
• Get Fit Programme
• Financial and legal support
• Cycle to work scheme
• Perks: discounts, gift cards, cashback, and exclusive offers

Online chat or telephone service for urgent support in a crisis
ABM (NYSE: ABM) is one of the world’s largest providers of integrated facility, engineering, and infrastructure solutions. ABM serves a wide range of market sectors including commercial real estate, aviation, mission critical, and manufacturing and distribution. With over $8 billion in annual revenue and a blue-chip client base, ABM delivers innovative technologies and sustainable solutions that enhance facilities and empower clients to achieve their goals. ABM are committed to employment practices that promote diversity and inclusion in employment regardless of age, disability, gender reassignment, sex, marriage and civil partnership status, pregnancy and maternity status, race, religion or belief. We are proud members of the Armed Forces Covenant Employer Recognition Scheme.