Business Intelligence Analyst - Large supportive Company - Leeds - 628

Interface Recruitment UK; Leeds; On-site; GBP 30,000 - 60,000; Full time

Job summary

An established industry player is seeking a Business Intelligence Analyst / Systems Developer to transform their reporting platform. This role involves providing vital support for business applications, data mining, and analysis to empower data-driven decisions. The ideal candidate will have strong skills in SQL, Microsoft BI technologies, and excellent communication abilities to bridge technical concepts for non-technical users. This is a unique opportunity to contribute to a greenfield project, enhancing the organization’s BI capabilities. If you thrive in a dynamic environment and are passionate about data, this role is perfect for you.

Qualifications

• Experience in a similar role within a corporate environment is essential.
• Strong knowledge of Microsoft BI technology stack and SQL.

Responsibilities

• Provide user application support and data analysis using SQL and BI tools.
• Train users on business applications and produce data models.

Skills

SQL

Communication Skills

Data Analysis

Problem-Solving Skills

VBA

Interpersonal Skills

Report Writing

Dashboard Design

Education

Degree in a relevant field

Tools

PowerBI

Tableau

Microsoft BI Stack (T-SQL, SSIS, SSAS, SSRS)

Crystal Reports

Job description

Job Title: Business Intelligence Analyst / Systems Developer

JOB SUMMARY

Business Intelligence Analyst activities including providing front-line support of business applications in addition to extracting, manipulating, analysing and delivering data and information. The position will require strong communication, interpersonal and relationship management skills with a focus on service and support.

This is a rare opportunity to re-design our complete reporting platform from the ground up using a greenfield approach to provide quality, fit-for-purpose BI solutions that enable effective, data-driven business decisions to be made.

DUTIES AND RESPONSIBILITIES

The focus of this role will be on providing user application support and data mining and analysis support to users. These assignments will include, but not be limited to:

1. Basic ERP/MRP system support for users
2. Data mining and analysis using SQL and/or other tools as required e.g. PowerBI and Tableau
3. Provide user training and/or coaching related to the use of business applications
4. Excel based, VBA scripted data manipulation and extraction/load design and support
5. Produce and maintain an enterprise wide data model and related data dictionaries
6. Other duties as assigned

EXPERIENCE

1. Experience working in a similar role in a professional/corporate environment
2. Microsoft BI technology stack experience – T-SQL, SSIS, SSAS, SSRS
3. Basic Report Writing and Dashboard Design (SSRS and Crystal Reports)
4. Database development (complex SQL queries, stored procedures, user-defined functions, table design and performance optimisation)
5. Solid understanding of the development to production deployment process
6. Advanced Microsoft Excel including VBA (preferably utilising class based development)
7. Basic understanding of ERP and warehouse management transaction lifecycle
8. Solid analytical and problem-solving skills with the ability to formulate and communicate recommendations for improvement
9. Excellent interpersonal and verbal/written communication skills, as well as the ability to present and explain technical information in a way that can be fully understood by a non-technical audience
10. Ability to work independently, to deadlines and under pressure and to prioritise work effectively whilst managing the expectations for delivery of end users

Desirable

1. Redgate or TFS based source control setup and management
2. Documentation and change management control
3. PowerBI or Tableau dashboard design and management
4. An understanding of ETL process design, delivery and management
5. Data Warehousing (Kimball) / Master Data Management
6. MCP in Querying SQL Server 2012 (70-461) – with a view to completion of the MCSA: SQL Server 2012/2014 programme
7. Any experience (including non-professional) of data visualisation / analysis / statistical modelling/ SQL 2016
8. Any experience (including non-professional) of virtualisation, disaster recovery, backups etc

Additional Requirements

1. Must be willing to travel occasionally (UK only)
2. Must be flexible to work additional hours when required e.g. out of hours system maintenance