Business Intelligence Analyst

Business Intelligence Analyst

Remote with very occasional travel

£40,000 - £42,000

An established organisation are looking for a technically strong Business Intelligence Analyst to join and play a key role in a major data transformation project.

During the first 12 months, you'll focus on migrating data to a new business system, rebuilding data pipelines and developing data warehouse processes. Following this initial project, you'll move into a broader BI role covering reporting, dashboard development, data visualisation and business insight.

This is an excellent opportunity for someone with strong SQL skills who enjoys solving data problems, improving data quality and building the foundations for effective business reporting.

Key responsibilities

• Lead and support data migration activities as part of a major business system implementation.
• Develop, rebuild and maintain data warehouse pipelines and ETL processes.
• Write, optimise and maintain complex SQL queries and stored procedures.
• Support data transformation, validation and reconciliation to ensure accuracy and consistency during migration.
• Develop and maintain data models, datasets, dashboards and reports.
• Translate business requirements into meaningful reporting and data insights.

You will need the following skills

• Excellent SQL skills, including writing complex queries and developing and maintaining stored procedures.
• Experience working with relational databases, ideally Microsoft SQL Server and T-SQL.
• Experience with data warehouses, data pipelines and ETL processes.
• Previous involvement in data migration or system implementation projects.
• An understanding of data modelling, data quality, validation and reconciliation.
• Experience developing reports and dashboards using a BI visualisation tool such as Power BI or Tableau.
• The ability to communicate technical concepts clearly and work effectively with non-technical stakeholders.
• Experience with Microsoft Azure data services, such as Azure Synapse, would be beneficial.

The company work on a remote basis, with very infrequent travel to meet up - this could be in Bristol, Portsmouth or other locations that are convenient for the team.