Looking for a job

Julia O

@juliao

Data Analytics Consultant at Hodgson Group - Orthotics & Prosthetics who built a Python ETL pipeline for healthcare operational and financial reporting.

Canada

Message

At Hodgson Group - Orthotics & Prosthetics, I developed a Python/pandas ETL pipeline to consolidate and transform six ClickUp treatment-stage exports. I cleaned and standardized the data, then validated outputs against Excel and Power Query to support accurate healthcare operational and financial reporting.

At Hydro One, I enhanced Power BI reports by modifying DAX measures and investigating reporting discrepancies. I also developed business requirements for a survey-platform migration and supported a ServiceNow Service Bridge integration with traceability documentation.

Experience

Work history, roles, and key accomplishments

Current

Data Analytics Consultant

Current

Hodgson Group

Aug 2026 - Present (2 months)

Developed a Python/pandas ETL pipeline to consolidate and transform ClickUp treatment-stage exports for healthcare operational and financial analysis. Cleaned and standardized source data, validated outputs, and defined Power BI KPIs and reporting logic.

Python Pandas ETL ClickUp Power BI DAX Power Query Excel Data Quality Requirements Gathering

Business/Data Analyst Co-op

Hydro One

May 2025 - Sep 2026 (1 year 4 months)

Delivered enhancements across an enterprise Power BI suite of 27 operational and performance reports, authored DAX measures, and built and tested reporting changes in Microsoft Fabric. Led discovery for a survey-platform migration and automated weekly triage of cybersecurity vulnerability records.

Power BI DAX Microsoft Fabric SQL Excel VBA V Lookups Jira Requirement Traceability Stakeholder Management Data Analysis

Education

Degrees, certifications, and relevant coursework

York University

Bachelor of Science (Honours), Computer Science

Activities and societies: York University Entrance Scholarship, Lassonde Entrance Scholarship, Best UI/UX Award, CSHub Local Hack Day Hackathon (2023)

Pursuing a Bachelor of Science (Honours) in Computer Science, with expected completion in 2027.