I build FTE models, inflow forecasts and automated data pipelines using Python, SQL, Power BI, Snowflake and dbt — turning ad-hoc workforce planning into repeatable, data-driven decisions.

Jesse O'Brien

4+ years in workforce analytics

PL-300 certified

Python · SQL · Power BI · Snowflake · dbt

Who is Jesse O'Brien?

A little bit about me.

I'm a workforce modelling and data specialist with over four years building FTE models, inflow forecasts, transition models, and scenario analyses inside a large government organisation. My toolkit spans Python, SQL, dbt, Snowflake and Power BI, and I've spent that time building analytical infrastructure from scratch — turning ad-hoc, manual processes into automated, reproducible pipelines.

I'm equally comfortable as a hands-on technical practitioner and as the data SME in the room, translating complex modelling into decisions that stakeholders can act on — from planners and real-time analysts through to executive leadership.

Outside of my day-to-day role, I'm still building — new tools, forecasting techniques, and side projects. Take a look at what I'm currently working on over on the Projects page, or read more of my thinking on the Blog.

Four Years at ACC.

My experience.

Workforce Modeller

Current

Apr 2026 – Present

  • Act as a key modelling and data SME within a WFM function of 70+ staff, advising planners, real-time analysts, and leadership on technical feasibility, data interpretation, and process capability.
  • Build FTE scenario models for new business initiatives, quantifying workforce impact of moving work between teams, standing up new functions, or absorbing inflow changes at scale.
  • Develop what-if and transition models mapping how changes in one area of the business propagate FTE requirements across the wider organisation.
  • Led the end-to-end data modelling and allocation framework design for new workforce functions, from initial scoping through to operationalisation and steady state.

Reporting Analyst

Jul 2025 – Apr 2026

  • Designed, developed and maintained 50+ Power BI dashboards, Streamlit applications, and Excel reports supporting WFM operations, planning, and performance reporting up to executive level.
  • Extracted, cleaned and modelled workforce data from Snowflake, Salesforce, and SQL sources using Python and dbt, ensuring accuracy and timely delivery across WFM reporting cycles.
  • Advised reporting analysts across WFM on data interpretation, query design, and what is achievable within ACC infrastructure constraints.

Workforce Planner

Jul 2024 – Jul 2025

  • Built volume forecasting models using Prophet and LightGBM to predict incoming work inflow across departments, providing the demand signal foundation for FTE planning and capacity modelling.
  • Designed and built WFM forecasting pipelines and department-level inflow models from the ground up, replacing ad-hoc manual processes with automated, reproducible workflows in dbt, Snowflake, and Python.

Earlier at ACC

Operations Analyst

Aug 2023 – Jun 2024

  • Built Python automation scripts that eliminated manual stakeholder processes and directly reduced the need for unplanned overtime, delivering measurable cost avoidance for the business.

WFM Real Time Analyst

May 2022 – Aug 2023

  • Monitored real-time workforce activity across multiple business units within a 250+ FTE operation, managing intraday staffing decisions to maintain service levels.
What I Work With.

My skills & credentials.

Workforce Modelling

FTE modelling Capacity planning Scenario analysis Inflow forecasting Transition modelling Allocation design

Languages

Python pandas Prophet LightGBM scikit-learn SQL DAX M / Power Query VBA Jinja

Data Platform

Snowflake dbt GitHub Actions Azure Pipelines Git

Visualisation

Power BI (PL-300) Streamlit Excel PowerPoint

Automation

Python scripting Power Automate Selenium

Tools

Genesys Cloud Salesforce CRM Emite Microsoft 365

Certifications

Power BI Data Analyst Associate (PL-300)

Microsoft

2023

IBM Data Analyst Professional Certificate

IBM / Coursera

2025

Google Data Analytics Professional Certificate

Google / Coursera

2022

Google Project Management Professional Certificate

Google / Coursera

2025

Lean Six Sigma: White Belt

2024

Education

Bachelor of Business Administration — Project Management & Information Systems

University of Maine at Presque Isle

Let's connect.

Open to workforce modelling, analytics, and data specialist roles — reach out or send an email.

jesse@jesse-obrien.com

Auckland, New Zealand
Resume

© 2026 Jesse O'Brien.