BI Consultant Specialist

Dufrain; City of Edinburgh; Hybrid; GBP 50,000 - 90,000; Full time

Job description

We are Dufrain, a pure-play data consultancy specialising in helping businesses unlock the true value of their data by providing market-leading data solutions and services which includes developing strategies for AI readiness, improving data literacy and enhancing real-time reporting.

At Dufrain we prides ourselves on a creative and innovative approach, focusing on delivering exceptional outcomes for clients by leveraging data to drive growth and efficiency.

Our mission is to inspire, shape and deliver the data capabilities of tomorrow.

We have a great opportunity for an expert BI Consultant Specialist to play a pivotal role in shaping BI strategy, mentoring delivery teams, driving platform adoption, and ensuring high-quality outcomes for our clients.

Key responsibilities of the BI Consultant Specialist

• Lead end-to-end delivery of complex BI solutions, ensuring technical excellence, strategic alignment, and measurable business value.
• Support and develop BI teams, fostering a culture of collaboration, continuous learning, and high standards.
• To shape and influence client BI strategies, advocating best practices in data modelling, governance, and adoption.
• Facilitate requirements workshops and design sessions, engaging both technical and non-technical stakeholders to co-create solutions.
• Shape and deliver curated, performance-optimized gold-layer data models using technologies such as Microsoft Fabric and Databricks
• Take ownership of key deliverables, including curated BI-centric data models, working alongside Data Engineers and Architects using leading technologies
• Own and drive delivery plans, structuring high-quality work, managing risks and dependencies, and communicating effectively with seniorstakeholders to ensure alignment with strategic goals.

The role will also involve, but is not limited to:

• Supporting revenue generation and brand building activity, including presenting demos to external stakeholders and scoping client needs to support the commercial process.
• Delivering tailored Power BI training across all user personas—from Consumers to advanced Developers—ensuring learning is relevant, practical, and engaging.

Experience: Essential

• 5+ years of experience in a Business Intelligence role (some of which should be in a consulting position.
• Proven experience leading the design, implementation, and optimisation of Power BI solutions.
• Advanced capability within Power BI modelling, including optimisation of Power Query and advanced DAX.
• Ability to mentor and lead teams
• Strong understanding of relational databases, SQL, and data modelling concepts in a BI environment
• Strong desire to learn and adapt to new technologies

Experience: Desirable

• Proven experience shaping and implementing Power BI Governance and Adoption strategies, including frameworks across people, process, and technology.
• Passion for BI community engagement, with interest in speaking at industry events, contributing to thought leadership, and maintaining an active presence on social media.
• Hands-on experience with Microsoft Fabric, including working with Lakehouses, Dataflows Gen2, Notebooks, and Pipelines to support modern, end-to-end BI solutions.

What we offer you

You can expect guaranteed investment to your personal development. We have a working culture that rewards high performance and nurtures talent, while providing exciting opportunities and challenges to generate positive change for our clients.

Benefits

• Competitive base salary
• Annual Performance related bonus
• Hybrid home/onsite/office working
• 25 days annual leave (plus bank and public holidays)
• Birthday day off – celebrate with an extra holiday
• Career pathway programme
• Guaranteed learning and development investment, access to Udemy and your own career coach
• Life insurance
• Private medical health insurance
• Contributory pension
• Health and wellbeing group

What to do next

If you’re passionate about data, and you’re looking to join a leading data and analytics company based in the UK, you could find your dream role at Dufrain. Apply to join us in our quest to get busy living and make a difference.

Once your application has been received a representative from the Dufrain Recruitment team will review your profile and inform you of the next steps.

Please note: The recruitment process will require any candidates that are shortlisted to complete an online technical assessment.

Dufrain offers a diverse, inclusive and engaged culture. A place where people can bring their whole selves to work and be respected for who they are, valued for what they do and celebrated for their contribution to our business and our community.

We are an equal opportunity employer and opposed to discrimination on any grounds. It is the policy of Dufrain to ensure equal employment opportunity without discrimination or harassment on the basis of race, religion, age, sex, sexual orientation, gender identity or expression, marital or domestic/civil partnership status, disability, pregnancy and maternity or any other basis protected by law.

We want to make sure no one is put at a disadvantage during the recruitment process because of a disability, condition or impairment. To assist you with this, we will reduce or remove any barriers where possible and provide additional support where appropriate.

If you need a change to be made so that you can make your application, you should contact one of our Talent Acquisition team members as soon as possible to discuss your needs.