Must-Have / Important Skill Set

Data Architecture &

- Enterprise Architecture – Strong experience in data architecture, architecture assessment/risk assessment, data architecture standards, principles, and transition planning.

Data Warehousing &

- Data Marts – Hands-on experience with Enterprise Data Warehouse (EDW), data marts, data warehouse architecture, and data integration.

Data Modeling &

- Dimensional Modeling – Strong experience with data modeling, Fact &
- Dimension design, dimensional models, data structures, business rules, and mapping specifications.

ETL &

- Data Integration – Strong hands-on experience developing and testing ETL processes, preferably with SQL Server Integration Services (SSIS).

Data Profiling &

- Data Quality – Experience with detailed data profiling, data validation, data quality, data analysis, and source-to-target data mapping.





SQL / Database Technologies – Strong SQL and SQL Server experience, with knowledge of database design/administration and reporting technologies such as SSRS.

Data Modeling Tools &

- Public Sector Experience – Experience with tools such as PowerDesigner, ERWin, Oracle Designer, SQL Developer Data Modeler, or Visio, along with public-sector/government experience and understanding of privacy/information-management requirements.

Solid Advantage: Experience with JOIN/JIMS, court/justice data, judicial processes, Public Sector, or related government justice-sector environments. This position is listed remote with Occasion onsite meetings in Edmonton Alberta (3-4 times in a Year &

- It is a part time contract role for 1 Year with 24 months possible ext)

📌 Senior Data Architect (Edmonton)
🏢 ThoughtStorm
📍 Edmonton