Business Intelligence Architect

Are you ready to take the technical lead in our innovative data and analytics initiatives?
In this role, you will oversee the design and implementation of transformative BI solutions and comprehensive data strategies.
You'll collaborate with internal teams and external partners to ensure our data reporting and analytics are outstanding.
Additionally, you'll mentor colleagues and ensure our reporting adheres to governance and control standards.
Your leadership will be key to advancing our data platform to new essential in elevating our data platform to the next level.
Do you want a career within a business that is not driven by profit, but by providing excellent service?
A career within a business that is sustained by a genuine community, with everyone coming together to support each other.
A career with an amazing history and a bright future?
The Benenden Health office is based in York and whilst there will be an opportunity to work from home, this role is offered on a hybrid basis and there will be a requirement to work from the office 1 day per week, salary on or around £70,000 We are looking for people who see Benenden Health as a career choice and are focused on maximising their potential in an organisation that promotes training, development, volunteering opportunities and personal achievement.
Reporting to the Head of Applications and Reporting the post holder will: Design and Implement BI Solutions: Lead the creation and deployment of complex BI solutions using Microsoft Azure Synapse Analytics and Power BI.
Technical Leadership and Mentorship: Provide guidance, mentorship, and governance to project teams and developers.
Governance Frameworks: Establish and maintain governance frameworks for reporting to ensure accuracy and reliability.
Collaboration with Business Leaders: Work with senior business leaders to translate their needs into effective technical solutions.
Emerging Technologies: Act as a technical leader in emerging BI technologies and AI-based solutions.
Data Strategy Development: Develop and implement broader data strategies to support organizational goals.
Integration: Ensure the integration of BI solutions with other data systems and platforms.
We're keen to hear from candidates with the following skills and experience: Enterprise BI Solutions: Proven experience in delivering enterprise-level BI solutions.
BI Tools Mastery: Expertise in using BI tools like Power BI and Tableau.
Advanced SQL: Strong skills in SQL and experience with database management systems (e.g., SQL Server, Oracle).
ETL Processes: Proficiency in ETL processes and tools.
Data Warehousing: In-depth knowledge of data warehousing concepts and architecture.
Data Modelling: Experience in data modelling and designing complex data structures.
Communication: Excellent skills in collaborating with senior stakeholders and presenting data insights.
Project Experience: Ability to work across multiple high-impact projects and prioritize tasks effectively.
Mentorship: Strong mentoring abilities to support and guide colleagues.
Governance: Understanding of governance frameworks and ability to implement reporting controls.
Third-Party Collaboration: Experience in leading and working with third-party partners.
Strategic Thinking: Strong strategic thinking and problem-solving skills.
This role is working 37.5hours per week, Monday to Friday 9am - 5pm, salary At or around £70,000 The Benenden Health office is based in York and whilst there will be an opportunity to work from home, this role is offered on a hybrid basis and there will be a requirement to work from the office 1 day per week Free Corporate Benenden Health membership Free Corporate Benenden Cash plan (helps towards Dental, optical and complimentary therapies) Free onsite car parking Up to 35 days' holiday including bank holiday and no weekend or bank holidays working.
Pension with up to 10% employer contributions Discount available on other Benenden products Employee Assistance Program Unlimited access to £500 Refer a Friend Bonus Scheme Discount and cash back on hundreds of high-street retailers Opportunity for hybrid working Excellent training and career progression opportunities Cycle to work scheme Free hot drinks Free fruit Employee engagement events Supporting local charities Onsite First Aiders and Mental Health First Aiders Free onsite gym For further information on this role, please refer to the Role Profile.
We will be considering and interviewing candidates as they apply.
We will close the position when we have the successful candidate, so please don't delay in submitting your application.