Morgan Rennie | CV
Data Analytics Consultant

Resume • Data engineering & analytics

Morgan Rennie

Engineering and analytics consultant with expertise in data visualisation, ETL, pipeline development, and automation. Delivers insight-driven solutions using Tableau, dbt, SQL, Alteryx, Python and Power BI.

Key Industries: Finance, logistics, NGO, TMT, FMCG, media and telecommunications.

Location: London, United Kingdom

Phone: +44 (0)7523 432 671

Email: morgan.a.rennie@gmail.com

Profiles: LinkedIn • Tableau • GitHub

Professional overview

Consulting experience across finance, logistics, media and FMCG

Recognised by Tableau for visual design excellence, Morgan combines analytics, engineering and consulting to build dashboards, automate processes, and deliver measurable insights for business stakeholders.

Specialist strengths

ETL/ELT, data modelling, dashboard design, automation, stakeholder reporting, and consultancy delivery.

Key tools

dbt, SQL (Snowflake, Oracle, MySQL, PostgreSQL), Alteryx, Python, Tableau, Power BI, AWS, Git, Salesforce and Excel.

Technical profile

Certifications & qualifications

  • Tableau Certified Data Analyst, 2023
  • AWS Cloud Practitioner, 2025
  • dbt Developer, 2025
  • Alteryx Designer Advanced, 2024; Alteryx Core, 2022
  • Power BI Data Analyst (PL-300), 2024
  • Databricks Fundamentals, 2024
  • BA Finance, First Class (1st), University of Stirling, 2021
Experience

Recent roles and achievements

Experience spans consulting, analytics engineering, business intelligence and reporting roles. Strong track record in dashboard delivery, migration projects, and stakeholder engagement.

Analytics and Engineering Consultant

The Information Lab • Consultancy • 2022–Present

  • Completed a competitive analytics training programme at a top UK consultancy.
  • Awarded Tableau Viz of the Day and ranked among top Tableau Public dashboards.
  • Built award-winning Power BI dashboards for a luxury FMCG customer.
  • Led an 8-person team to deliver four performance dashboards for an international bank.
  • Presented at JP Morgan analytics summit and trained 50+ Tableau students.
  • Built Mailchimp and Amplitude API pipelines into S3 and Azure Blobs with Python and Airbyte.

Analytics Engineer

Virgin Media O2 • Media & Telecom • Jun 2025–Present

  • Delivered a BI decommissioning project to save ~£4m over three years.
  • Migrated teams from SAP BO and MicroStrategy to dbt and Tableau.
  • Built 500+ optimized dbt models and metadata extraction macros for SOX auditing.
  • Automated manual processes with Python scripts, saving days of work.

Advanced Analytics and Reporting Analyst

IAG Cargo • Logistics & Operations • May 2024–Mar 2025

  • Built Oracle SQL models to track cargo journeys across 40+ linked events.
  • Reduced data errors from 40% to under 8% and improved query runtime by 90%.
  • Created Tableau dashboards for cargo performance, SLAs, and root-cause analysis.
  • Presented insights to Tech Town Hall and C-Suite steering groups.

Business Intelligence Analyst

Paramount Pictures / ViacomCBS • Media & Telecom • Apr 2023–Apr 2024

  • Automated Snowflake ETL and reduced manual processing time by 94%.
  • Designed Tableau dashboards to improve resource utilisation and senior reporting.
  • Built a project management dashboard that cut investigation time by 50%.
Academic achievement

Finance graduate with dissertation distinction

BA Finance, First Class (1st), University of Stirling, 2017–2021. Awarded Best Undergraduate Finance Dissertation for research on sentiment analysis in forecasting the FTSE100.