Bi Analyst

Reed; Exeter; On-site; GBP 40,000 - 60,000; Full time

Job summary

A leading recruitment consultancy is seeking a talented Business Intelligence Analyst to join their team in Exeter. This role involves designing BI solutions, optimizing Azure SQL queries, and creating insightful reports using Power BI. The ideal candidate will have proven experience in BI analysis, strong skills in Azure SQL and Power BI, and excellent problem-solving abilities. A competitive salary and benefits package is offered.

Qualifications

• Proven experience as a BI Analyst or similar role.
• Strong proficiency in Azure SQL including query optimization.
• Advanced skills in Power BI for data modeling and visualization.

Responsibilities

• Design and maintain BI solutions using Power BI.
• Optimize queries in Azure SQL to transform data.
• Collaborate with stakeholders for insight generation.
• Ensure data accuracy and security in BI processes.
• Support data-driven decision-making with analysis.

Skills

Strong experience with Azure SQL

Advanced skills in Power BI

Excellent problem-solving skills

Communication skills

Tools

Azure SQL

Power BI

Azure Data Factory

Python

R

Job description

About the Role

We are seeking a talented Business Intelligence Analyst to join our growing team. This role is perfect for someone who thrives on turning data into actionable insights and has strong experience with Azure SQL and Power BI.

Key Responsibilities

• Design, develop, and maintain BI solutions using Power BI.
• Write and optimize queries in Azure SQL to extract and transform data.
• Collaborate with stakeholders to understand business requirements and deliver insightful dashboards and reports.
• Ensure data accuracy, integrity, and security across all BI processes.
• Support data-driven decision-making by providing clear analysis and recommendations.

Skills & Experience Required

• Proven experience as a BI Analyst or similar role.
• Strong proficiency in Azure SQL (including query optimization and stored procedures).
• Advanced skills in Power BI (data modeling, DAX, visualization best practices).
• Understanding of data warehousing concepts and ETL processes.
• Excellent problem-solving and communication skills.

Desirable

• Experience with Azure Data Factory or other cloud-based data tools.
• Knowledge of Python or R for advanced analytics.