BI Developer

TN United Kingdom; Glasgow; On-site; GBP 45,000 - 75,000; Full time

Job summary

An established industry player is seeking a skilled SQL Developer to shape the strategic operating model of their data department. This role involves overseeing the design and implementation of an enterprise-wide Data Warehouse solution. You will be responsible for gathering requirements, developing ETL processes, and creating insightful Power BI dashboards. If you have a strong technical background and a passion for data, this opportunity offers a chance to make a significant impact in a dynamic environment.

Qualifications

• 5+ years experience as SQL Developer or similar role.
• Strong understanding of ETL concepts and Microsoft SQL Server.

Responsibilities

• Manage and deliver ETL development using SSIS.
• Produce reports and dashboards using Power BI.

Skills

SQL Development

ETL Concepts

T-SQL Programming

Power BI

Data Warehouse Design

Problem-Solving Skills

Tools

SSIS

Microsoft SQL Server

Power BI

Job description

Social network you want to login/join with:

This position is instrumental in shaping the strategic operating model of our client's 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 analyzing requirements, designing and developing ETL processes, building the Data Warehouse, and creating and deploying Power BI dashboards and reports.

Duties

1. Manage and deliver ETL development using SSIS, in accordance with relevant processes and quality requirements
2. Develop, implement, and optimize SQL queries, procedures, functions, views, triggers
3. Test, deploy, and maintain SQL projects and fixes in line with best practices
4. Produce reports and dashboards using Power BI, reviewing and validating data to ensure reports and dashboards are accurate
5. Support business users in adopting and engaging with data department outputs
6. 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 visualizations using Power BI
• Demonstrable understanding of 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.