Learn Data Skills
Katrina Mitchell

Katrina Mitchell

Performance Manager

Technologies

My Portfolio Highlights

My New Course

Introduction to Power BI

My New Course

Introduction to Power BI

Quantitative storyteller, weaving narratives through data analysis.

My Work

Take a look at my latest work.

course

Introduction to Power BI

course

Data Visualization in Power BI

course

Introduction to DAX in Power BI

course

Introduction to Power BI

DataCamp Course Completion

Take a look at all the courses I’ve completed on DataCamp.

Courses

Introduction to SQL
Introduction to Power BI
Intermediate SQL
Joining Data in SQL

My Work Experience

Where I've interned and worked during my career.

ANZ | Oct 2021 - Mar 2023

Senior Performance Manager

Key responsibilities • Providing actionable recommendations to senior leaders by understanding strategic business objectives, analysing performance data, generating insights and presenting back in non-technical language. • Creating easy-to-digest reporting to be leveraged for management decisions & regulatory reporting. • Acting as a translator between data groups and non-technical audiences – improving understanding of the business in former group and enhancing data literacy in latter group. Key projects • Designed & built a self-serve KPI dashboard using SQL which cut time spent on reporting by ~3 days a fortnight; worked closely with senior business partners to ensure needs were met & reporting was valuable. • Collaboratively led development of 100+ standardised Jira task tickets; required understanding of both technical and non-technical tasks. Enabled a consistent & more efficient way of working.
Show More

ANZ | Feb 2021 - Oct 2021

Campaign Delivery Manager

Key responsibilities • Leading & coaching a technical team of data analysts. • Ensuring that the right customers received communications from the Customer Resolution programme. • Acting as a translator between data groups and non-technical audiences – improving understanding of the business in former group and enhancing data literacy in latter group Key projects • Developed & rolled-out standardised campaign code across 12 agile squads. Involved using process data to influence senior management to authorise a pilot and full roll-out.

Data Insight | Jan 2020 - Feb 2021

Senior Insights Analyst (Senior Data Analyst)

Key responsibilities • Ad hoc analysis, reporting, visualisation & campaign management using SQL, Tableau & Excel. • Building meaningful relationships with clients & presenting strategic recommendations based on analysis. • Reviewing presentations to ensure insights were effectively conveyed prior to communication to clients. Key projects • Segmented customers using RFM methodology and created insights to optimise marketing spend. • Applied results of A/B testing to create campaigns which typically produced a 3%+ uplift on Control.

Air New Zealand | Apr 2019 - Dec 2019

Senior Marketing Insights Analyst - Loyalty (Senior Data Analyst)

Key responsibilities • Marketing campaign builds including understanding internal client objectives, campaign reporting & recommendations. Campaign build and reporting involved a mix of IBM Unica, IBM Watson and SQL. • Mentoring junior team members to enhance capabilities of the team. Key projects • Provided thought leadership on customer communication journeys for the 3+ million loyalty member base. These automated journeys were developed to meet our strategic objective to engage members earlier.

SCENE | Jun 2017 - Apr 2019

Senior Manager - Analytics

Key responsibilities • Managing the analytics workflow process. This included prioritization of analytics requests, resource allocation & workload management, external vendor management and budget management. • Leading and/or supporting strategic data projects including the creation of a data lake, customer segmentation and the development of a CLV metric. • Working with marketing managers to design campaign tests & using insights to inform campaign builds. Key projects • Developed standardised self-serve campaign reporting using SQL & Tableau. This streamlined the process from 2 days per report to 4 hours and increased data literacy in the company. • Created member acquisition & engagement forecasting model which was accurate to within 1 month and provided greater confidence in financial projections. • Cut external analytics vendor costs by 50%, using data to support negotiations.

BT Financial Group | Jul 2015 - Oct 2016

Senior Customer Insights Analyst (Senior Data Analyst)

Key responsibilities • End-to-end management of analytics projects for the Private & Platforms marketing team. • Coaching members of the team in analytics processes and SQL. Key projects • Deep dive into why customers were redeeming platform products, a multi-million-dollar financial risk. • Created Private wealth customer segmentation to determine appropriate treatment for customer groups e.g. migration out of Private service. Allowed for a manageable book of Private wealth customers.

Bupa | Feb 2015 - Jun 2015

Commerical Insights Analyst (Data Analyst)

N/A

RBS | Aug 2011 - Oct 2013

Customer Insights Analyst (Data Analyst)

Key responsibilities • Presenting insights to non-technical clients in clear, easy to understand language. Presentations focused on telling a story with the data. • Sourcing, extracting, and manipulating data using SQL, SAS & Excel. Key project • Optimised the credit card Risk Based Pricing (RBP) model. Overall reduction in run time was from 9 hours to less than 1 hour.

Procter & Gamble | Sep 2007 - Sep 2008

Systems Analyst

Key responsibilities • Documenting IT processes, understanding detailed customer requirements and developing advanced IT systems which met these requirements. • Testing new IT systems including reliability and functionality testing. Key project • Designed and developed a new web-based invoice management information system to be used by 100+ account managers.

My Education

Take a look at my formal education

MSc, Applied Statistics and DataminingUniversity of St Andrews | 2009
BA, Management ScienceUniversity of Strathclyde | 2007

About Me

Katrina Mitchell

I'm an experienced data analyst looking to close out some gaps in my knowledge - namely learning Power BI and refreshing my R knowledge.

Powered by

  • Work
  • Courses
  • Experience
  • Education
  • About Me
  • Create Your Data Portfolio for Free