Reporting & BI Analyst

Hollybank Trustees Ltd; Stoke-on-Trent; Hybrid; GBP 55,000 - 75,000; Full time

Benefits offered by this job

25 days leave

Company pension

Discount platform

Training and support

Cycle to work

Tusker car scheme

LMS for learning

Mental health support

Job summary

Simarco International is seeking an experienced Reporting & BI Analyst to join our IT team, based in either Witham, Essex or Stoke-on-Trent. You will develop and improve reporting across the business, using data to provide clear, accurate insight to operational, commercial and management teams.

Hybrid after probation, location flexible within Witham or Stoke-on-Trent. You will lead power BI dashboards, data extraction and KPI reporting, working with stakeholders at multiple levels to drive data

Qualifications

• Experience with Power BI and KPI reporting.
• Strong Excel skills with Pivot Tables and Power Query.
• Working knowledge of SQL and data extraction.
• Experience analysing data from multiple systems.
• Ability to communicate with stakeholders at various levels.

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 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

Advanced Excel

SQL

KPI reporting

Data analysis

Stakeholder management

Attention to detail

Independent worker

Logistics familiarity

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

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.