BI Developer

Fenwick Limited; North East; Hybrid; GBP 40,000 - 60,000; Full time

Job summary

A leading retail department store is seeking a BI Developer to deliver robust data and Business Intelligence solutions. This role involves designing data models, building ETL pipelines, and collaborating with cross-functional teams to drive insights. The candidate should have experience in SQL, cloud platforms like Microsoft Azure, and tools such as Qlik or Power BI. The position offers hybrid working and competitive benefits including annual leave and employee discounts.

Benefits

33 days annual leave

Birthday leave

Up to 25% employee discount

Retail discounts and cashback offers

24/7 GP and wellbeing support

Qualifications

• Experience of hands-on Business intelligence development.
• Experience of building and maintaining data warehouses and data models.
• Knowledge of data lakes.
• Experience of working with data in cloud platforms.

Responsibilities

• Design cohesive data models and build efficient ETL pipelines.
• Collaborate with third-party partners to integrate external data sources.
• Ensure strong governance for data accuracy, performance, and security.

Skills

Hands-on Business intelligence development

Building and maintaining data warehouses

Strong SQL skills

Data warehousing skills

Microsoft BI technologies: SQL

Experience with Microsoft Azure

Data Lake knowledge

Dashboard tools: Qlik, Tableau

Analytical mindset

Problem-solving aptitude

Tools

SQL

SSIS

SSRS

Azure Data Factory

Snowflake

Power BI

Job description

Are you looking for a new challenge in an IT role? If so, we have an exciting opportunity for you to join our Business Intelligence team as a BI Developer!

We offer hybrid working between your home and our offices located within our flagship store in Newcastle.

When you join Fenwick, you’ll receive:

• 33 days annual leave (inclusive of 8 bank holidays) and a buying holiday benefits scheme in which you are eligible to buy a further 5 days across the year.

• Your birthday off as an additional day annual leave – this can be taken any day within your birth month.

• Up to 25% discount in all Fenwick stores and fenwick.co.uk.

• Perks - a great way to get Retail, Leisure & Hospitality discounts, exclusive deals, and cashback on a wide range of products.

• WeCare -24/7 GP, wellbeing advice & support service

• Hybrid working (Typically Monday-Wednesday working in-office and Thursday & Friday working from home)

About the role

As a BI Developer at Fenwick you’ll be at the forefront of delivering robust data and Business Intelligence solutions. You’ll work across the business to design cohesive data models, build efficient ETL pipelines, and ensure strong governance for accuracy, performance, and security.

Working closely with colleagues in Finance, Digital, Marketing, Buying & Merchandising, Retail, and Logistics, you’ll design and develop data solutions that drive insight and decision-making. This includes building new databases, data structures, and views, while collaborating with third-party partners to integrate external data sources. Operating within a DataOps framework, you’ll ensure continuous development, testing, and improvement.

We’re looking for someone with hands-on BI development experience, strong SQL and data warehousing skills, and a solid understanding of cloud-based data platforms, ideally Microsoft Azure and Snowflake. Experience with dashboard tools like Qlik, Tableau, or Power BI is an advantage, as is exposure to data science, AI, and Microsoft Dynamics 365.

What we are looking for in a candidate…

• Experience of hands-on Business intelligence development

• Experience of building and maintaining data warehouses and data models

• Knowledge of data lakes

• Microsoft BI technologies: MS Excel, SQL, SSIS, SSRS, Azure, Data Factory, Data Lake

• Experience of working with data in cloud platforms, particularly Microsoft Azure or Snowflake.

• Experience of building dashboards (e.g. Qlik, Tableau, Power-BI). Specific BI tool training will be provided.

• Analytical minded with a problem-solving aptitude

• Forward thinking vision and the ability to pay close attention to detail

• Ability to translate business needs to technical specifications

About Fenwick

Fenwick is rich with heritage and history and have been style pioneers since 1882 when our first store opened. We know luxury and are proud to remain the largest independent, family-owned group of department stores within the UK. We are on an exciting journey to exceed our customers' expectations and we are always on the lookout for new talent to join us.

Our collaborative spirit unites a workforce of over 2,000 individuals across our stores, as well as in our support functions, encompassing Digital, Buying & Merchandising, IT, Finance, People, Customer Service teams, and our cherished restaurants and distribution centres.

Together, we form the beating heart of Fenwick, driving forward our vision for excellence and innovation. Join us as we pave the way toward an even brighter tomorrow, where tradition meets transformation!