Skip to content
Wellington, New Zealand

Nicholas Holt.

SYSTEMS ANALYST, DATA STORYTELLER, PROCESS BUILDER, DEVELOPER, HUMAN IN THE LOOP

I turn messy operational data into reporting that executives actually act on.

Systems analyst working across insights, analytics and process development — building the reporting, documentation and platforms that let people make evidence-based decisions.

subsidiaries reported on
17subsidiaries reported on
page enterprise BI suite
77page enterprise BI suite
employees using my docs
1,000+employees using my docs
years across data & systems
5years across data & systems

Tools I work with: Power BI, DAX, SQL, Excel, SharePoint, Microsoft 365, Azure, TypeScript, React, Next.js, Power Automate, Jira, JSON, HTML / CSS.

01What I do

Between the data and the decision

Most of my work lives in the gap between a system that holds the numbers and a person who has to make a call. I build the models, dashboards, documentation and processes that close it — then make sure they keep running without me.

Between the data and the decision

Data & Intelligence

Modelling, DAX and dashboards built for people who have ten minutes, not ten tabs. Row-level security so every subsidiary sees exactly its own numbers.

  • Power BI
  • DAX
  • Data modelling
  • RLS
  • Geospatial analysis
  • Excel

Systems & Platforms

Administering the Microsoft stack end to end — tenancy, intranet, permissions — including the cybersecurity audits nobody volunteers for.

  • Microsoft 365
  • SharePoint
  • Azure
  • Security audits
  • SAP S/4HANA

Process & Delivery

Turning a quarterly scramble into a repeatable pipeline: process maps, technical documentation and automated distribution to the people who need it.

  • Process mapping
  • Documentation
  • Automation
  • Stakeholder reporting

Web & Code

The newest thread, and the one I chase in my own time — building interfaces on a modern React stack, this site included.

  • TypeScript
  • React
  • Next.js
  • Tailwind CSS
  • GSAP
  • JSON
02Experience

Six roles, one through-line

Hospitality to logistics to government to enterprise analytics. Every step added a system to understand and someone who needed the answer faster than the system gave it.

  1. Nov 2023 — Present

    Systems Analyst

    The Colonial Motor Company

    A publicly listed automotive holdings company running a network of 19 vehicle dealerships across New Zealand.

    77-pageBI suite, 17 subsidiaries

    • Designed and delivered a 77-page enterprise Power BI reporting suite for 17 subsidiaries, including full data modelling, calculated tables, and RLS-secured dashboards.
    • Automated quarterly production and extranet distribution of the reporting suite, presenting insights to CEOs, CFOs, and Dealer Principals.
    • Sole developer of a quarterly operational performance reporting process, consolidating monthly submissions from 17 subsidiaries.
    • Built geospatial dashboards combining external registration data with internal sales data to identify PMA-based sales trends.
    • Authored technical documentation, process maps, and user guides used by over 1,000 employees.
    • Managed SharePoint intranet platforms and Microsoft 365 administration, conducting cybersecurity audits.
    • Power BI
    • DAX
    • Excel
    • SharePoint
    • Microsoft 365
    • Azure
    • HTML
    • CSS
    • JSON
  2. Oct 2022 — Nov 2023

    IT / Digital Candidate Manager

    Find IT Recruitment

    A Wellington, Auckland and Christchurch recruiter specialising in corporate, finance, technology and digital roles.

    • Identified potential candidates through job boards, social media, referrals, and networks, ensuring a diverse talent pool.
    • Partnered with recruitment consultants to understand client needs and candidate requirements for precise matches.
    • Conducted in-depth interviews to evaluate fit and prepared detailed candidate profiles and reports.
    • Managed and updated candidate databases accurately, ensuring data integrity.
    • Provided technical support to colleagues for hardware and software issues.
    • JobAdder
    • Microsoft 365
    • LinkedIn Talent Solutions
    • SAP SuccessFactors
  3. Feb 2022 — Oct 2022

    Administrator

    Dept. of Corrections / NZ Parole Board

    The independent body responsible for deciding the parole of individuals in Corrections care.

    • Served as the primary point of contact for the New Zealand Parole Board, maintaining relationships with stakeholders.
    • Utilised Department-based platforms and M365 applications to support daily operations.
    • Demonstrated excellent judgment and discretion in handling highly confidential information.
    • Provided technical support to internal staff and Parole Board members.
    • Processed and paid vendor invoices, ensuring timely and accurate financial transactions.
    • IOMS
    • SAP S/4HANA
    • Citrix ShareFile
  4. Jul 2021 — Feb 2022

    Logistics Administrator

    FUJIFILM Business Innovations

    Contributed to the Wellington City Council Archive Digitalisation Project, digitising 200 years of archival files.

    200 yrsof archives digitised

    • Managed and maintained office-wide IT systems to ensure efficient use by all staff.
    • Identified and resolved errors in archiving operations to maintain data accuracy.
    • Stepped up to lead a team of eight Imaging and Archival Specialists during a transitional period.
    • Generated database reports for internal stakeholders to track project progress.
    • Jira
    • FXNZ Internal Tools
    • Microsoft 365
  5. Jul 2020 — Jul 2021

    Bartender

    ABV Rooftop Bar / The Grand

    • Designed eye-catching marketing material for events using Adobe Creative Cloud.
    • Maintained strict adherence to health and safety regulations.
    • Developed excellent communication skills engaging with diverse patrons.
    • Adobe Photoshop
    • Illustrator

  6. Retail Assistant

    PAK'nSAVE New Plymouth · Mar 2015 — Jul 2020

