Insight Analyst

TN United Kingdom; England; Hybrid; GBP 35,000 - 55,000; Full time

Job summary

An established industry player is seeking a Distribution Insight Analyst to enhance data management and reporting processes. This role involves developing and maintaining data pipelines, creating insightful reports, and supporting the Distribution & Fulfilment teams. You will utilize advanced SQL, Excel, and Tableau skills to deliver impactful data visualizations and streamline operations. The company values diversity and inclusivity, offering a comprehensive benefits package and a blended working model to support work-life balance. If you are driven by data and eager to make a difference, this opportunity is perfect for you.

Benefits

Wellbeing services

Award-winning pension scheme

Bonus schemes

25 days holiday plus personal days

Flexible working options

Various discounts and support services

Qualifications

• Proficiency in SQL, Tableau, and advanced Excel skills.
• Strong analytical and problem-solving abilities.

Responsibilities

• Developing reports and processes based on operational needs.
• Maintaining and updating spreadsheets and macros.
• Supporting data sourcing for the Network Planning team.

Skills

SQL

Tableau

Microsoft Excel

Data manipulation

Analytical skills

Communication skills

Attention to detail

Job description

As a Distribution Insight Analyst, your responsibilities will include creating, developing, and maintaining data pipelines, Excel reports, automation macros, and Tableau dashboards. You will support the Distribution & Fulfilment teams by providing insights and reports such as The Big 6, The Weekly Performance Pack, and Safety, as well as assisting the Network Planning teams with data management and process streamlining.

Your key responsibilities:

1. Developing new reports and processes based on operational needs.
2. Enhancing system dependencies by reducing reliance on TAP and standalone SQL Server systems.
3. Maintaining and updating existing spreadsheets and macros without disrupting current operations.
4. Providing contingency backups for departmental systems to prevent data loss.
5. Supporting data sourcing for the Network Planning team as required.

Required skills and qualifications:

• Proficiency in complex SQL statements in SQL Server, Hadoop, or Teradata.
• Experience creating data visualizations and dashboards in Tableau.
• Advanced Microsoft Excel skills, including VBA, pivot tables, and slicers.
• Ability to manipulate data and manage data pipelines.
• Knowledge of database structures and data organization.
• A data-driven mindset with strong analytical and problem-solving skills.
• Excellent communication skills and stakeholder engagement.
• Ability to plan, organize, and pay close attention to detail.

What we offer:

We provide a comprehensive benefits package, including wellbeing services, an award-winning pension scheme, bonus schemes, holiday entitlement starting at 25 days plus personal days, flexible working options, and various discounts and support services to enhance your wellbeing and work-life balance.

About Tesco:

Our vision is to become every customer's favourite way to shop, with a core purpose of serving our customers, communities, and the planet better every day. We value diversity and inclusivity, fostering a workplace where everyone can be themselves and thrive. We are moving towards a blended working model, combining office and remote work, to support our colleagues' needs.

Note: Successful applicants will need to provide bank details on their start date. We are committed to accessible recruitment processes and support for applicants with disabilities. For more information, visit https://www.tesco-careers.com/accessibility