MI, Data and Reporting Analyst

Job Title: MI, Data and Reporting Analyst
Contract Type: Permanent
Location: Leeds, West Yorkshire
Salary: £40000.00 - £42000.00 per annum
Reference: BBBH25067_1608551011
Contact Name: Jessica Jolly
Contact Email:
Job Published: December 21, 2020 11:43

Job Description

My client based in Leeds are looking for an MI, Reporting and Data Analyst to develop and maintain MI reporting and underlying data sets in accordance with business requirements, providing regular and ad-hoc reports and data extracts to teams across the business. Design, develop, implement and support the company databases and data sets, including the ongoing maintenance of SQL Server databases.

This is a key role for the company and there will be opportunity for development and progression as well as training in CLoud tech and Power BI.

  • Work closely with running existing reports, creating new reports, data issue resolution, liaising with internal departments and other team members.
  • Read and understand requirements and translate into management reports for internal and external audiences.
  • Field ad-hoc report requests and data enquiries from various areas of the business
  • Liaise with internal and external stakeholders to fully understand data content and provide data extracts to teams across the business.
  • Production and delivery of regular and ad-hoc MI reports for various business units using Excel and SQL Server Reporting Services and Power BI.
  • Ensure the delivery of reporting and data extracts are timely and accurate and fully tested before circulation.
  • Support and improve the reporting processes, developing tools and processes to enable automation of existing data manipulation and reporting activity.
  • Involvement in the design and build of new analytical solutions and the ongoing development of the Data Warehouse and BI platform, together with migration to the cloud.
  • Supporting projects aligned to the development of the reporting process, working on projects to deliver innovative reporting solutions.
  • Maintain appropriate documentation concerning reports, procedures and data structures, ensuring all processes that relate to management information are documented to company standards and kept up to date
  • Building & maintaining customer relationships through good interpersonal skills, providing technical expertise in data analysis.
  • Data extraction and load to/from Development, Test and Operational systems.
  • Data cleansing and enhancement through the use of internal and external data sources.
  • Audit and exception reporting.
  • Monitor and audit data quality, maintaining the integrity of data and systems; conduct regular audits of data and cross reference with other business systems.
  • SQL Server reporting monitoring, troubleshooting and tuning.
  • Administer the company's SQL databases, resolving production database issues including database tuning, optimization and database recovery.
  • Installing, tuning, upgrading and maintaining both internally and externally databases and data sets.
  • Provision of test systems/data for system and user testing.
  • Monitor the performance of production and reporting databases, identify areas where performance needs to be improved and provide fixes/solutions for the performance issues.