BI Analyst

Cactus Search

Posted 10 hours ago, valid for 17 days

Glasgow, City of Glasgow G62 6EP, Scotland

Full Time

In order to submit this application, a Reed account will be created for you. As such, in addition to applying for this job, you will be signed up to all Reed’s services as part of the process. By submitting this application, you agree to Reed’s Terms and Conditions and acknowledge that your personal data will be transferred to Reed and processed by them in accordance with their Privacy Policy.

Sonic Summary

This position is crucial for shaping the strategic operating model of the clients' data department.
The ideal candidate should have a minimum of 5 years of experience as a SQL Developer or in a similar role, with strong technical expertise in ETL processes and Microsoft SQL Server.
Key responsibilities include managing ETL development using SSIS, optimizing SQL queries, and producing reports and dashboards using Power BI.
Candidates must be commutable to Glasgow, as applications from outside Scotland will not be considered.
The role offers a competitive salary, though the specific amount is not mentioned in the 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 implementationsExperience:• 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.

Apply now in a few quick clicks

BI Analyst

Contract Data Analyst Looker BI

Data Business Analyst

Business Analyst / Architect