Hello, I’m Germain Piquette, a Microsoft-certified BI Developer and senior IT consultant specializing in Power BI, Power Query (M), DAX, and data modeling. I translate multi-source data into actionable insights, KPI frameworks, and executive dashboards to support strategic decision-making. I excel in stakeholder engagement, requirements gathering, data quality audits, governance, and Power Platform automation (Power Apps/Power Automate). I bring 30+ years of analytics and software delivery experience across federal and enterprise clients, with a track record of delivering scalable data products and governance.

Germain Piquette

Hello, I’m Germain Piquette, a Microsoft-certified BI Developer and senior IT consultant specializing in Power BI, Power Query (M), DAX, and data modeling. I translate multi-source data into actionable insights, KPI frameworks, and executive dashboards to support strategic decision-making. I excel in stakeholder engagement, requirements gathering, data quality audits, governance, and Power Platform automation (Power Apps/Power Automate). I bring 30+ years of analytics and software delivery experience across federal and enterprise clients, with a track record of delivering scalable data products and governance.

Available to hire

Hello, I’m Germain Piquette, a Microsoft-certified BI Developer and senior IT consultant specializing in Power BI, Power Query (M), DAX, and data modeling. I translate multi-source data into actionable insights, KPI frameworks, and executive dashboards to support strategic decision-making.
I excel in stakeholder engagement, requirements gathering, data quality audits, governance, and Power Platform automation (Power Apps/Power Automate). I bring 30+ years of analytics and software delivery experience across federal and enterprise clients, with a track record of delivering scalable data products and governance.

See more

Experience Level

Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate
Beginner
Beginner
See more

Language

English
Fluent
French
Fluent

Work Experience

Technology Architect at Shared Services Canada (PMCOE)
November 1, 2019 - June 1, 2025
Led end-to-end BI delivery: discovery, requirements gathering, dimensional modeling, DAX development, visualization, publication, and enablement. Authored KPI framework and executive dashboards (Scorecard, EAC Trending, Appearance Stats, FA History). Built Power Apps components for standardized data capture; orchestrated data refreshes and stakeholder alerts with Power Automate. Integrated SharePoint Lists, Excel, and SQL; standardized transformations with Power Query; documented metadata for data products.
Technology Architect at Shared Services Canada (OMB)
December 1, 2022 - March 1, 2024
Built and optimized models & dashboards for operational KPIs and SLA monitoring; governed access via workspaces and deployment pipelines; automated recurring checks and messages via Power Automate.
Senior Programmer/Analyst at Canadian Nuclear Safety Commission (CNSC)
December 1, 2013 - September 1, 2019
Produced Power BI reports and supporting Excel/VBA tooling; delivered data cleanup pipelines and XML ingestion utilities; trained end-users and analysts on BI assets.

Education

Business Administration Diploma (EDP) at Cambrian College
January 11, 2030 - December 8, 2025
Business Administration Diploma (EDP) at Cambrian College
January 11, 2030 - December 8, 2025
Business Administration Diploma (EDP) at Cambrian College
January 11, 2030 - December 8, 2025
Business Administration Diploma (EDP) at Cambrian College
January 11, 2030 - December 8, 2025

Qualifications

PL-300 — Microsoft Power BI Data Analyst
January 11, 2030 - December 8, 2025
ITIL v3 Foundation
January 11, 2030 - December 8, 2025
MOS (Excel Expert & Suite 2010→2019)
January 11, 2030 - December 8, 2025
DP-900 — Azure Data Fundamentals
January 11, 2030 - December 8, 2025
PL-300 — Microsoft Power BI Data Analyst (Active)
January 11, 2030 - December 8, 2025
ITIL v3 Foundation
January 11, 2030 - December 8, 2025
MOS (Excel Expert & Suite 2010→2019)
January 11, 2030 - December 8, 2025
DP-900 — Azure Data Fundamentals
January 11, 2030 - December 8, 2025
PL‑300 — Microsoft Power BI Data Analyst
January 11, 2030 - December 8, 2025
ITIL v3 Foundation
January 11, 2030 - December 8, 2025
MOS (Excel Expert & Suite 2010→2019)
January 11, 2030 - December 8, 2025
DP-900 — Azure Data Fundamentals (Studying)
January 11, 2030 - December 8, 2025
PL-300 — Microsoft Power BI Data Analyst
January 11, 2030 - December 8, 2025
ITIL v3 Foundation
January 11, 2030 - December 8, 2025
MOS (Excel Expert & Suite 2010→2019)
January 11, 2030 - December 8, 2025
DP-900 Azure Data Fundamentals (Studying)
January 11, 2030 - December 8, 2025

Industry Experience

Government, Professional Services, Software & Internet