Reporting & Bi Analyst

Simarco; Stoke-on-Trent; Hybrid; GBP 38,000 - 55,000; Full time

Benefits offered by this job

25 days annual leave + 8 bank holidays

Company Pension Scheme

Discount platform for retailers

Full training and support

Cycle to work & Tusker car scheme

Regular engagement events

Job summary

Simarco is looking for an experienced Reporting & BI Analyst to join our IT team, based in either Witham, Essex or Stoke-on-Trent. The role is Hybrid after probation, with a 9am-5:30pm workday and a salary described as Market Leading.

You will develop and maintain Power BI dashboards, create operational, commercial and financial reporting, and use Power BI, SQL, Excel and Power Query to analyse and transform data. This position requires strong data-analytic skills and stakeholder collaboration.

Qualifications

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

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.
• Automate manual reporting processes.
• 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

Data analysis

KPI reporting

Stakeholder management

Automation

Tools

Power Query

Pivot Tables

Macros / VBA

Microsoft Fabric

Job description

Job Title: Reporting & BI Analyst

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.

Key duties & 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.

Automate manual reporting processes.

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
• Regular engagement initiative including treat days!
• Learning Management System for continuous learning
• Mental health forum in place to support with well being
• Simarco Stars - recognition & rewards

Interested?

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

Apply today with your up-to-date CV.

Please ensure your application clearly demonstrates your experience with Power BI, Excel, SQL and business reporting.

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.