Senior BI Analyst – Hybrid Power BI & Data Warehouse Lead

Farrow & Ball Ltd.; Wimborne Minster; Hybrid; GBP 55,000 - GBP 75,000; Full time

Job summary

A luxury British lifestyle brand is seeking a knowledgeable Lead Business Intelligence Analyst to join their IT team in Wimborne, Dorset. This hybrid role requires a professional with extensive experience in ETL processes and SQL Server. Responsibilities include maintaining the reporting estate, developing Power BI models, and ensuring data quality. Candidates should be skilled in SQL tuning and have a proven background in data warehousing. Competitive benefits and opportunities for professional growth are offered.

Benefits

25 days’ annual leave

Annual salary reviews

Generous staff discount

Qualifications

• Hands-on experience with SSIS and ETL processes.
• Proficiency in SQL Server performance tuning.
• Experience creating reports and dashboards in Power BI.

Responsibilities

• Monitor and maintain ETL processes and SQL Server Agent jobs.
• Develop and maintain SSIS-based ETL solutions.
• Build and maintain Power BI enterprise semantic models.

Skills

Hands-on SSIS and traditional ETL experience

Strong SQL performance tuning skills

Enterprise Power BI development experience

Collaborative and service-oriented

Tools

Power BI

SQL Server

Azure Data Factory

Job description

A luxury British lifestyle brand is seeking a knowledgeable Lead Business Intelligence Analyst to join their IT team in Wimborne, Dorset. This hybrid role requires a professional with extensive experience in ETL processes and SQL Server. Responsibilities include maintaining the reporting estate, developing Power BI models, and ensuring data quality. Candidates should be skilled in SQL tuning and have a proven background in data warehousing. Competitive benefits and opportunities for professional growth are offered.