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.
Experience Level
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate
Beginner
Beginner
Language
English
Fluent
French
Fluent
Work Experience
Technology Architect at Shared Services Canada (PMCOE)
November 1, 2019 - June 1, 2025Led 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, 2024Built 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, 2019Produced 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, 2025Business Administration Diploma (EDP) at Cambrian College
January 11, 2030 - December 8, 2025Business Administration Diploma (EDP) at Cambrian College
January 11, 2030 - December 8, 2025Business Administration Diploma (EDP) at Cambrian College
January 11, 2030 - December 8, 2025Qualifications
PL-300 — Microsoft Power BI Data Analyst
January 11, 2030 - December 8, 2025ITIL v3 Foundation
January 11, 2030 - December 8, 2025MOS (Excel Expert & Suite 2010→2019)
January 11, 2030 - December 8, 2025DP-900 — Azure Data Fundamentals
January 11, 2030 - December 8, 2025PL-300 — Microsoft Power BI Data Analyst (Active)
January 11, 2030 - December 8, 2025ITIL v3 Foundation
January 11, 2030 - December 8, 2025MOS (Excel Expert & Suite 2010→2019)
January 11, 2030 - December 8, 2025DP-900 — Azure Data Fundamentals
January 11, 2030 - December 8, 2025PL‑300 — Microsoft Power BI Data Analyst
January 11, 2030 - December 8, 2025ITIL v3 Foundation
January 11, 2030 - December 8, 2025MOS (Excel Expert & Suite 2010→2019)
January 11, 2030 - December 8, 2025DP-900 — Azure Data Fundamentals (Studying)
January 11, 2030 - December 8, 2025PL-300 — Microsoft Power BI Data Analyst
January 11, 2030 - December 8, 2025ITIL v3 Foundation
January 11, 2030 - December 8, 2025MOS (Excel Expert & Suite 2010→2019)
January 11, 2030 - December 8, 2025DP-900 Azure Data Fundamentals (Studying)
January 11, 2030 - December 8, 2025Industry Experience
Government, Professional Services, Software & Internet
Experience Level
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Expert
Intermediate
Intermediate
Beginner
Beginner
Hire a Programmer
We have the best programmer experts on Twine. Hire a programmer in Kingston today.