Must-Have / Important Skill Set Data Architecture &

• Enterprise Architecture – Solid 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.

Strong 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 Security Architect (Edmonton)
🏢 ThoughtStorm
📍 Edmonton