Data Engineer - Remote / Home Working

Data Engineer - Remote / Home working

About the role

You will be involved in the design, development and delivery of full data solutions, in particular data reporting, using the Microsoft BI stack. You will have strong T-SQL skills and Performance Dashboard development. In particular you will have strong skills in developing and maintaining Data Warehouses, creating SSRS reports and in data visualisation tools such as Power BI.

You must have strong experience of developing in Visual Studio database solutions and releasing changes via Azure DevOps automated deployments, with experience of creating and running unit tests and be able to mentor and guide other members of the team towards an automated test-driven approach. You will work with members of the business to capture requirements and help shape the development of the reports and dashboards.

We are looking for someone who has gained experience in a variety of different tools and implementations who is capable of making informed choices. You will have extensive experience of working within a team.

Data Engineer - Key Duties

Key Accountabilities

Responsible for the design and development of data solutions across the company.

Develop and maintain Azure Data Warehouse Solution

Deliver and maintain performance dashboards to operational teams and external customers to ensure business access to essential data.

Deliver and maintain SSRS reports to ensure business and customer access to essential MI/BI.

Contribute to the design and development of new solutions using Power BI.

Define, update and adhere to software development patterns and standards.

Provide technical assistance, support and development skills across the company.

You must have experience in developing in Visual Studio and Azure DevOps pipelines in Test Driven Development, we are looking for someone who can help us introduce and instil that mind-set in the rest of the team.

Liaise with third party software providers throughout the lifecycle - including design, development, support and maintenance, ensuring best practise.

Data Engineer - Key requirements

Highly numerate with previous experience in delivering BI reporting solutions.

Good T-SQL skills are essential.

Good understanding of data warehousing, ETL and database concepts.

Good experience of Microsoft BI technologies.

Experience in delivering complex reporting solutions.

Technologies

Essentials:

Microsoft stack

SQL Server 2016

Data Warehouse

SSIS

SSRS

Power BI

SQL Server Unit Tests

Azure DevOps

Visual Studio

Desirable:

CI/CD Pipelines

Azure SQL

Azure Data Factory

Demonstrate Agile - Experience of Agile Scrum methodology.