Are you confident with data modelling?Are you a confident communicator?

Then consider the role of Business Intelligence Developer at Reed in Partnership!

We are on a mission to be the partner of choice for developing people and their communities. Reed in Partnership is a public service provider specialising in skills training for the long-term unemployed, increasing employment opportunities by working with employers and providing youth services

What is the role about?

The BI Developer will be a part of the BI Team, specifically the BI Development Team. The BI Development Team are responsible for designing, building, and maintaining data infrastructure platforms. We transform raw data into the building blocks of meaningful analytics and insights that RinP use for decision-making. Dev Team tasks include developing data models, maintaining data pipelines, implementing data storage solutions, and ensuring data accuracy.

Just some of your day-to-day responsibilities will include

Day-to-day tasks can vary quite a lot and a high level of autonomy will be granted so it is essential that the BI Developers are able to effectively manage their own tasks and time, along with taking opportunities to create and update documentation, simplify and automate processes, and work with other teams in the business to troubleshoot and offer solutions.

Some general tasks specific to the BI Developer role are:

Data Pipeline Architecture

• Building, testing, and maintaining database pipeline architectures in ADF and Snowflake.

Data Modelling

• Designing and maintaining data models in Snowflake, Dataflows, and Power BI. Establishing connections between different information locations and systems.

Data Orchestration

• Manipulating raw data to make it more accessible, organized, and easier to analyse for people both inside and outside of the BI team.

Dataset Creation

• Working with specific criteria from Operations or Analyst teams to source the correct data, build cohesive datasets and create measures and KPIs as a "single source of truth" for reporting.

Best Practice and Support

• Applying and documenting best practices to provide clean, transformed datasets across the team. Supporting other teams with Snowflake / PBI models and knowledge sharing.

Collaboration

• Working with other team members to ensure efficient data workflows, accurate reporting figures, and insights deliveries.

What's in it for you?

A generous base salary (pro-rata for part time), and great flexibility with your working schedule, we offer training, development and progression opportunities. You will have access to the range of Reed in Partnership benefits, which include:

• 25 days annual leave (pro-rata for part time) plus statutory bank holidays
• Reed Pension Scheme
• Award Winning Management & Leadership training
• Professional & Personal Development Funds
• Bi-annual pay reviews
• Plus much more that can be found on our website
• With the chance to dramatically make a difference to the local community, this role offers immense job satisfaction.
• At Reed in Partnership, we live and breathe our values in every decision and action taken, resulting in a collaborative and enjoyable culture within our offices. Our company values - we are fair open and honest; we take ownership, and we work together.

To be successful in this role, we are looking for someone with

• Technical Skills Required
• Understanding of ETL / ELT processes
• Understanding and experience with DDL / DML
• Query optimisation and performance tuning
• Proficiency in SQL and DAX (Python would be desirable)
• Star schema data modelling
• Experience with or knowledge of:
• Azure Data Factory
• Snowflake
• MS Power Platform - Power Apps / Power Automate
• GitHub

Soft Skills Required

Verbal and Written Communication

• We often need to explain complex technical concepts to non-technical stakeholders. Clear communication is crucial for conveying insights and collaborating effectively.

Adaptability

• In a rapidly changing field, we must adapt to new tools, technologies, and business requirements. Being open to change and learning is essential in succeeding in this role.

Critical Thinking

• The ability to analyse problems objectively, frame questions correctly, and find optimal solutions is very important to delivering the best outcomes for us and others.