Business Information Analyst Power BI

• The Business Information Analyst ensures that Maintenance Service’s operational reporting supports data driven decision making through the creation, development and provision of performance reports, dashboards and insights. Developing robust dashboards, scorecards and reports. Drive the comprehensive delivery of reporting requests/business problems, from initial conception to the deployment of new dashboards/reports, utilising project management methodologies to meticulously track and report progress. Maintain a forward-looking approach to data analysis, identifying areas for investigation and improvement before they become critical.

• The Business Information Analyst will work with colleagues in Maintenance Services Service Improvement Team and other teams across the department to provide information to make the case for business change and to monitor the embedding of changes made through the delivery of improvement projects.

• You will help the department achieve its goals by providing strategic data support, anticipating future challenges, developing advanced reporting and analytics for the Heads of Service, and Directors, and ensure data accuracy and improvement

Do you have experience in T-SQL?, * The successful candidate must have experience designing and delivering end to end BI solutions using Microsoft Power BI including data modelling, DAX and Power Query.

• You can read and write TSQL & MySQL Syntax at an advanced level and perform select and join queries to return data, with the ability to optimise performance for large datasets.

• Experience with configuring and supporting reporting development using visualisation tools, Power Paginated reports is a must.

• We are looking for someone who can work well under pressure, who can fulfil ad-hoc data queries, data requests from around the business as well as support our drive to enable transparency of performance and support new initiatives with data, * Read and write TSQL, Syntax at an advanced level (essential)

• Experience with Power BI, including the writing of queries and measures in ‘M’ and ‘DAX’ (essential)

• Experience with configuring and supporting reporting using visualisation tools. PBI/Power Paginated Report or similar (essential)

• Strong I.T skills and advanced knowledge of MS Office 365, Microsoft Excel (essential)

• Desirables are Automation, PowerApps, andPoint knowledge and a wide experience of sourcing data into BI (SharePoint, Exchange, API etc.)

• Commitment to providing high levels of customer service

• Experience of producing regular KPI reports

• Demonstrates an understanding of business improvement methods (desirable)

• First class communication skills, with an ability to present data and analysis to stakeholders

• Capable of embracing constant change in a fast-paced environment

29-35 West Ham Lane, London Hybrid work Permanent, Full-time, Pulled from the full job description

• Annual leave
• Employee assistance programme

• Company pension, Benefits include: Excellent pension plan (up to 6% double contribution), 28 days Annual Leave rising to 31 days with length of service + Bank Holidays, Westfield Health Cash Plan, non-contributory life assurance, up to 21 hours volunteering paid days, lifestyle benefits, Employee Assistance Programme and many more… Early applications are encouraged as we reserve the right to close the advertisement and interview earlier than stated. L&Q reserve the right not to progress applications from candidates with 3 or more unsuccessful applications/interview processes with L&Q in the previous 24 months Join our Service Insights and Improvement Team at L&Q:

• Our department has expanded, and we are increasing and improving our reporting functionality as we incorporate new services, systems and data sources moving to one version of the truth

• As a key Analyst of Maintenance Services’ data analytics, this role ensures that KPI reporting is developed and refined. You will also provide operational reporting which constantly reflects and anticipates business needs.

About L&Q: We’re one of the UK’s leading housing associations and developers. We were founded on a simple belief: high quality housing is vital for people’s health, happiness and security. Everyone deserves a quality home that gives them the chance to live a better life. 250,000 people call our properties ‘home’, and we’re proud to serve diverse communities across London, the South East and North West of England. People are at the heart of our business and our success depends on employing the best people and getting the best from them. The foundation of everything that we are is built on our corporate values and behavioural framework, which outlines our core expectations and should be demonstrated at all times, and all levels, when representing L&Q. At L&Q, we know that diversity and inclusion make us stronger - and they’re at the heart of everything we do. When we recruit, we look at what really matters: your skills, experience, and potential. We’re proud to be recognised for creating an inclusive workplace. We’re a Disability Confident Leader (Level 3) and we’ve introduced our own Recruitment Advocate scheme to make sure every step of our hiring process is fair, transparent, and consistent. It’s all part of our commitment to ending discrimination and making L&Q a place where everyone feels welcome. Fine out more here. Sustainability is also at the heart of what we do. We recognise the responsibility we hold as one of the UK’s largest housing associations. Click here to find out more about L&Q and why you should join us!