Business Intelligence Consultant - Power BI & SQL
Business Intelligence Consultant - Power BI & SQL

Business Intelligence Consultant - Power BI & SQL

Full-Time 36000 - 60000 ÂŁ / year (est.) Home office (partial)
Free-Work UK

At a Glance

  • Tasks: Lead and deliver impactful Power BI projects for diverse clients.
  • Company: Specialist software implementation company focused on business systems.
  • Benefits: Competitive salary, ongoing training, and career progression opportunities.
  • Why this job: Shape data-driven decisions and unlock the value of client data.
  • Qualifications: Experience in BI projects, strong Power BI and SQL skills.
  • Other info: Collaborative environment with a focus on professional development.

The predicted salary is between 36000 - 60000 ÂŁ per year.

We are a specialist software implementation company delivering end‑to‑end business systems, with a strong focus on Sage 200 and complementary technology solutions. As we continue to expand our analytics offering, we’re looking for a Business Intelligence Consultant who can help our customers unlock the full value of their data through high‑quality Power BI solutions. If you enjoy working directly with clients, shaping requirements, and delivering impactful BI projects, this role offers the variety and autonomy you’ll appreciate.

As a Business Intelligence Consultant, you will lead and deliver Power BI projects for external customers, working across a wide range of industries. You’ll be responsible for understanding client needs, designing robust data models, and producing insightful dashboards that support better decision‑making. You’ll collaborate closely with our Sage 200 implementation team, helping customers extend their system with meaningful analytics and reporting.

Key Responsibilities
  • Deliver end‑to‑end Power BI projects for external clients, from requirements gathering to deployment.
  • Design and build Power BI dashboards, data models, and interactive reports tailored to customer needs.
  • Develop efficient SQL queries, stored procedures, and ETL processes to support reporting and integration.
  • Work with Sage 200 and other business systems to extract, transform, and model data.
  • Run workshops, gather requirements, and translate business needs into technical solutions.
  • Provide training, documentation, and ongoing support to customers.
  • Advise clients on BI best practices, data governance, and reporting strategy.
About You Skills and Experience:
  • Proven experience delivering BI or reporting projects in a client‑facing or consultancy role.
  • Strong expertise in Microsoft Power BI, including DAX, Power Query, and data modelling.
  • Solid SQL skills and experience working with relational databases (SQL Server, Azure SQL, etc.).
  • Understanding of data warehousing concepts and ETL processes.
  • Experience working with Sage 200 data structures is highly desirable (but not essential).
  • Excellent communication skills and the ability to explain technical concepts to non‑technical users.
  • Strong problem‑solving skills and a proactive, customer‑focused mindset.
Benefits
  • The opportunity to work on diverse BI projects across multiple industries.
  • A supportive environment with close collaboration between BI and Sage 200 implementation teams.
  • Ongoing training and development in Power BI, SQL, and cloud data technologies.
  • Competitive salary, benefits, training and opportunities for career progression.

Please click the APPLY button to send your CV and covering letter for this role.

Business Intelligence Consultant - Power BI & SQL employer: Free-Work UK

As a leading specialist software implementation company, we pride ourselves on fostering a collaborative and innovative work culture that empowers our employees to thrive. With a focus on professional development and a commitment to delivering impactful BI solutions, our Hull-based team enjoys the flexibility of remote work while engaging in diverse projects across various industries. Join us to unlock your potential and make a meaningful impact through data-driven insights.
Free-Work UK

Contact Detail:

Free-Work UK Recruiting Team

StudySmarter Expert Advice 🤫

We think this is how you could land Business Intelligence Consultant - Power BI & SQL

✨Tip Number 1

Network like a pro! Reach out to your connections on LinkedIn or attend industry meetups. We all know that sometimes it’s not just what you know, but who you know that can help you land that Business Intelligence Consultant role.

✨Tip Number 2

Show off your skills! Create a portfolio showcasing your Power BI dashboards and SQL projects. We want to see what you can do, so make sure to highlight your best work when chatting with potential employers.

✨Tip Number 3

Prepare for those interviews! Brush up on your technical knowledge and be ready to discuss how you’ve tackled client needs in the past. We recommend practising common interview questions related to BI and SQL to boost your confidence.

✨Tip Number 4

Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive about their job search!

We think you need these skills to ace Business Intelligence Consultant - Power BI & SQL

Power BI
DAX
Power Query
Data Modelling
SQL
Relational Databases
ETL Processes
Data Warehousing Concepts
Sage 200
Communication Skills
Problem-Solving Skills
Client-Facing Experience
Requirements Gathering
Technical Documentation

Some tips for your application 🫡

Tailor Your CV: Make sure your CV highlights your experience with Power BI and SQL. We want to see how you've delivered BI projects in the past, so don’t hold back on those details!

Craft a Compelling Cover Letter: Your cover letter is your chance to shine! Tell us why you’re passionate about business intelligence and how you can help our clients unlock their data’s potential. Keep it engaging and relevant!

Showcase Your Client-Facing Skills: Since this role involves working directly with clients, share examples of how you've successfully gathered requirements and delivered impactful solutions. We love seeing your communication skills in action!

Apply Through Our Website: Don’t forget to apply through our website! It’s the best way for us to receive your application and ensures you’re considered for this exciting opportunity. We can’t wait to hear from you!

How to prepare for a job interview at Free-Work UK

✨Know Your Power BI Inside Out

Make sure you brush up on your Power BI skills before the interview. Be ready to discuss your experience with DAX, Power Query, and data modelling. Prepare examples of dashboards you've created and be ready to explain the thought process behind your designs.

✨SQL Skills Are Key

Since SQL is a big part of this role, practice writing SQL queries and understand how to work with relational databases. You might be asked to solve a problem on the spot, so being comfortable with SQL Server or Azure SQL will definitely give you an edge.

✨Understand Client Needs

This role is client-facing, so show that you can gather requirements effectively. Think of past experiences where you successfully translated business needs into technical solutions. Be prepared to discuss how you would approach running workshops and engaging with clients.

✨Communicate Clearly

You’ll need to explain complex concepts to non-technical users, so practice simplifying your language. During the interview, demonstrate your communication skills by clearly articulating your thoughts and ensuring you engage with the interviewer. This will showcase your ability to connect with clients.

Business Intelligence Consultant - Power BI & SQL
Free-Work UK

Land your dream job quicker with Premium

You’re marked as a top applicant with our partner companies
Individual CV and cover letter feedback including tailoring to specific job roles
Be among the first applications for new jobs with our AI application
1:1 support and career advice from our career coaches
Go Premium

Money-back if you don't land a job in 6-months

>