Share
Explore

icon picker
Jess Hancock ⋅ Tableau and Alteryx Expert

I am a creative yet critical thinker with over 5 years of experience in BI development, including 3.5 years as a consultant at The Information Lab, a leading Tableau and Alteryx partner. I create robust, purposeful products that focus on the user experience
👔 View 📫 Email 📞 WhatsApp or call +44 7401 549 304 📍 Based in Sheffield, UK

“The data quality dashboard is arguably the best product we have delivered [...] it is down to Jess’ expertise and skills for creating such a beautiful product.”

Seth Cooke, manager at Techmodal (BAE Systems) ⋅ Feb 2022

Recent Roles

Tableau Developer

Customer Insights team at Ralph Lauren

Identified new market segments + Utilised SQL/Python
🕓 Jan 2024 → Jan 2025 1 yr FTC

Technical Reviewer

Tableau Certified Data Analyst: The Complete Guide for Packt Publishing

🕓 Nov 2023 → Jan 2024~3 mo, ad-hoc

Senior Consultant

The Information Lab Ireland

🕓 Jul 2022 → Dec 2023 1 yr 5 mo
Utilising Tableau Prep, Desktop and Cloud / Alteryx Designer & Server / Snowflake for clients such as KPMG

Alteryx & Tableau Consultant

The Information Lab UK (Data School)

🕓 Feb 2020 → Jun 2022 2 yr 4 mo
Clients incl. National Student Survey Coca-Cola European Partners Grant Thornton HSBC ODEON

Project Spotlight » Excel to Tableau migration for global retailer

Primark

In this project, I lead the technical switch from Excel to Tableau for ~7 distinct teams

Rebuilt ~ 25 high-value Excel reports in Tableau — for receptive stakeholders, I took the initiative to improve dashboard clarity with more appropriate charts and interactivity
Ran 1-1 “office hour” sessions to troubleshoot existing reports and effectively enable ownership and development of new ones — these sessions often included ad-hoc technical training
Key skills Rapid and accurate dashboarding Blending unfamiliar datasets Explaining complex concepts simply and clearly
Key analytics Sales KPIs within and between departments Identification of high-risk inventory Financial reconciliation
Feedback Senior management stated the work “had achieved more in 6 weeks” than previous actions “had in a year” for the adoption of Tableau, both technically and culturally
🕓 Nov 2023 → Dec 2023 6 weeks

Key Skill » Tableau Report Development

GREATEST MEASURABLE RESULT » BAE Systems

~£5m saved: Optimising design process for next-gen fighter jet

🕓 Apr 2021 → Jan 2022 ~ 8 mo (part-time)
Brief Develop a suite of dashboards to manage the design and manufacture of a prototype ‘Tempest’ aircraft
Solution 5 priority-focused parts-tracking dashboards were developed to highlight manufacturing risks — such as failed tests or missing parts — to prevent expensive mistakes and plan ahead when delays were inevitable
Result Direct savings over 5 years estimated at ~£5 million by a senior engineer. Dozens of hours were saved each week by replacing tedious manual look-ups, improving satisfaction as well as productivity
Key skills Project management: visualising complex dependencies, cleanly Parsing requirements from engineers and commissioning views from the data team

MOST INTERACTIVE » Surfers Against Sewage

A gamified tool for schools to help ditch plastics

🕓 Jul 2023 5 days Screenshots available
Brief Create an engaging dashboard prototype for schools enrolled in SAS’s anti-pollution programme. The tool should celebrate progress to date, encourage further action, and make students feel part of a wider community
Solution Students are engaged with playful aesthetics and personalised text in a ‘scrollytelling’ style dashboard (long-form, with narrative elements). Context keeps kids invested. Their school is placed in friendly competition — who’s right ahead, or just behind? — and nearest neighbours are shown on a visually appealing map
Key skills Efficiency: distilling business requirements into appropriate designs, effectively transforming and joining unfamiliar data sets, and producing a technically complex yet maintainable workbook — all within 1 week

Key Skill » Alteryx Workflow Development

Transferable: I have also produced validated workflows in Tableau Prep for 3 clients (and in Dataiku for Ralph Lauren)

MOST AMBITIOUS PROJECT » PHX Pharmaceuticals

Automating financial audits and validating with data quality macros

🕓 Aug 2023 → Oct 2023~2 months
The problem KPIs were missing and faith was lacking in audit results following a large merger; inconsistent business terms and ungoverned data across disparate teams made aggregation borderline impossible
Liaised efficiently with time-strapped accounting teams to centrally define and formalise business definitions
Replaced convoluted Excel workbooks with documented Alteryx workflows, supported by external documents to describe complex functionality and edge cases. A framework for managing new mapping tables was agreed for hard-coded values, and a new Analytical App allows users to safely input ad-hoc adjustments — both designed to be easy for new Alteryx users
Built several data quality macros, functional with any tabular schema, to auto-fail flows with unexpected results (such as join explosions, null dates or arithmetic errors); failed records were flagged and saved to a database, and the results of each run were automatically collated into a visual report that was saved locally

MOST CREATIVE TECHNICAL SOLUTION » University of York

Taming an untidy Tableau Server with a dynamic visual ‘Portal’

🕓 Feb 2022 → Mar 2022 ~ 8 weeks
The problem Reports had low engagement rates, in part due to Tableau Server’s intimidating size and complexity
Established a workbook tagging system, then used ~ 8 tables of Tableau Server metadata in Alteryx to summarise engagement stats and identify key reports
Used these new tables to build a streamlined ‘landing page’ dashboard, tailored to each user and complete with thumbnail images. Even non-technical colleagues can engage quickly and confidently with vital reports
Bonus skill Experience with RLS and permissions, navigating conflicting rules, to protect sensitive data

Other relevant experience

Alteryx Designer Advanced

Certification
🕓 Re-issued May 2023
I am familiar with data staging and adept at ‘Extract Transform Load’ processes.

2:1 design degree

Visual communications, Loughborough University
🕓 Graduated Jul 2019
A design background informs my iterative, highly personalised approach to dashboarding.

Entry-level Python

PCEP™ certification
🕓 Achieved Dec 2022




Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.