Business Intelligence Analyst

About the Role

The Business Intelligence Analyst is a technically focused role responsible for developing and maintaining the College’s business intelligence infrastructure, supporting the delivery of high-quality data, reporting, and recommendations. Working under the direction of the Lead Business Intelligence Analyst, the post holder plays a key role in building and maintaining data pipelines, writing SQL queries, and developing Power BI dashboards that provide actionable insights to inform strategic and operational decision-making.

Key Responsibilities

Please refer to the job description which details the full description of the key

responsibilities and activities.

Qualifications and Experience

Essential:

o Educated to degree level or with demonstrable relevant professional experience at SCQF level 9 or above. (Preferably in Computer Science, Data Analytics, or a related field.)

o Experience in developing and maintaining dashboards and reports using Power BI or equivalent business intelligence tools

o Experience writing complex SQL queries and managing large, relational datasets across multiple sources.

Desirable:

o Professional qualifications (e.g. Microsoft certification)

o Awareness of Agile and Service Design methodologies

o Excellent understanding of the education sector

Skills and Attributes

Essential:

o Ability to work with complex data to uncover patterns, trends, and insights that support informed decisions.

o Proficiency in Power BI and SQL, with knowledge of data modelling, data transformation, and dashboard development.

o Ability to communicate technical concepts and insights clearly to both technical and non-technical stakeholders.

Interview Process

Interviews are scheduled to take place on Wed 04 March and/or Thursday 5 March at our Dunfermline City campus. Your interview will include a Task followed by a panel interview.

We look forward to receiving your application and potentially welcoming you to our team