BI Analyst

Cactus Search; Glasgow; On-site; GBP 40,000 - 55,000; Full time

Job summary

A leading company in Glasgow is seeking a skilled SQL Developer to shape the strategic operating model of their data department. The ideal candidate will oversee the design and implementation of an enterprise-wide Data Warehouse solution, ensuring high-quality ETL processes and accurate reporting through Power BI. This role requires strong technical expertise and a minimum of 5 years' experience in a similar position.

Qualifications

• Minimum 5 years’ experience as SQL Developer or similar role.
• Excellent understanding of ETL concepts and Microsoft SQL Server.

Responsibilities

• Manage and deliver ETL development using SSIS.
• Produce reports and dashboards using Power BI.
• Liaise with client contacts to gather MI requirements.

Skills

SQL

ETL

Power BI

Problem Solving

Job description

This position is instrumental in shaping the strategic operating model of our clients data department. The ideal candidate will possess strong technical expertise and oversee the entire design and implementation of the enterprise-wide Data Warehouse solution. Responsibilities include gathering and analysing requirements, designing and developing ETL processes, building the Data Warehouse, and creating and deploying Power BI dashboards and reports.

You must be commutable to Glasgow. Applications outside of Scotland will not be considered unfortunately

Duties:

• Manage and deliver ETL development using SSIS, in accordance with relevant processes and quality requirements
• Develop, implement and optimise SQL queries, procedures, functions, views, triggers
• Test, deploy and maintain SQL projects and fixes in line with best practice
• Produce reports and dashboards using Power BI, reviewing and validating data to ensure reports and dashboards are accurate
• Support business users in adopting and engaging with data department outputs
• Liaise with client contacts to gather and implement MI requirements as part of new business implementations

Experience:

• Minimum 5 years’ experience as SQL Developer or similar role
• Excellent understanding of ETL concepts, Microsoft SQL Server and T-SQL programming
• Experience in developing visualisations using Power BI
• Demonstrable understanding of the concepts for designing and implementing data warehouse solutions
• Understanding of Kimball Methodologies
• Critical thinker with problem-solving skills
• Experience with cloud technologies and data science approaches would be advantageous.