Business Intelligence Analyst

at  Shawbrook Bank

THE ROLE & RESPONSIBILITIES

The main objectives are:

• Reporting to the Data and Reporting Director, they will play a key role in the maintenance, manipulation and dissemination of key information around the business.
• Becoming part of a small team assisting the Data and Reporting Director in the provision of data and reporting to a diverse group of internal and external stakeholders.
• Supporting the administration of the data warehouse.
• Liaising directly with representatives of various business areas to understand their requirements and then working from raw data through visualization to distribution of the reports.

SPECIFIC RESPONSIBILITIES INCLUDE THE FOLLOWING:

• Gain a detailed understanding of the database structure, processes and interactions with the system front-end.
• Building and maintaining essential SQL queries.
• Development of reports using SQL, Visual Studio, SSRS and Power BI. Liaison with the report users to ensure that these reports are suitable for purpose.
• Assisting in the upkeep of SQL Server databases.
• Provision of timely and accurate reports to senior management and other stakeholders.
• Using Excel to manipulate and present the extracted data into a form which best suits the intended use of the specific stakeholders.
• Project work to enhance and evolve the reporting environment as and when required.
• Identifying opportunities to build efficiencies, integrations and automations then developing them through to realization.