BI Analyst

Advantage Resourcing
18 May 2017
16 Jun 2017
Contract Type
Full Time
Role Purpose

Responsible for assisting in the maintenance and production of reports and data sets throughout the business. You will be technically strong in the areas of effective data management, efficient report writing and have the ability to provide meaningful data analytics and insights throughout all areas and levels of the business.

You will maintain the current methods and establish new approaches to reporting, data insights and management which will enable the business to use its data to provide an enhanced, world class customer service and enable it to exceed its position in the market. You will be comfortable using the latest enterprise data platforms and methodologies, next generation technologies and innovative tools to drive the business forward.

Role Accountabilities

Support the BAU activities for any report, dashboard or data set requests
Responsible for assisting with the delivery of management information requests and working closely with Directors, Managers and Team Leaders in all areas of the business
Creation and management of data insight solutions including any associated data sets, reports or dashboards
Support and assist in any projects throughout the business that requires data insights or reports
Develop, analyse and present information for key operational activities
Designing and implementing data integration and data conversion solutions in line with batch or real-time information delivery
Support the design, configuration, optimisation, monitoring and maintenance of the business' data and reporting platforms
Making meaningful recommendations to potential process improvements, evidenced and supported by data
Designing and implementing enterprise data and reporting architectures including supporting the design, implementation and eventual maintenance of the new Enterprise Data Warehouse
Support the development of strategies and roadmaps for BI and Analytics solutions

Reporting to the IS Manager and work closely with the Database Administrator. They will play a vital part in the technical team within the department.

Personal Profile

At least two years MSSSQL experience (SQL2012 and above) including:
Understanding of SQL Server Database Schema and SQL Server Database Objects
Ability to extract data efficiently using T-SQL
Understanding of SQL Server Indexes
Understanding of performance implications from large data extracts
Ability to test different extract methodologies to work around database structures and performance bottlenecks
At least two years SSRS experience (SQL2012 and above) including:

Deploying reports
Reports with multi-value parameters
Reports with drilldowns, drill down objects and sub reports
Creating dashboards
Ability to develop efficient and effective TSQL
Understanding of SQL Server Index creation & usage

Desirable technical skills and experience:

Experience of SSISo Experience of working with an Enterprise Data Warehouse (SSIS & ETL methods)
Any exposure to BI tools such as Tableau, Alteryx or PowerBI
Any exposure to Microsoft Navision or Dynamics CRM
Microsoft Excel (2010 and above)
Embedding Stored Procedures?
Ability to use VBA

Advantage Resourcing is a service driven recruitment consultancy.