BI Analyst

  • Location: Reigate
  • Type: Permanent
  • Payment: £45000 - 55000
  • Per: Annum
  • Role: Other

Posted by : Hannah Burdett

Email : hannah.burdett@intecselect.com

Business Intelligence Analyst

Overview
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.
• Liaising directly with the business to gather and refine requirements.
• Design and deploy ETL solutions with SSIS.
• Test and reconcile data between source transactional/operational systems and data warehouse.
• Manage SSIS projects and packages.
• Building reports using SSRS and Power BI.

Skills & Experience
• Experience extracting data using Oracle SQL Developer / Microsoft SQL Server Management Studio essential.
• Experience using Integration Service (SSIS) essential, SQL Server Reporting Services (SSRS) & Analysis Service (SSAS) desirable.
• Advanced Excel skills for data manipulation & reporting, with working knowledge of pivot tables and lookups is essential.
• Experience using scheduling software; creating, implementing and maintaining automated jobs desirable.
• 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.

Package
•£45-55k basic salary
• Annual bonus
• 13% company contribution pension
• Life assurance
• 35 hour standard working week
• Private medical
• 25 days holiday
Business Intelligence Analyst

Apply for this role

Other vacancies

Other

  • Reigate
  • £45000 - 55000
  • Permanent
  • 06th Dec

J1664

Other

  • Reigate
  • £45000 - 55000
  • Permanent
  • 06th Dec

J1670

Other

  • Reigate
  • £45000 - 55000
  • Permanent
  • 06th Dec

J1676