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.
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
CurrentApr 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
Languages
Data Platform
Visualisation
Automation
Tools
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