BI Developer

Role: BI Developer

Contract: Permanent

Salary: £43,703 - £47,503

Location: Birmingham (Hybrid - 1 day per week in office)

Reports To: Lead BI Developer

Direct Reports: None

Your new company
This exciting role is for a well-known public sector organisation in Birmingham city centre within their Business Intelligence (BI) team.
The organisation provides legal services for people in a number of key areas, such as buying a home, dealing with bereavement, having issues at work, ending a marriage, or being involved in legal action, and they are looking to expand their BI team due to increased workload within the organisation.
The BI Developer role exists to maintain and develop our BI solution and automated tools, helping us to produce management information from telephony, finance, HR and other systems. Working with other technical and data specialists to improve our reporting capability, the BI Developer will enable effective distribution of relevant management information appropriately within the organisation and to ensure that changes and developments to reporting solutions are controlled with any changes to the business process clearly documented.

Key Responsibilities

You will be an authoritative voice identifying opportunities for improving the way data is sourced and stored in the data warehouse.
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.
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)
Assess requirements, design solutions, document models, and deliver ETL solutions using SSIS and Azure Data Factory.
Develop and modify existing ETL models to support changes to the business process or emerging business needs.
Maintain and develop further the data warehouse in line with changing business MI needs.
Identify and articulate opportunities to put further query and reporting capabilities in the hands of business users.
Support data quality across LeO by working with users to identify and rectify data capture errors.
This role exists to maintain and develop the BI solution and automated tools, helping the organisation to produce management information from telephony, finance, HR and other systems. Working with other technical and data specialists to improve the reporting capability, the BI Developer will enable effective distribution of relevant management information appropriately within the organisation and to ensure that changes and developments to reporting solutions are controlled with any changes to the business process clearly documented. You will build and test end-to-end reporting solutions for analysis by both internal and external stakeholders.

Essentials:

3-5 years' experience in SQL language and DBA.
A great communicator, able to communicate effectively with all levels of the organisation.
Good understanding of best practice in Data Warehouse Implementation
Strong critical thinking / problem-solving / trouble-shooting and decision-making with the ability to work to deadlines.
Adapt to changes and re- evaluate priorities to meet changing priorities.
Advanced ETL, SQL programming and DBA skills.
Skills in data mapping and modelling.
Knowledge of Kimball methodology and Star Schema modelling in Data Warehousing.
Experience of SSIS and SSMS.
Experience of creating pipelines in SSIS.
Good understanding and experience of building ETL processes including extracting data via APIs.
Advanced understanding and ability to build and develop PowerBI reports and dashboards to a high standard fulfilling business needs.
Desirables:

Microsoft Developer/DBA Qualifications
Ability to present and translate technical data into meaningful insights.
Able to accept constructive feedback.
Desire to learn new skills and improve knowledge and understanding.
Good team player able to work with the team effectively.
Work efficiently and to a timely manner.
Advanced Excel skills.
Management of Azure PaaS and IaaS instances.
Experience of Azure Data Factory.
Experience developing ad hoc reporting tools by using extracted data from core business systems.
Experience of SSRS
Experience of PowerApps and Power automate

What you'll get in return

Competitive salary or day rate with flexible working hours between 7am-9pm along with a highly attractive hybrid working pattern.
26 days annual leave + statutory.

What you need to do now
If you're interested in this role, click 'apply now' to forward an up-to-date copy of your CV, or call us now.
If this job isn't quite right for you, but you are looking for a new position, please contact us for a confidential discussion about your career.

Hays Specialist Recruitment Limited acts as an employment agency for permanent recruitment and employment business for the supply of temporary workers. By applying for this job you accept the T&C's, Privacy Policy and Disclaimers which can be found at (url removed)