Business Analyst
Glasgow

Business Intelligence Analyst

Ref: 473| Posted: 13th Mar 2019

Reporting to the Head of Business Intelligence, the BI Analyst will play a key role in the dissemination of key information around the business. Becoming part of a small team assisting the Head of Business Intelligence in the provision of data and insight to a diverse group of internal and external stakeholders via detailed business analysis. Creation and maintenance of SQL queries to enable timely extraction of business-critical information.
 
ABOUT OUR CLIENT
 
Our client is a Financial Services firm providing specialist lending across the UK. A dynamic organisation which can offer the right candidate an extraordinary career path within an environment of excellence and considerable potential.
 
THE SUCCESSFUL APPLICANT
  • Graduate level with a minimum of 3 years’ experience in financial services, ideally mortgages or similar loan products.
  • Regular use of SQL Server and relational databases.
  • Microsoft Office suite, specifically advanced Excel, ideally with VBA.
  • Excellent communication skills, both verbally and written (report writing).
  • Can work well under pressure, using their own initiative with minimum oversight. A willingness to go ‘above and beyond’ when necessary.
 
JOB DESCRIPTION
  • Gain a detailed understanding of the database structure, processes and interactions with the system front-end.
  • Building and maintaining essential SQL queries.
  • Ensure that key reports are made available through Visual Studio and SQL Server Reporting Services. Liaison with the report users to ensure that these reports are suitable for purpose.
  • 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.
  • Regular liaison with stakeholders to ensure that reporting requirements are continually met and understood.
  • Project work to enhance and evolve the reporting environment as and when required
 
REMUNERATION PACKAGE ON OFFER
 
Competitive Salary & excellent benefits.