Insight Analyst

About the role
As a Distribution Insight Analyst you will be responsible for creating, developing and maintaining data pipelines, excel reports, excel automation macros and Tableau reports. The Distribution Insight team sit within Distribution & Fulfilment and are responsible for providing insight and reports to distribution teams including The Big 6, The Weekly Performance Pack and Safety. We also support the Network Planning teams with data management and streamlining their processes.

You will be responsible for
Supporting the development of new reports and processes when operational needs arise Improving dependency on TAP and removing standalone SQL Server systems Supporting the existing spreadsheets and macros to ensure any changes are integrated with no impact to current operations Providing contingency and backup for departmental systems to secure against data loss and system failure Assisting the Network Planning team with data sourcing when requiredYou will need
Complex SQL statements in SQL Server / Hadoop / Teradata Creating data visualisation Dashboards in Tableau Microsoft Excel VBA, complex pivot tables and slicers Manipulating data and managing data pipelines Operational Skills
Knowledge of databases and how data is structured Data-driven mind-set with strong analytical and problem-solving skills Skills in deriving insight from data and identifying new visualisations to show this Strong communication skills and engagement with stakeholders Ability to plan and organise workload Good attention to detailWhat's in it for you
We're all about the little helps. That's why we give our wonderful colleagues bags of benefits. Including wellbeing services, an award-winning pension scheme and much, much more, our colleague reward package keeps on giving. And helps make every day a little better for you and your family. These include but are not limited to:
Colleague bonus scheme Holiday starting at 25 days plus a personal day (plusBank holidays) Buy holiday salary sacrifice scheme (for salaried roles) Retirement savings plan - save between 4% and 7.5% and Tesco will match your contribution LifeAssurance - 5 x contractual pay 26 weeks maternity and adoption leave (after 1 years' service) at full pay, followed by 13 weeks of Statutory Maternity Pay or Statutory Adoption Pay, we also offer 4 weeks fully paid paternity leave The right to request flexible working from your first day with us Free 24/7 virtual GP service, Employee Assistance Programme (EAP) for you and your family, free access to a range of experts to support your mental wellbeing A Colleague Clubcard for you & a family member (after 3 months of service), giving you access to lots of discounts in-store & online Great colleague deals and discounts, saving you money on everyday purchases, eating out and utility bills for the home Access to our colleague networks providing a space for colleagues to come together from a range of backgrounds. For more information about our colleague networks please click here Opportunities to get on - take advantage of our ongoing learning opportunities and award-winning training, to help you achieve the job and career you want Click Here to read more about the full range of benefits we have available for our colleagues

About us
Our vision at Tesco is to become every customer's favourite way to shop, whether they are at home or out on the move. Our core purpose is 'Serving our customers, communities and planet a little better every day'. Serving means more than a transactional relationship with our customers. It means acting as a responsible and sustainable business for all stakeholders, for the communities we are part of and for the planet.
We are proud to have an inclusive culture at Tesco where everyone truly feels able to be themselves. At Tesco, we not only celebrate diversity, but recognise the value and opportunity it brings. We're committed to creating a workplace where differences are valued, and make sure that all colleagues are given the same opportunities.We're proud to have been accredited Disability Confident Leader and we're committed to providing a fully inclusive and accessible recruitment process. For further information on the accessibility support we can offer, please click here .
We're a big business and we can offer a range of diverse full-time & part-time working patterns across our many business areas, which means that we can find something that works for you. We work in a more blended pattern -combining office and remote working. Our offices will continue to be where we connect, collaborate and innovate. If you are applying internally, please speak to the Hiring Manager about how this can work for you - Everyone is welcome at Tesco.

{ "@context": "", "@type": "JobPosting", "title": "Insight Analyst", "description": " \r

About the role
\r
\r
As a Distribution Insight Analyst you will be responsible for creating, developing and maintaining data pipelines, excel reports, excel automation macros and Tableau reports. The Distribution Insight team sit within Distribution & Fulfilment and are responsible for providing insight and reports to distribution teams including The Big 6, The Weekly Performance Pack and Safety. We also support the Network Planning teams with data management and streamlining their processes.

\r

\r

\r
\r

You will be responsible for
\r
\r

\tSupporting the development of new reports and processes when operational needs arise\tImproving dependency on TAP and removing standalone SQL Server systems\tSupporting the existing spreadsheets and macros to ensure any changes are integrated with no impact to current operations\tProviding contingency and backup for departmental systems to secure against data loss and system failure\tAssisting the Network Planning team with data sourcing when required\r

\r

\r
\r

You will need
\r
\r

\tComplex SQL statements in SQL Server / Hadoop / Teradata\tCreating data visualisation Dashboards in Tableau\tMicrosoft Excel VBA, complex pivot tables and slicers\tManipulating data and managing data pipelinesOperational Skills

\tKnowledge of databases and how data is structured\tData-driven mind-set with strong analytical and problem-solving skills\tSkills in deriving insight from data and identifying new visualisations to show this\tStrong communication skills and engagement with stakeholders Ability to plan and organise workload\tGood attention to detail\r

\r

\r
\r

What's in it for you
\r
\r
We're all about the little helps. That's why we give our wonderful colleagues bags of benefits. Including wellbeing services, an award-winning pension scheme and much, much more, our colleague reward package keeps on giving. And helps make every day a little better for you and your family. These include but are not limited to:

\tColleague bonus scheme\tHoliday starting at 25 days plus a personal day (plusBank holidays)\tBuy holiday salary sacrifice scheme (for salaried roles)\tRetirement savings plan - save between 4% and 7.5% and Tesco will match your contribution\tLifeAssurance - 5 x contractual pay\t26 weeks maternity and adoption leave (after 1 years' service) at full pay, followed by 13 weeks of Statutory Maternity Pay or Statutory Adoption Pay, we also offer 4 weeks fully paid paternity leave\tThe right to request flexible working from your first day with us\tFree 24/7 virtual GP service, Employee Assistance Programme (EAP) for you and your family, free access to a range of experts to support your mental wellbeing\tA Colleague Clubcard for you & a family member (after 3 months of service), giving you access to lots of discounts in-store & online\tGreat colleague deals and discounts, saving you money on everyday purchases, eating out and utility bills for the home\tAccess to our colleague networks providing a space for colleagues to come together from a range of backgrounds. For more information about our colleague networks please click here \tOpportunities to get on - take advantage of our ongoing learning opportunities and award-winning training, to help you achieve the job and career you want Click Here to read more about the full range of benefits we have available for our colleagues

\r

\r

\r
\r

About us
\r
\r
Our vision at Tesco is to become every customer's favourite way to shop, whether they are at home or out on the move. Our core purpose is 'Serving our customers, communities and planet a little better every day'. Serving means more than a transactional relationship with our customers. It means acting as a responsible and sustainable business for all stakeholders, for the communities we are part of and for the planet.

We are proud to have an inclusive culture at Tesco where everyone truly feels able to be themselves. At Tesco, we not only celebrate diversity, but recognise the value and opportunity it brings. We're committed to creating a workplace where differences are valued, and make sure that all colleagues are given the same opportunities.We're proud to have been accredited Disability Confident Leader and we're committed to providing a fully inclusive and accessible recruitment process. For further information on the accessibility support we can offer, please click here .

We're a big business and we can offer a range of diverse full-time & part-time working patterns across our many business areas, which means that we can find something that works for you. We work in a more blended pattern -combining office and remote working. Our offices will continue to be where we connect, collaborate and innovate. If you are applying internally, please speak to the Hiring Manager about how this can work for you - Everyone is welcome at Tesco.

\r

\r

\r
", "identifier": { "@type": "PropertyValue", "name": "Tesco", "value": "880226" }, "datePosted": " ", "validThrough": " T00:00", "employmentType": null, "hiringOrganization": { "@type": "Organization", "name": "Tesco", "sameAs": "", "logo": "" }, "jobLocation": [ { "@type": "Place", "address": { "@type": "PostalAddress", "streetAddress": "", "addressLocality": "Daventry Support Office, Daventry Clothing Depot, Northamptonshire", "addressRegion": "", "postalCode": "NN6 7GY", "addressCountry": "United Kingdom" } } ], "baseSalary": null }

---