03Selected work

Things I build after hours

Side projects where the analytics thinking meets the frontend — one finished, one a good deal larger than it was ever meant to be. Open either for screenshots and the write-up.

In development

NZ Vehicle Registration Analytics

Five million rows a month. Nothing hardcoded.

A static analytics site over NZTA's open vehicle register. 5.9 million rows are pulled and precomputed into a Parquet cube every month, so the browser answers questions like "how fast have EVs grown" without ever touching raw data — DuckDB in a GitHub Action, Astro and React on the front, no server.

  • Python
  • DuckDB
  • Astro
  • React
  • TypeScript
  • Observable Plot
  • GitHub Actions
A volumetric aurora scene: green light curtains drifting over a dark starfield.In development4

AmbientGen Wall Studio

Shaders for the wall, not the demo reel.

A generative visual studio for commercial LED video walls: author real-time GLSL and 3D procedural scenes, run dual-screen client pitches from them, and manage the physical displays they play on. React and Three.js on the front, an Express and Postgres API behind it, MQTT out to the hardware.

  • React 19
  • Three.js
  • GLSL
  • TypeScript
  • Express
  • Prisma
  • PostgreSQL
  • MQTT
  • Tauri
04Colophon

The small print, for once worth reading

One continuous page rather than a set of them: structure from rhythm and typography instead of dividers, and motion that takes the hint the moment it is not wanted.

Onepage,onesetoftokens,andnothingonitIcouldnottakeapartandexplain.

What follows is the rest of it: what the site is made of, and what each piece is actually earning its place for.

Framework
Next.js 16App Router, rendered on the server wherever it can be, and a build that fails loudly when I have got something wrong. It gets plenty of practice.
Language
TypeScriptStrict. The errors are the feature — most of what I know about this stack, I learned from being told no.
Styling
Tailwind CSS v4One set of custom properties per theme. Light and dark cannot drift apart because there is only one place left to get them wrong.
Motion
GSAP · ScrollTrigger · LenisScroll-linked timelines and smoothing, all of it behind a prefers-reduced-motion guard. If you would rather it held still, it holds still.
Tooling
AI assistanceOne of the tools on the desk, and about as remarkable as the rest of them.
Typefaces
Inter · Instrument Serif · JetBrains MonoA workhorse for reading, one italic for the word that matters, and a monospace for anything you might want to count.
05Contact

Let's build something useful.

Whether it's insights, analytics, process work, or you just want to compare notes on Power BI and React — the inbox is open.

Email meLinkedIn

nicholasholttt@gmail.com
Wellington, New ZealandUsually replies within a day