Senior Data Architect

PATH

Senior Data Architect integrating Alberta court data marts into an enterprise data warehouse. Designing ETL, data models, governance practices, and Power BI validation reports.

Posted 8/15/2026full-timeRemote • 🇨🇦 CanadaSeniorWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates extensive experience in data architecture, including data profiling, ETL process development, and Power BI report creation. Proficient in managing data quality and governance while aligning with enterprise architecture frameworks.

Highest-signal resume keywords

Data Architecture ExperienceETL Process DevelopmentPower BI Report DevelopmentData Quality ManagementData Governance Knowledge

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data ProfilingData Design SpecificationsMapping SpecificationsJOIN Data ModelsFact TablesDimensions in Data WarehousingData Architecture StandardsData Quality PracticesEnterprise Data RequirementsData Architecture Frameworks

Soft Skills

Communication SkillsConsultancy SkillsFeedback Provision

Tools & Technologies

Power BIETL Tools

Industry Keywords

Data MartsData GovernanceEnterprise ArchitectureSolution DesignData Quality

Tech Stack

Tools & technologies

ETL

About the role

Key responsibilities & impact

Review existing data marts
Perform detailed data profiling
Analyze and create design and mapping specifications
Identify dimensions required for facts
Complete detailed data profiling of tables included in facts
Develop and test Extract Transform Load (ETL) processes
Develop Power BI reports for testing several dimensions
Test dimensions and facts for quality assurance
Update JOIN as-is data models for new fact attributes
Stage the required data
Address minor fixes in delivered data marts
Provide feedback and lessons learned at project closeout
Facilitate the effective definition and management of data architecture, including principles, strategies, architectures, methods, models, standards, guidelines, and plans
Promote data models and practices that reduce redundancy through reuse and sharing
Identify and document enterprise data requirements
Promote practices that improve data quality
Develop and lead transition plans guiding current data to its ideal future state
Lead or assist communication activities concerning Sectors and Government of Alberta Enterprise Architecture data architecture
Contribute to the enterprise architecture framework and corporate solution design and delivery methods
Respond to requests for extensions to the data architecture scope
Provide advice, guidance, and consultancy to initiatives and projects aligning with the data architecture
Establish and participate in design and architectural reviews
Support other enterprise architecture team members as required

Requirements

What you’ll need

Senior-level data architecture experience implied by the role title
Experience reviewing and profiling data marts and fact tables
Experience creating data design and mapping specifications
Knowledge of dimensions and facts in data warehouse architecture
Experience developing and testing ETL processes
Experience developing Power BI reports
Experience with JOIN data models and court data reporting architecture
Knowledge of data governance, enterprise data requirements, data quality, and data architecture standards
Knowledge of enterprise architecture frameworks and solution design and delivery methods

Benefits

Comp & perks

Integrated and dynamic architecture
Interactive reporting
Reduced reporting lag
Preservation of historical data
Improved data governance