IT Reporting Analyst

This job is no longer open for applications.
​Please see similar jobs below:

  • Location

    London, England

  • Sector:

    Rail Jobs and Transportation

  • Job type:


  • Salary:

    Up to £0.00 per day

  • Contact:

    Rail Technical Team

  • Contact email:


  • Job ref:


  • Published:

    7 months ago

  • Expiry date:


  • Client:


Morson international is recruiting for a IT Reporting Analyst the role is is gathering the data required for close-out, assurance and handover within its core Information Management System (eB) and with massive datasets of transactional data it is critical that there is a robust and coherent reporting solution in place to measure progress.

This reporting solution is based on SQL, SSIS, Microsoft Power Automate and PowerBI and has evolved to meet the current needs of the business. The IT Reporting Analyst is responsible for all aspects of this solution and is responsible for ensuring that this solution is fit for purpose and meets the needs of the client.


  • Act as the subject matter expert of business data, database structures and business rules starting with our core EDMS through SQL based ETL processes into PowerBI datasets, dashboards and reports
  • Develop ad hoc reporting utilizing various tools such as SQL, Microsoft Office (Excel), Power BI and SSRS which use the correct data sources for a given analysis
  • Identify opportunities to automate processes around reporting data and deliver solutions using existing tools such as Microsoft Power Automate, SharePoint and Flow
  • Create and maintain technical documentation for the overall reporting solution and, where required, train the internal IT team on relevant processes and data sources
  • Meet with internal customers to gather required reporting and dashboard requirements and ensure that the overall reporting environment remains consistent in terms of key measures and dimensions
  • The development of the Support Analyst who reports into this role
  • Take reasonable care of your own and others' health and safety and of those who may be affected in the day-to-day delivery of this role by taking personal responsibility for working to the Target Zero principles.
  • Promote equality in the workplace and adopt appropriate behaviour when interacting with colleagues
  • Take necessary care to properly protect the confidentiality, integrity and availability of corporate information from unauthorised disclosure, modification or destruction. Never knowingly put the client information or information systems at risk


  • Able to demonstrate relevant experience in a report development, business analytics, business intelligence or comparable role
  • Proven ability to help guide customers in refining data needs
  • Ability to facilitate information and requirements gathering sessions
  • Ability to write and troubleshoot new and existing SQL queries
  • Experience working within a major infrastructure project
  • Advanced Excel Skills
  • Advanced experience working with SQL Server Management Studio highly preferred
  • Experience with Microsoft business intelligence tools, techniques and technologies a plus - SSIS, SSRS & PowerBI
  • Ability to foster and maintain positive working relationships with teammates when addressing issues delays and other needs
  • A willingness to adapt to new demands with enthusiasm, diligence and pragmatism
  • Able to calmly take ownership of technical issues and to resolve them quickly and effectively