Joel Knapp

IT Consultant | Power BI Developer @ Blezius Consulting

About

I'm Joel, a data scientist with over a decade of experience working in the public and private sectors in Ontario transforming complex data into actionable insights. I use data science to uncover meaningful patterns and craft data-driven stories that support evidence-based decision making.As a Power BI Developer, I specialize in optimizing ETL processes, building interactive dashboards, and deploying end-to-end analytics solutions. I have worked with Power BI since it was released and bring real-world experience developing reports and dashboards across Power BI Workspaces, with a strong focus on user experience and performance.When I'm not hacking my way through mountains of data, I'm climbing mountains outside and trying to keep my websites and LinkedIn profile up to date.

Country

Canada

City

Greater Kitchener-Cambridge-Waterloo Metropolitan Area

Industry

Information Technology & Services

Skill

IT Consulting, Business Intelligence (BI), Data Science, Data Analysis, Problem Analysis, Problem Solving, Project Management, Extract, Transform, Load (ETL), Data Processing, Data Visualization, Report Design, KPI Reporting, User Experience Design (UED), Machine Learning, Data Archiving, Database Analysis, Technical Reports, Data Integration, Agile Testing, Cardiology

Experience

IT Consultant | Power BI Developer

Blezius Consulting

2024-7 - Present · 2 yrs 3 mos

Burlington, Ontario, Canada

Data Analysis, Data Science, Power BI Workspace Development, ETL Process, Data Modelling, Data Visualization, Statistical Analysis, Machine Learning, Predictive Analytics, Fabric, Power BI, Excel, SAP Database, Python, SQL, Creative Thinking, Problem Solving

Procurement Analyst

Public & Business Services & Procurement | Services au public et aux entreprises & Approvisionnement

2016-1 - 2023-12 · 8 yrs

Toronto, Ontario, Canada

• Developed and maintained a reporting tool built in Power BI incorporating a Random Forest classification model designed in Alteryx which achieved a provincial goal of allocating 40% of total Ontario Public Service expenditures to Small and Medium Enterprises • Responsible for the design, deployment, and maintenance of the I&IT Portfolio Enterprise Vendor of Record database, delivered through Power BI and built on Microsoft Fabric, resulting in a 50% reduction in the completion time of Business Intelligence data requests • Lead the data extraction, transformation, and loading processes as well as report development for Federal Trade Agreements, Consulting Services, and Ethical Apparel reports, creating interactive visualizations and dashboards while maintaining data integrity and accuracy • Wrote complex SQL queries to extract and transform data from Oracle Integrated Financial Systems and Enterprise Vendor of Records Arrangement databases, enhancing data accessibility and usability • Consolidated disparate I&IT Portfolio datasets into a unified data source and constructed interactive Power BI dashboards, enabling efficient exploratory data analysis for Contract Managers

Project Coordinator

Attorney General | Procureur général

2013-11 - 2016-1 · 2 yrs 3 mos

Toronto, Ontario, Canada

• Established a comprehensive Project Database tailored for the Law Clerks of Ontario, leveraging Microsoft Access and MySQL databases alongside VBA queries for efficient data management and analysis • Executed the extraction, transformation, and loading (ETL) process for thousands of datasets, delivering valuable data assets to the Superior Court of Justice shared drive

Data Entry Clerk

Ontario Government | Gouvernement de l’Ontario

2013-5 - 2013-11 · 7 mos

Toronto, Ontario, Canada

• Wrote a series of macros for Data Entry Clerks resulting in a 42% increase in processing speed • Created VBA formula-driven dashboards for Data Entry Coordinator streamlining human-resources coordination