BI Lead

Vaultex UK Ltd; Warrington; Hybrid; GBP 50,000 - 80,000; Full time

Job summary

Join a forward-thinking company as a BI Lead, where you will shape the Enterprise BI and Data warehouse estate. This hybrid role combines on-prem and cloud technologies, focusing on the Microsoft stack including Azure and Power BI. You will design, develop, and maintain robust data solutions while collaborating with cross-functional teams to drive data-driven decisions. With a strong emphasis on innovation, you will lead a talented BI team, ensuring stability and service excellence. Enjoy a supportive work culture that values your contributions and offers numerous benefits, including a generous pension and learning opportunities.

Benefits

Generous company pension

Competitive holiday allowance

Group life assurance

Group income protection

Employee Assistance Programme

Learning and Development opportunities

Performance-based yearly bonus

Paid volunteering opportunity

Mentorship programmes

VaulteXtra discounts

Qualifications

• Experience in designing and implementing BI solutions using Azure and Power BI.
• Strong SQL skills and experience with data modelling and ETL processes.
• Ability to lead a BI team and manage performance effectively.

Responsibilities

• Develop and maintain BI solutions and data pipelines on Azure.
• Collaborate with stakeholders to gather requirements and deliver solutions.
• Manage the BI team and ensure high service levels for data services.

Skills

Azure Data Factory

SQL programming

Power BI data modelling

ETL/ELT frameworks

Data warehousing concepts

CI/CD pipelines

Education

Bachelor's degree in Computer Science or related field

Tools

Azure SQL Database

Azure Synapse Analytics

SSIS

SSAS

Job description

Who we are

Vaultex are the UK’s leading cash processing company, with sites nationwide. When you join us, you are supporting businesses to run securely and more efficiently, and ensuring continued access to cash for the millions of people that depend on it. To find out more you can visit our website.

• Hours: Monday to Friday 09:00 - 17:00 - 35 hours per week
• Grade: CM40
• Location: Hybrid role, 104 Dalton Ave, Birchwood, Warrington, WA3 6YF & Remote
• Salary available on request

Out of hours support will be required for this role - this is done on a rota basis.

Job Purpose

The BI Lead will be responsible for shaping and maintaining the Enterprise BI and Data warehouse estate. You'll be working with both on-prem and cloud technologies, predominantly focussed on the Microsoft stack (SQL/Azure SQL databases, Data Factory, Synapse, Power BI, Power Platform)

You will play a critical role in designing, developing, implementing and maintaining robust data solutions on the Azure and Power BI platforms. You will collaborate closely with cross-functional teams to gather requirements, understand business objectives, and translate them into scalable and efficient data pipelines and reporting suites. Your expertise will be instrumental in establishing best practices and guiding the development of our data infrastructure to support our long-term data strategy.

In addition, the role will be pivotal to understanding the direction of the Data and BI platform and technologies going forward, to give Vaultex cutting edge in the industry.

Furthermore, the role will be responsible for the BI employees within the team from a management and performance perspective. The BI Lead will oversee and drive the team’s deliveries, along with ensuring a high level of stability and service to the business from the Data and BI services.

Main responsibilities:

• Developing quality Business Intelligence software solutions
• Planning, design and documentation
• Supporting solutions in production
• Maintaining SDLC & CI/CD solutions to support continuous delivery of software through development, test and production environments
• Spearhead engagement between business stakeholders and the BI function
• Line Management of the BI team members
• Personal development (new technologies, performance management…)

Knowledge, skills and experience required:

• Responsible for the design & implementation of technical delivery for the BI team
• Collaborate with Enterprise/Solution Architects to ensure data solutions are delivered to the appropriate standards and quality
• Lead the data team working with our vendor partners as appropriate, ensuring work is planned and prioritised accordingly
• Design, build, and optimize data pipelines and ETL processes on the Azure platform, ensuring data quality, reliability, and scalability
• Design, implement and maintain a variety of Power BI reports and models in line with business needs
• Guide and facilitate BI Analyst/BI Developer roles to gather requirements and translate into technical solutions
• Collaborate with stakeholders to understand business requirements, translate into technical specifications and communicate delivery timelines
• Develop and maintain data models, data architectures, and data dictionaries to support efficient data storage and retrieval
• Implement data governance and security measures to ensure compliance as agreed with data architecture
• Monitor and optimise data workflows and processes to improve performance, reliability, and efficiency
• Identify and evaluate new technologies, tools, and frameworks to enhance data infrastructure and drive innovation
• Collaborate with cross-functional teams to define data strategy, contribute to the development of data roadmaps, and drive data-driven decision making across the organisation
• Stay up to date with the latest trends, advancements, and best practices in BI, data engineering and cloud technologies, particularly within the Azure ecosystem
• Provide third line support on our production systems, in collaboration with our vendor partners
• Expand the usage of Power BI for internal and external stakeholders as a leading solution for data visualisation/reporting
• Management of people with the BI team, including performance, pastoral, training and coaching

Technical Skills:

• Strong experience of Azure services such as Azure Data Factory, Azure Data Lake Storage, Azure SQL Database, and Azure Synapse Analytics, Logic Apps
• Strong SQL programming skills
• Strong experience with Power BI data modelling and reporting, including setting up/maintaining Power BI premium capacity workspaces tailored to business needs/security requirements
• Proficient in designing and building data pipelines using ETL/ELT frameworks, data integration tools, and technologies, inclusive of legacy technologies such as SSIS and SSAS
• Experience with data modelling, schema design, and data warehousing concepts
• Experience in unit testing, producing and reviewing clean/maintainable code and other software engineering best practices.
• Experience setting up and maintaining CI/CD pipelines (Azure DevOps or similar)

What we offer you

We are a Living Wage employer with Investors in People Platinum status, and as such have a great range of benefits:

• A generous company pension – auto-enrolled 4% employee 10% employer
• Competitive holiday allowance with an option to purchase additional holidays (varies by grade)
• Group life assurance 4 x salary
• Group income protection
• VaulteXtra discounts on retailers, cycle to work, childcare vouchers, gym membership, cash back on purchase, eye tests and many more.
• Employee Assistance Programme – a free service should our employees require professional and impartial advice for legal advice and counselling.
• Robust Learning and Development team and opportunities for career progression.
• Performance based yearly bonus (grade dependant)
• One day paid volunteering opportunity each year
• Mentorship programmes

Our culture

Vaultex acknowledges every person’s right to feel valued, respected, and fairly rewarded for what they do. We foster a collaborative environment where everyone is encouraged to share their views and shape Vaultex’s future. We are proud to demonstrate our commitment to transparency and progress as a Work180 Endorsed Employer.

Continue the conversation

Vaultex UK Ltd is an equal opportunities employer and welcomes applications from all members of the community. If you require any reasonable adjustments throughout the recruitment process, please let us know.

Upon submitting your application via the Workday link, you will receive an email notifying you of the outcome of your application when this has been reviewed. For successful candidates, the next stage will be a phone interview with the Vaultex recruitment team. If you would like to check the status of your application, please contact a member of the recruitment team.

Due to the secure nature of our business, all successful candidates will need to provide a five-year traceable work history (satisfactory employment references or evidence to explain employment gaps) and complete a criminal record and credit background check.

We look forward to hearing from you!