As a Data Engineer 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 creating SSRS reports and in data visualisation tools such as Power BI, and will also hold experience of developing and maintaining Data Warehouses. As a Data Engineer, 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.
Key Accountabilities:
- Responsible for the design and development of data solutions across the company.
- 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.
Essential Skills and Attributes:
- 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.
Essential Technologies:
- Microsoft stack
- SQL Server 2008/12/16
- SSIS
- SSRS
- Power BI
- SQL Server Unit Tests
- Azure DevOps
- Visual Studio
Desirable Technologies:
- CI/CD Pipelines
- Azure SQL
- Azure Data Factory