Business Intelligence Developer (SQL / ETL / PowerBI)

About Our Client

Large Government Body

Job Description

This Large Government Body is looking for a Business Intelligence Developer to play a crucial role in maintaining and enhancing their Business Intelligence solutions and automated tools. You will work with Customer Service, Finance, HR, and divisions to generate valuable management information.

Collaborating with a diverse team of technical and data specialists, you will improve reporting capabilities and ensure thorough documentation of any changes to reporting solutions. Your role will be vital in developing and delivering accurate, reliable, and effective management information to support the organisation's needs.

The role is Hybrid with 20% of a working month based in the office either in Leeds, Birmingham, or Cardiff.

Key Responsibilities:

1. You will be an authoritative voice identifying opportunities for improving the way data is sourced and stored in the data warehouse.
2. Work closely with the Performance Analysts, Lead BI Developer, CRM, and SharePoint specialists to ensure that new and changed reporting requirements are properly captured prior to analysis and development.
3. Lead in the design and support of robust routines for the production and delivery of reliable, accurate, agreed Management Information from key systems (case management, telephony, finance, and HR).
4. Assess requirements, design solutions, document models, and deliver ETL solutions using SSIS and Azure Data Factory.
5. Develop and modify existing ETL models to support changes to the business process or emerging business needs.
6. Maintain and develop further the data warehouse in line with changing business MI needs.
7. Identify and articulate opportunities to put further query and reporting capabilities in the hands of business users.
8. Support data quality across the organisation by working with users to identify and rectify data capture errors.

Essential Key Skills / Experience:

1. A great communicator, able to communicate effectively with all levels of the organisation.
2. Good understanding of best practice in Data Warehouse Implementation.
3. Strong critical thinking, problem-solving, troubleshooting, and decision-making with the ability to work to deadlines.
4. Adapt to changes and re-evaluate priorities to meet changing priorities.
5. Advanced ETL, SQL programming / SSIS skills.
6. Skills in data mapping and modelling.
7. 3-5 years' experience in SQL language.
8. Knowledge of Kimball methodology / Star Schema modelling in Data Warehousing.
9. Experience of SSIS and SSMS.
10. Good understanding and experience of building ETL processes including extracting data via APIs.
11. Advanced understanding and ability to build and develop Power BI reports and dashboards to a high standard fulfilling business needs.
12. Preparing and communicating reports and management information.

Desirable Skills / Experience:

1. Management of Azure PaaS and IaaS instances.
2. Experience of Azure Data Factory.
3. Experience of SSRS.
4. Experience of PowerApps and Power Automate.

The Successful Applicant

Essential Key Skills / Experience:

1. A great communicator, able to communicate effectively with all levels of the organisation.
2. Good understanding of best practice in Data Warehouse Implementation.
3. Strong critical thinking, problem-solving, troubleshooting, and decision-making with the ability to work to deadlines.
4. Adapt to changes and re-evaluate priorities to meet changing priorities.
5. Advanced ETL, SQL programming / SSIS skills.
6. Skills in data mapping and modelling.
7. 3-5 years' experience in SQL language.
8. Knowledge of Kimball methodology / Star Schema modelling in Data Warehousing.
9. Experience of SSIS and SSMS.
10. Good understanding and experience of building ETL processes including extracting data via APIs.
11. Advanced understanding and ability to build and develop Power BI reports and dashboards to a high standard fulfilling business needs.
12. Preparing and communicating reports and management information.

Desirable Skills / Experience:

1. Management of Azure PaaS and IaaS instances.
2. Experience of Azure Data Factory.
3. Experience of SSRS.
4. Experience of PowerApps and Power Automate.

What's on Offer

1. Opportunity to deliver enhanced analytics and reporting services.
2. Opportunity to influence and enhance insight & analytics strategy.