The Senior Data Engineer we are looking for is highly experienced in their field and should have an excellent working knowledge of SSRS, SSIS and SSAS in a SQL Server 2008 R2 & onwards environment. They will be responsible for the design, development and delivery of full data solutions using the Microsoft BI stack. They must have strong T-SQL skills and hold experience of developing and maintaining in creating SSRS reports and using data visualisation tools such as Power BI. They will also hold experience of developing and maintaining Data Warehouses and performance dashboards. Strong skills in creating SSRS reports and an exposure to data visualisation tools such as Power BI are also a requirement.
As the Senior Data Engineer, you will have gained experience in a variety of different tools and implementations and can make informed choices and influencing key project decision making. You must have extensive experience of working within a team and be able to demonstrate an aptitude to teach and mentor colleagues to a satisfactory level of understanding as well as leading by example and being a role model to more junior members of the team.
Key Accountabilities:
- Lead the design and development of data solutions across the company.
- Drive delivery and maintenance of performance dashboards to operational teams to ensure business access to essential data.
- Drive delivery and maintenance of SSRS reports to ensure business access to essential MI/BI.
- Lead in the design and development of innovative solutions using Power BI.
- Define, update, and adhere to software development patterns and standards.
- Provide technical assistance, support, and development skills across the company.
- Liaise with 3rd party software providers throughout the lifecycle – including design, development, support, and maintenance, ensuring best practise.
- Mentor and coach less experienced MI/BI colleagues.
- Lead by example, being a role model to more junior members of the team.
Essential Skills and Attributes:
- Highly numerate with previous experience in delivering BI reporting solutions.
- Expert T-SQL skills are essential.
- Strong understanding of data warehousing, ETL and database concepts.
- Strong experience of Microsoft BI technologies.
- Experience in delivering complex reporting solutions.
Essential Technologies:
- Microsoft stack
- SQL Server
- SSIS
- SSRS
- Power BI
- TFS/Visual Studio