Data Engineer

Reed in Partnership has been delivering public services since 1998. We are a British, family-owned company, whose mission has always been to positively transform people and their communities. This is reflected in our services, which we deliver to help people from all backgrounds and circumstances to change their lives for the better.

Job Description

The Data Engineer will be a part of the BI Team, specifically the Data Engineering Team. The DE 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. DE Team tasks include developing data models, maintaining data pipelines, implementing data storage solutions, and ensuring data accuracy.

This is not intended to be an exhaustive list and as such you will be expected to carry out any other duties that may be specified by your Line Manager from time to time. This job description is non-contractual.

Reed in Partnership requires the full commitment and cooperation of its employees to strictly adhere to company policies and procedures, which includes quality standards(2), data protection(3), health and safety(4), diversity(5) and safeguarding(6).

Must be able to travel to the Liverpool office ONCE a week.

KEY RESPONSIBILITIES

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.

To research the internal and external reporting requirements of existing and newly awarded contracts by proactively determining the information needs of key stakeholders including Operations and Supply Chain Management and how this needs to be structured in the database.

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.

PERSON SPECIFICATION

Essential Technical Skills

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

Power BI

Experience with or knowledge of

Azure Data Warehouse

Snowflake

MS Power Platform – Power Apps / Power Automate

GitHub

Soft Skills

Verbal and Written Communication

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.

Personal Specification

Strong coding skills in Power BI with Evidence of DAX & Power Query, SQL

Strong Modelling skill in with evidence Implementing Kimball Modelling

Strong Visualisation skills with evidence of an array of visualisations

Strong Design Skills with evidence of clear engaging story telling

We aim to ensure that no candidate or employee receives less favourable treatment on the grounds of gender, race, disability, sexual orientation, religion or belief, age, gender reassignment, marital or civil partnership status, pregnancy or maternity. We offer a guaranteed interview scheme for disabled applicants who meet the minimum criteria.