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.