Technical Analyst

Samworth Brothers Ltd; Leicester; On-site; GBP 80,000 - 100,000; Full time

Job summary

A family-owned food manufacturer in Leicester seeks a Business Intelligence Analyst to develop and enhance operational reporting. The ideal candidate will possess strong expertise in the Microsoft BI stack, including SQL, SSIS, SSAS, SSRS, and Power BI, and have the ability to integrate data from multiple systems. This role emphasizes collaboration and analytical skills, ensuring that data insights align with business needs. Join a thriving company committed to personal accountability and team excellence.

Benefits

Enhanced pension scheme

Private health scheme

Employee discount scheme

Annual pay reviews

Profit related pay

Training and growth opportunities

Qualifications

• Experience with SQL, SSIS, SSAS, SSRS, and Power BI.
• Knowledge of dimensional modelling and analytics/OLAP cube development.
• Ability to articulate data flows logically.

Responsibilities

• Design reports, dashboards, and BI solutions.
• Enhance existing reporting using best practices.
• Collaborate to understand user needs.

Skills

Strong experience with the Microsoft BI stack

SQL and relational databases

High analytical capability

Effective communication skills

Proactive and self-motivated

Understanding of ETL processes

Education

Microsoft qualified or equivalent experience

Job description

About The Role

Join the Samworth Brothers Team and become part of our dynamic family! At Samworth Brothers, we genuinely care about our colleagues and strive to create an engaging environment that values your unique contributions. We are committed to your success and offer a range of exceptional benefits that support your life and personal aspirations.

• Enhanced pension scheme
• Private health scheme
• Employee discount scheme
• Experience annual pay reviews
• Profit related pay
• Unlock your potential through training and growth opportunities

The Opportunity

The Business Intelligence Analyst will develop, enhance, and support operational and BI reporting across Samworth Group businesses, using the full Microsoft BI stack to deliver integrated, accurate insights. The role blends technical development with stakeholder collaboration to ensure data is reliable, accessible, and aligned with business needs.

Key Responsibilities

• Design and build reports, dashboards, and BI solutions using SQL, SSIS, SSAS, SSRS, and Power BI.
• Enhance and optimise existing reporting, applying best practice and technical improvements.
• Collaborate with Technical and Business Analysts to understand user needs and develop aligned solutions.
• Integrate data from multiple systems to create blended, accurate BI outputs and maintain data quality.
• Communicate progress effectively and support the wider BI team in delivering consistent reporting across the Group.

The Ideal Candidate

We believe that success is built upon collaboration and diverse perspectives. At Samworth Brothers, we welcome candidates who are passionate about working together to achieve greatness. As a valued member of our team, you will bring the following skills and experience:

• Microsoft qualified or equivalent experience
• Strong experience with the Microsoft BI stack (SSIS, SSAS, SSRS, Power BI) and SQL/relational databases.
• Knowledge of ETL processes, data warehousing, dimensional modelling (Kimball), and analytics/OLAP cube development.
• High analytical capability with strong numerical, logical, and problem‑solving skills.
• Effective communication and stakeholder‑management skills, with the ability to prioritise in a fast‑paced environment.
• Proactive and self‑motivated approach, comfortable working independently or across multiple concurrent projects.
• The ability to clearly articulate a story, using a logical, meaningful data flow.
• Current driving license and own transport is essential

We also want you to thrive in an engaging and inclusive work culture where you will have the opportunity to take on personal accountability and take pride in your work. We encourage positive communication, and building strong collaborative relationships is essential to every role.

Join us at Samworth Brothers, where you'll be more than just a team member – you'll be an integral part of our thriving family. Apply today and embark on an exciting journey with us!

About Us

We are a fourth-generation family business producing high quality own-label products for many of the UK’s best-known retailers along with our own brands including Ginsters, Soreen, Higgidy, Dickinson & Morris, Urban Eat, West Cornwall Pasty Company and Walker & Son. We employ over 10,000 people in well‑invested modern food manufacturing sites around the country. At Samworth Brothers we take pride in our family feel within our businesses and work together to make things happen. We can offer you the stability of a wider group as well as the opportunities that that offers if you wish to progress your career with us. We are family and we would like to invite you to be part of that and support our teams in delivering great products to all of our customers.