Business Intelligence Analyst

Job Title: Business Intelligence Analyst
Job Location: UK Flexible Location (remote) (with occasional travel for workshops and meetings)
Salary: £28,842 to £31,139 per annum based on 35 hours per week
Contract Type: Permanent Could you provide analysis to the Community Education service through the delivery of dashboards, reports and stories for our Business Intelligence team?
The Business Intelligence Analyst will enable products and services to be timely, relevant, and cost-effective by providing teams with access to data and insight for Community Education within UK Operations.
This is an opportunity to collaborate across the Community Education service with management and product teams as well as front line teams for service visits. You'll be encouraged to use your initiative and bring new ideas to life.
A day in the life of a Business Intelligence Analyst will involve:

• Develop a wide range of BI solutions using tools such as SQL Server, SSIS, PowerBI Premium, DataFlows and PowerBI.
• Requirements gathering and Business Analysis: Understanding the broader business and working with others to further develop their knowledge of business processes and requirements.
• Add value by understanding business problems and scope and structure an analytical approach to solving them.
• Data access, extract and load from multiple data sources through staging, integration, derived value and business rule generation to loading into the Data Warehouse.
• Be aware of data protection and information governance requirements.
• Design solutions which promote privacy and data protection compliance from the start
• Provide ad-hoc data sets as required to support business decisions, funding bids, commissioner or service manager requests.
• Write test cases and acceptance tests.
• Working with service leads and product owners to make sure acceptance tests track the desired functionality of the story.
• Recommend data enhancements to ensure that the data is developed in line with business objectives.

To be a successful Business Intelligence Analyst, you'll need:

• Educated to degree level in a numerate subject or equivalent by experience.
• Understanding of dashboard design tools (preferably PowerBI but Qlik,Tableau etc are relevant).
• Experience of Agile Project Management techniques and their application to different types of project.
• Demonstrable understanding of data modelling techniques.
• Understanding of the data lifecycle.
• Good understanding of data quality concepts
• Ability to interpret business requirements and create technical requirements
• Able to visualise and manipulate data from a database source.
• Automate processing tasks for transformation of data, including integrating different data types.
• Excellent verbal and written communication skills with the ability to communicate technical information to a broad range of audiences
• Strong interpersonal and relationship building skills
• Excellent time management and organisational skills, able to work independently and prioritise a varied workload to meet strict deadlines
• Understanding and experience of dashboard design tools (e.g. Qlik, PowerBI, Tableau)
• Experience using Microsoft SQL or DAX to access, query and manipulate data
• Familiarity with coding in at least one language and familiar with coding constructs.

The closing date for completed applications is 23:59hrs on Sunday the 28th of January 2024 with interviews to follow.
Please apply early, as we'll be reviewing candidates throughout. We reserve the right to close the ad in advance of the published date.
In return for your dedication and expertise, you'll get:
* Holidays: 36 days annual leave (including bank holidays) + option to buy 5 extra days.
* Pension scheme: Up to 6% contributory pension.
* Flexible working: We do our best to accommodate your preferred work style.
* Learning & Development: Wide range of career opportunities + comprehensive learning.
* Discounts: Access to Blue Light Discount Card and employee benefits platform.
* Wellbeing Assistance: Access to mental health and wellbeing assistance.
* Team Working: Champion our mission in a collaborative team.
* Cycle2Work: Lease a bicycle through the scheme.
* Season ticket loan: Interest-free loan for commuting expenses.
We are proud to participate in the disability confident scheme for roles based in the UK. During the application process, you will be asked if you wish to apply under the scheme.
At The British Red Cross, we pride ourselves on our diverse workforce, and ensuring we have an inclusive environment for all our staff and volunteers. We remain dedicated to ensuring our teams can bring their true selves to work without risk or fear of discrimination. We do this through regular data reporting, and the assistance of our internal Race and Equality Network (REEN). LGBT+ Network, our Disability and Wellness Network (DAWN), Gender Network, Carers Network and Youth Network.

Proud member of the Disability Confident employer scheme