Summary: The role of a BI Engineer involves designing, developing, and delivering comprehensive BI solutions using the Microsoft BI stack. The position requires strong T-SQL skills, experience with data warehousing, and proficiency in creating reports and dashboards using tools like SSRS and Power BI. The BI Engineer will also mentor team members and collaborate with business stakeholders to capture requirements and enhance reporting capabilities. This is a 9-month fixed-term contract based in the UK.

Key Responsibilities:

• Responsible for the design and development of BI solutions across the company.
• Deliver and maintain performance dashboards to operational teams to ensure business access to essential BI.
• Deliver and maintain SSRS reports to ensure business 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.
• Mentor and coach less experienced MI/BI colleagues.

Key Skills:

• 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.
• Microsoft stack.
• SQL Server 2008/12/16.
• SSIS.
• SSRS.
• Power BI.
• SQL Server Unit Tests.
• Azure DevOps.
• Visual Studio.
• CI/CD Pipelines (desirable).
• Azure SQL (desirable).
• Azure Data Factory (desirable).

Salary (Rate): undetermined

City: London

Country: United Kingdom

Working Arrangements: undetermined

IR35 Status: fixed-term

Seniority Level: undetermined

Industry: IT