BI Developer

Job Introduction

Established in 1887, William Grant & Sons is an independent, family owned distiller with Scottish roots and a global reach. A new opportunity has arisen for a BI Developer with the GTS organisation in our team in Cumbernauld. 

The BI Developer will be responsible for providing technical expertise in designing, developing and delivering a BI technology platform that will support core business activities and decision making aligned to the WG&S Corporate GTW strategy.

Main Responsibility

• Capture, review and validate reporting requirements translating these into technical requirements to
• the required standard aligned to the WGS Corporate GTS strategy
• Develop and maintain documentation (i.e. Report Design Specifications, Testing templates, etc.) to
• enhance internal processes and drive continuous improvement
• Review and validate customer data, overseeing the deployment of data to the data warehouse in line with timescales
• Support the promotion of new content throughout the development lifecycle in line with business
• requirements
• Perform system analysis on deployed solutions ensuring these align with business requirements and reporting governance principles
• Contribute to the continuous improvement in process, performance, productivity and quality in line with business standards
• Train end-users to ensure proficiency with new solutions across multiple business functions
• Contribute to and champion the ongoing BI Strategy alongside Business Leaders encouraging end user engagement
• Proactively share knowledge with other team members, updating and documenting procedures to the required standard
• Provide end-to-end system support for relevant BI applications including but not limited to ensuring support calls are closed within service level targets and system uptime meets agreed business targets

Our Ideal Candidate

• Degree qualified (IT Specialism) or equivalent industry experience within a dynamic, commercial IT environment
• Comprehensive hands-on experience in Business Intelligence development and delivery using the Microsoft BI stack, especially SSIS and SSRS Experience
• Strong knowledge of T-SQL / DAX with exposure to enterprise level BI & SQL environments
• Demonstrates excellent problem solving and analytical skills
• Good understanding of data warehousing concepts
• Strong communication skills with the ability to communicate technical concepts to a diverse audience
• Knowledge of Database Administration, Software Development Lifecycles, Technical Infrastructure, and IT Service Management

What we can offer you

• We offer a competitive salary and benefits which are designed to promote our employees financial wellbeing. Employees are also eligible to participate in a bonus plan.
• Our employees enjoy a generous holiday entitlement and an opportunity to ‘buy’ or ‘sell’ some holiday entitlement.
• Private Healthcare and Doctor@Hand (remote GP service).
• Our employees can join a defined contribution pension plan. Employees contribute either 4% or 5% of salary, the company contributes 8% or 10% depending on the employee contribution. Employee contributions can be made through salary sacrifice.
• Our Employee Assistance Programme offers practical, impartial support on everyday matters ranging from medical, financial and legal to home and family issues. 
• Our Life Assurance cover is a multiple of eight times your annual basic salary.
• Product allocation so that you can enjoy our fantastic portfolio of brands.
• Our Cycle to Work scheme allows you to hire a bike for an agreed length of time, and then snap it up for a fraction of its original value. All while making savings (at least 25%) and spreading the cost.
• Every employee has the opportunity to claim up to £1,000 per year for a charity or charities for which they have raised money, volunteered their time or personally donated.
• Learning resources to help you be your best self.

About William Grant & Sons

A HOME FOR RARE CHARACTERS

William Grant & Sons: a home where Rare Characters thrive.

We value every employee for their rare character, distinctive skills, experience and perspectives. Every one of our colleagues has a role to play in helping us to achieve our growth ambitions.

At William Grant & Sons, our vision is to be A home where rare characters thrive. We value all colleagues for their rare character, distinctive skills, experience and perspectives. Diversity & Inclusion is at the heart of how we do things at William Grant & Sons, fully aligned to our purpose and our company values. We strive to create an environment where we can all be our best and bring our whole selves to work.

OUR AGILE WORKING PHILOSOPHY

Our agile working philosophy is to “Have your best work day everyday”.
Built on trust, we empower our rare characters to have their best work day every day. Where flexibility and positive working experiences help employees to feel connected and release potential across our teams.
We are open to discussing possible agile/flexible working options as part of the recruitment process.

INCLUSIVE RECRUITMENT PROCESS

Diversity & Inclusion is at the heart of how we do things at William Grant & Sons, fully aligned to our purpose and our company values. We want to ensure that our recruitment process is inclusive. 

We want to make sure that all applicants are treated equally. To support this we will anonymise all applications during the screening stage. Details such as name, dates and educational establishments will only be visible to the recruitment team and hiring leader once an applicant is invited to interview, these details are hidden during the screening stage. To be able to anonymise applications they all need to be in the same format. You can upload a CV but we would also ask you to complete an application form – your CV will not be visible during screening. We hope you agree that this is good use of your time to help ensure a fair recruitment process.