6-month FTC BI Engineer

6-month FTC BI Engineer

Department: IT

Employment Type: Fixed Term - Full Time

Location: Home United Kingdom

Description

As a BI Developer you will be involved in the design, development and delivery of full BI solutions using the Microsoft BI stack. You will have strong T-SQL skills and Performance Dashboard development and hold experience of developing and maintaining Data Warehouses. You will also have strong skills in 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 Keoghs 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 and influencing key project decision making.

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.

Skills, Knowledge & Expertise

Performance Competencies

• 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. 

Technologies  

Essentials: 

• Microsoft stack
• SQL Server 2008/12/16
• SSIS
• SSRS
• Power BI
• SQL Server Unit Tests
• Azure DevOps 
• Visual Studio

Desirable:

• CI/CD Pipelines
• Azure SQL
• Azure Data Factory

Job Benefits

• Davies Incentive Plan
• 25 days holiday per year which increases with level of service (opportunity to buy & sell 3 days)
• Family Cover Private Medical Insurance (Bupa) - will automatically be at single cover level but can opt into family option within first month of joining
• Simply Health Care Cash Plan
• WeCare – 24/7 online GP, mental health support and virtual wellbeing covering a whole host of topics to do with health, mental health, wellbeing & healthy living and financial & legal wellbeing 
• Death in Service
• Critical Illness Cover
• PHI/Income Protection (Private health insurance)
• Pension Contribution based 5% Employee / 3% Employer 
• Cycle to Work Scheme*
• Tech Scheme*
• Season Ticket Loan*
• Gym Flex*
• Access to Online Discount Sites
• Discounted Gourmet Society Membership
• Discounted Tickets for Merlin Attractions nationwide
• Discounts at local retail outlets

* after successfully completing probation