BI Solutions Architect

About The Role

We are currently looking to recruit a new Business Intelligence Solution Architect to our growing Data & Business Intelligence team. We are continuing to experience an exciting period of company growth, so it is a great time to join our team at our friendly Service Centre, where you will play a key role in helping to provide an outstanding level of customer and employee experience.

The BI Solution Architect plays a crucial role in designing and implementing scalable Business Intelligence (BI) solutions that align with business requirements. They work closely with stakeholders to translate business needs into innovative BI solutions, ensuring seamless integration, data modelling and performance optimisation. By staying updated with emerging trends and technologies, they drive the adoption of best practices and mentor the BI development team. Overall, the BI Solution Architect enables data-driven decision-making, enhances business performance, and maximises the value derived from data assets by delivering effective BI solutions.

Responsibilities:

Collaborate with stakeholders across the organisation to align technical solutions with strategic goals.
Design and develop the architecture and infrastructure of the BI system, including data warehouse structure, data integration processes and data modelling techniques.
Implement and optimise Extract, Transform, Load (ETL) processes for integrating data from various sources into the data warehouse.
Establish data governance policies, data protection mechanisms, and data retention policies to ensure data accuracy, consistency, and security.
Monitor system performance, identify bottlenecks, and optimise database queries for improved system efficiency.
Collaborate with stakeholders, gather requirements, and provide technical guidance to ensure the BI system meets the organisation’s needs.
Stay updated with industry trends, technologies, and best practices in business intelligence to recommend enhancements and optimise system functionality.
Mentor and provide leadership to team members, offering guidance, support, and opportunities for professional growth.
Create development plans for team members, assess their performance, and facilitate knowledge sharing within the team.
Participate in resource allocation and project management activities, ensuring projects are delivered within timelines and budgets.

What can we offer you in return? You’ll be joining a highly successful FTSE100 company, the UK’s largest equipment rental provider. We provide an Industry leading flexible rewards package including bonus, generous holiday allowance (with the opportunity to buy and sell annual leave), private medical and life assurance, retail discount scheme, employee recognition awards and a great Company pension scheme.

About You
If you join the team we’ll provide you with everything you need and ensure you are equipped for success. We’ll talk to you about your training and personal development needs and what you’d like to do to further your career and support your future aspirations.
To succeed in this role, you will need:

Strong understanding of Data Warehouse methodology and design, preferably with experience in Kimball methodology.
Proficient in Transact SQL (T-SQL) and possess a deep knowledge of relational databases.
Strong understanding of Extract, Transform and Load (ETL) processes using SQL Server Integration Services (SSIS).
Solid grasp of Analysis Services and Power BI Tabular Models, including proficiency in DAX expressions, measures, and KPIs. Familiarity with tools like Tabular Editor would be advantageous.
Good understanding of data security principles and experience in implementing methodologies such as Row Level Security.
Experience with source control systems, particularly Git, for managing code versioning, branching, and collaborative development.
Excellent communication, collaboration, and stakeholder engagement skills.
Experience working within medium to large-sized BI Development Teams.
Highly self-motivated with the ability to independently manage workloads and deliver changes to the BI Solution within agreed timescales.
Exceptional problem-solving skills, with the ability to analyse complex issues and identify effective solutions.
SQL Master Data Services (MDS) experience: Proficiency in using SQL Master Data Services desirable.

About Us
Sunbelt Rentals is the leader in equipment rentals in the UK, Ireland, US and Canada – as well as specialist operations in Europe. We provide a range of solutions to every market and sector, including construction, industrial, energy, infrastructure, government and events. Our teams make the impossible possible and the unthinkable doable. Turning what if into what is.
Our people are at the heart of our values and they’re our greatest asset. We rely on you to look after our customers so in return, we take good care of you. We recognise the value and uniqueness of our team-mates and are committed to creating a diverse and inclusive Sunbelt Rentals, providing equality of opportunity and a culture of fairness and respect.
Your health, safety and wellbeing is really important to us. We’re raising awareness and providing support through initiatives such as our mental health awareness campaign and first-aider programme. You’ll also be able to access a 24-7 employee assistance helpline, counselling services and financial wellbeing support.