Skip to content

I am Elia

Data Analyst
SQL Developer

Career changer with 18 years of commercial and operational experience, now applied to data analytics. I build Power BI reporting, SQL analysis, and customer analytics that support real business decisions. Available for permanent data analyst roles in Melbourne.

18

Years of
Commercial Experience

1

Year of Intensive Data Analytics Training

10

End to End Completed Projects

Built for the roles I am targeting

I've structured my portfolio and skills around four specific role types in the Melbourne data market. Each project demonstrates the capabilities these roles require.

01

BI Reporting Analyst

Power BI dashboards, DAX measures, SQL data modelling, and stakeholder ready reporting. Demonstrated through the Retail Customer Segmentation dashboard built on 200K+ customer records.

02

Commercial Analysis

KPI tracking, performance reporting, and operational analysis grounded in 18 years of cost, labour, and margin management experience. Demonstrated through the Rockbuster revenue analysis and GameCo market analysis.

03

Customer & Performance Analyst

Segmentation, retention, reactivation, and campaign targeting analysis. Demonstrated through the Retail Customer Segmentation work and six years of hands-on eCommerce campaign analytics across Meta, Google, TikTok, and Taboola.

04

Data Quality & Operational Reporting

Data cleaning, validation, structural integrity, and consistent reporting outputs. Demonstrated through end-to-end pipeline work in Python and Power BI across all five portfolio case studies.

Portfolio

Rockbuster Project
RockBuster Stealth LLC: Customer & Revenue SQL Analysis [PostGreSQL + Tableau]
portfolio_gameco
GameCo LLC - Global Sales & Market Analysis [Excel]
portfolio_03
InstaCart-MapleBear INC. - Customer Segmentation & Purchase Behaviour Analysis [Python, Jupyter, Pandas, Excel]
portfolio_05
CitiBike New York City - Deployed Urban Mobility Analytics Dashboard [Streamlit, GitHub, Python, Jupyter, Matplotlib]
portfolio_04
King County USA - Real Estate Market Analysis and Drivers [Python,Jupyter, Pandas, Matplotlib]
tableau_portfolio_02
CDC Influenza USA - Seasonal Trend Analysis & Resource Planning [Excel, Tableau]

My Education & Certificates

certificate_01
CareerFoundry Intensive Bootcamp [1 Year]
certificate_02
Data Visualizations with Python [CareerFoundry]
certificate_03
Data Immersion [CareerFoundry]
Intro to Data Analytics [CareerFoundry]

Work Experience

2018 - Present

BUSINESS DATA ANALYST

Skynet World Trade, Melbourne, Australia

2016 - 2018

Data ANALYST

RL Italia s.r.l., Milan, Italy

2014 - 2016

DATA ANALYST

Balich Wonder Studio s.r.l, Milan, Italy

2011 - 2014

JUNIOR DATA ANALYST

Assist Digital s.p.a., Milan, Italy

My Education

2025

DATA ANALYST CERTIFICATE

CareerFoundry - Online Intensive Bootcamp

2024

GOOGLE DATA ANALYTICS

Google - Coursera

2015

DATA ANALYST CERTIFICATE

Udemy

1996 - 2001

IT DIPLOMA

Istituto Tecnico Industriale Feltrinelli, Milan, Italy

My Skills

I combine strong analytical expertise with technical tools to clean, analyze, and visualize data for actionable insights. These are the key technologies I use to deliver impactful solutions.

Advanced

Excel

powerbi_icon

Intermediate

Power BI

tableau_icon

Intermediate

Tableau

mssql_icon

Intermediate

Microsoft SQL Server

postgresql_icon

Intermediate

PostgreSQL

phyton_icon

Advanced

Python

Send Me a Message

Name

Phone

+61 476 654 237

Email

info@elialanz.com

Address

Melbourne VIC 3000
Australia