Senior Data Architect — EDW & Power BI (Remote Canada)

Analyst Technical Solutions; Edmonton; Hybrid; CAD 120,000 - 150,000; Full time

Job summary

The Government of Alberta is seeking a Senior Data Architect to lead data architecture, modelling, profiling, and data warehouse activities for the JIMS 3.0 project. You will assess existing data marts, define future-state architecture, develop data models and mapping specifications, and ensure data quality across Dimensions and Facts within the EDW.

You will collaborate with stakeholders and technical teams, support ETL/ELT development, and contribute to Power BI validation reporting, data

Qualifications

• Post-secondary degree or diploma in Computer Science, Information Technology, Cybersecurity, Data Management or related discipline.
• Structured training in SQL or structured query languages.
• Cloud computing training completed within the past 5–10 years.

Responsibilities

• Define, document, and manage data architecture principles, strategies, standards, models, guidelines, and design practices.
• Review and assess existing data marts and reporting architectures.
• Perform detailed data profiling and analysis of source and target data structures.
• Identify and define required Dimensions and Facts for the Enterprise Data Warehouse.
• Develop detailed data mapping and design specifications.
• Support the development and testing of ETL/ELT processes.
• Develop and validate data models using enterprise data architecture and dimensional modelling principles.
• Support staging and transformation of required data.
• Update existing JOIN data models to accommodate new Fact attributes.
• Perform quality assurance and testing of Dimensions, Facts, and data warehouse components.
• Develop Power BI reports and visualizations to support data validation and testing.
• Identify opportunities to improve data quality, reuse, sharing, and governance.
• Develop transition plans to move current-state data toward the desired future-state architecture.
• Provide architecture guidance and consulting to project teams and stakeholders.
• Participate in data architecture and solution design reviews.
• Ensure alignment with Government of Alberta enterprise architecture and IMT strategies.
• Address data architecture scope extensions and provide recommendations.
• Provide technical guidance, advice, and consultancy to initiatives aligning with enterprise data architecture.

Skills

Data architecture

Dimensional modelling

Data profiling

ETL/ELT

Power BI

Stakeholder communication

Data governance

Education

Post-secondary degree or diploma in CS/IT/Data Management

SQL training

Cloud computing training

Tools

SAP/Sybase PowerDesigner

JOIN/JIMS

Job description

The Government of Alberta is seeking a Senior Data Architect to lead data architecture, modelling, profiling, and data warehouse activities for the JIMS 3.0 project. You will assess existing data marts, define future-state architecture, develop data models and mapping specifications, and ensure data quality across Dimensions and Facts within the EDW.

You will collaborate with stakeholders and technical teams, support ETL/ELT development, and contribute to Power BI validation reporting, data