Reporting & BI Analyst

Hollybank Trustees Ltd; Witham; Hybrid; GBP 45,000 - 65,000; Full time

Benefits offered by this job

25 days annual leave

Bank holidays

Company Pension Scheme

Discount platform

Full training and support

Cycle to work

Tusker car scheme

Learning Management System

Mental health forum

Job summary

Simarco International is seeking a Reporting & BI Analyst to join its IT team, based in Witham, Essex or Stoke-on-Trent. The role focuses on developing and improving reporting across the business, turning data into clear insight for operational and management teams.

The ideal candidate will have strong Power BI experience, advanced Excel skills, and working SQL knowledge. This hybrid role offers progression, training, and competitive benefits.

Qualifications

• Experience with Power BI dashboards and reports.
• Advanced Excel with Pivot Tables, Power Query and complex formulas.
• SQL and data from multiple systems.
• Strong numerical and analytical skills with KPI reporting.
• Attention to detail and data accuracy.
• Ability to work with stakeholders at various levels.
• Experience in freight forwarding/logistics advantageous; familiarity with VBA/macros/Microsoft Fabric is a plus.

Responsibilities

• Develop and maintain Power BI dashboards and reports.
• Create operational, commercial and financial reporting.
• Use Power BI, SQL, Excel and Power Query to analyse and transform data.
• Produce KPI and management information.
• Improve data quality and reporting accuracy.
• Identify trends, exceptions and performance issues.
• Work with stakeholders to understand reporting needs.
• Provide support and training on reporting tools and dashboards.

Skills

Power BI

Excel

SQL

Data extraction

KPI reporting

Stakeholder management

Data quality

Attention to detail

Logistics exposure

VBA

Tools

Power Query

VBA

Microsoft Fabric

Job description

Location: Witham, Essex or Stoke on Trent

(Hybrid after successfully completing your probation period – to be discussed at interview)

Salary: Market Leading

Hours: Monday to Friday – 9am to 5.30pm

Simarco is an award-winning international logistics provider, driven by a deep understanding of the fast-paced nature of global trade. We specialise in delivering bespoke freight solutions across the UK, Europe, and worldwide, offering flexible, fully tailored services that are designed to meet the unique needs of our clients.

We are currently seeking an experienced Reporting & BI Analyst to join our IT team, based in either Witham, Essex or Stoke-on-Trent.

You will play a key role in developing and improving reporting across the business, using data to provide clear, accurate and meaningful insight to operational, commercial and management teams.

Here at Simarco, we believe that people are the heart of our business. It is their professionalism, dedication and experience that continues to be at the core of our success!

The Simarco Culture and values…

~ Communication ~ Innovation ~ Accountability ~ Integrity ~

Key Skills and Qualifications to succeed in this role:

• Strong experience using Power BI.
• Advanced Excel skills, including Pivot Tables, Power Query and complex formulas.
• Working knowledge of SQL and database querying.
• Experience extracting, validating and analysing data from multiple systems.
• Strong numerical and analytical skills, including experience producing KPI reporting and management information.
• Excellent attention to detail and a strong commitment to data accuracy.
• Confidence working with stakeholders at different levels.
• The ability to work independently and manage priorities effectively.
• Experience within freight forwarding, logistics, transport or supply chain would be advantageous, along with knowledge of VBA, macros or Microsoft Fabric.

Location & Right to Work

Applicants must live within a reasonable commuting distance of either Witham, Essex or Stoke-on-Trent.

You must also have full and unrestricted Right to Work in the UK. Unfortunately, we are unable to offer visa sponsorship for this role.

• Develop and maintain Power BI dashboards and reports.
• Create operational, commercial and financial reporting.
• Use Power BI, SQL, Excel and Power Query to analyse and transform data.
• Produce KPI and management information.
• Improve data quality and reporting accuracy.
• Identify trends, exceptions and performance issues.
• Work with stakeholders to understand reporting needs.
• Provide support and training on reporting tools and dashboards.

We can offer you:

• We offer a highly competitive salary
• 25 days annual leave, plus 8 bank holidays
• Company Pension Scheme
• Discount platform – including top high street retailers
• Full training and support
• Cycle to work & Tusker car scheme
• Learning Management System for continuous learning
• Mental health forum in place to support with well being

Interested?

If you enjoy working with data, improving reporting and turning information into useful business insight, we would love to hear from you.

Simarco International is committed to fostering a diverse, inclusive, and a respectful working environment. We welcome applications from individuals of all backgrounds, and we value the unique perspectives that a diverse workforce brings.We are driven by our core values of Integrity, Communication, Accountability, and Innovation, which influence how we work, collaborate, and grow as a business.