Data Engineer (Team Juniper)

Keoghs; United Kingdom; Remote; GBP 40,000 - 70,000; Full time

Job summary

A forward-thinking company is seeking a Data Engineer to join their innovative IT team. In this role, you will design and develop full data solutions, focusing on data reporting and visualization using the Microsoft BI stack. Your expertise in T-SQL, SSRS, and Power BI will be crucial as you create performance dashboards and maintain data warehouses. This is an exciting opportunity to work in a collaborative environment where your contributions will directly impact the organization’s success. If you are passionate about data and technology, this role is perfect for you.

Benefits

Davies Incentive Plan

25 days holiday

Family Private Medical Insurance

Health Cash Plan

WeCare mental health support

Death in Service Cover

Pension Scheme

Cycle to Work Scheme

Tech Scheme

Gym Flex Discounts

Qualifications

• Extensive experience with Microsoft BI stack and data reporting.
• Strong skills in T-SQL and performance dashboard development.
• Experience in developing and maintaining Data Warehouses.

Responsibilities

• Design and develop comprehensive data solutions across the organization.
• Deliver and maintain performance dashboards for operational teams.
• Liaise with third-party software providers throughout the project lifecycle.

Skills

T-SQL

Data Warehousing

SSRS

Power BI

ETL

Team Collaboration

Education

Bachelor's Degree in Computer Science or related field

Tools

SQL Server

SSIS

Azure DevOps

Visual Studio

Azure SQL

Azure Data Factory

Job description

Join to apply for the Data Engineer (Team Juniper) role at Keoghs

Description

SSRS, SSIS, SQL and Power BI experience is essential

Do you want to work for a forward-thinking, award-winning in-house software development team?

Department:

IT

Location:

Home United Kingdom

Role Overview

As a Data Engineer, you will be involved in designing, developing, and delivering full data solutions, particularly data reporting, using the Microsoft BI stack. You should have strong T-SQL skills, experience in performance dashboard development, creating SSRS reports, and data visualization tools such as Power BI. Experience in developing and maintaining Data Warehouses is also required.

You must have experience developing in Visual Studio and deploying via Azure DevOps pipelines, with a focus on test-driven development. Mentoring team members and working with business stakeholders to shape report and dashboard requirements are also key responsibilities.

Key Responsibilities

• Design and develop data solutions across the company.
• Deliver and maintain performance dashboards for operational teams and external customers.
• Develop and maintain SSRS reports for MI/BI access.
• Contribute to the design and development of Power BI solutions.
• Follow and promote software development standards.
• Provide technical support and development skills across the organization.
• Work with Visual Studio and Azure DevOps pipelines, promoting test-driven development.
• Liaise with third-party software providers throughout the project lifecycle.

Skills, Knowledge & Expertise

Extensive experience with a variety of tools and implementations, capable of making informed decisions, and proven team collaboration skills.

Performance Competencies

• Numerate with BI reporting experience.
• Strong T-SQL skills.
• Understanding of data warehousing, ETL, and database concepts.
• Experience with Microsoft BI technologies.
• Experience delivering complex reports.

Technologies

Essentials:

• Microsoft stack
• SQL Server 2008/12/16
• SSIS
• SSRS
• Power BI
• SQL Server Unit Tests
• Azure DevOps
• Visual Studio

Desirable:

• CI/CD Pipelines
• Azure SQL
• Azure Data Factory

Job Benefits

• Davies Incentive Plan
• 25 days holiday (increase with service, option to buy/sell 3 days)
• Family Private Medical Insurance (Bupa)
• Health Cash Plan
• WeCare mental health and wellbeing support
• Death in Service, Critical Illness Cover, Income Protection
• Pension (5% Employee / 3% Employer)
• Cycle to Work, Tech Scheme, Season Ticket Loan, Gym Flex, and other discounts

Additional Information

Seniority level: Associate

Employment type: Full-time

Job function: Information Technology

Industry: Law Practice

Location: Telford, England, United Kingdom