Skip to content
Lachlan Ho

Lachlan Ho (he/him)

Professional
Business Intelligence Analyst & Developer at Namsat Melbourne, Victoria, AU AI Aware
Open to Work Job Seeker Job Hunt Help Freelance Gigs Preparing for Interview
QR Code

๐Ÿ’ผ Work Experience

Business Intelligence Analyst & Developer

Namsat Contract

Apr 2026 - Present โ€ข Albury (Remote) โ€ข Information Technology

Responsibilities

โ— Developed and delivered an end-to-end Power BI management reporting solution for a red meat
processing client, transforming complex energy, production and cost data into interactive dashboards for
management decision-making.
โ— Rebuilt and simplified an existing reporting system, delivering a more practical and user-friendly solution
that enabled managers to easily access and understand operational information.
โ— Designed and optimised SQL Server views, queries and data models to integrate electricity, natural gas,
water and production data into reliable datasets for reporting and analysis.
โ— Developed advanced DAX measures, dynamic reporting and KPI functionality to analyse energy usage,
costs, production and operational efficiency across different time periods and areas.
โ— Improved data quality and reporting accuracy by identifying and resolving missing intervals, duplicate
production records, hierarchy issues and misaligned production and energy reporting dates.
โ— Collaborated directly with business stakeholders to translate requirements and feedback into dashboard
improvements, continuously refining calculations, visualisations, navigation and usability.

Skills & Expertise

Power BI 50%
SQL Server 50%
Data Analytics 50%
Python 50%
Business Intelligence (BI) 50%