Statistics Canada
GovTech
ProjectStatistics Canada
Year2014
CategoryGovTech
A backend data engineering initiative to maintain and optimize the statistical systems used by the Federal Government's transportation department.
The Challenge
The transportation team required more efficient methods to organize, query, and analyze vast amounts of statistical data for weekly research and planning.
Our Solution
We designed and developed optimized Microsoft SQL database procedures and conducted weekly technical presentations to align code implementation with the department's research goals.
Key Results
- Designed and developed critical Microsoft SQL database procedures for the federal government
- Optimized the organization of statistical systems through rigorous testing and debugging
- Presented research and code optimization plans to the transportation team on a weekly basis
Tech Stack
SQL Server