Business Intelligence Analyst

Intec Select
London (Greater)
15 Sep 2018
18 Sep 2018
Contract Type
Full Time
Business Intelligence Analyst
Global market leading Financial Services business requires a highly skilled Business Intelligence Analyst. The successful candidate will be responsible for delivering accurate and timely MI based on business requirements. Using complex SQL queries and advanced database tools to collect, manipulate and analyse data and Microsoft Excel to prepare reports, which may be in the form of graphs, charts and dashboards.

Key Responsibilities
·Contribute to the development of the long-term Business Intelligence strategy.
·Work closely with all areas of the business to understand and document their MI requirements.
·Design, review, develop and implement Oracle and SQL Server database objects, models and designs.
·Help support the IT Application Support team in identifying the business impact of major incidents.
·Create monthly KPI report for senior management.

Skills & Experience
·Experience extracting data using Oracle SQL Developer / Microsoft SQL Server Management Studio essential.
·Experience using SQL Server Reporting Services (SSRS), Analysis Service (SSAS) and Integration Service (SSIS) desirable.
·Advanced Excel skills for data manipulation & reporting, with working knowledge of pivot tables and lookups is essential.
·Experience using scheduling packages; creating, implementing and maintaining jobs.
·Advanced SQL skills essential, including the creation complex queries (e.g. recursive CTEs).
·Experience writing T-SQL, PL-SQL and/or MySQL desirable.
·VB scripting experience desirable.

·£40-45k basic salary
·Annual bonus
·13% company contribution pension
·Life assurance
·35 hour standard working week
·Private medical
·25/27 days holiday

This job was originally posted as

Similar jobs

Similar jobs