Senior Data Architect

PATH

Senior Data Architect modernizing Alberta justice data marts into an integrated enterprise data warehouse. Designing ETL, Power BI testing, data models, governance, and reporting architecture.

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

Core Competencies

Role fit

Core Competencies

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

Demonstrates senior-level data architecture capabilities, including expertise in data profiling, ETL process development, and Power BI report creation. Proficient in establishing data architecture principles and managing enterprise data requirements while ensuring data quality and governance.

Highest-signal resume keywords

Data Architecture CapabilityExtract Transform Load (ETL) DevelopmentPower BI Report DevelopmentData Profiling and Quality AssuranceEnterprise Data Requirements 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 ProfilingETL ProcessesData Warehouse DesignData ModelingMapping SpecificationsQuality Assurance TestingData Redundancy ReductionTransition PlanningData Architecture PrinciplesData Governance

Soft Skills

CommunicationConsultancyFeedback ProvisionCollaboration

Tools & Technologies

Power BI

Industry Keywords

Enterprise ArchitectureGovernment of Alberta Enterprise Architecture (GAEA)Data Architecture FrameworkData Quality ImprovementData Models

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 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, methods, models, standards, guidelines, and plans
Encourage data models and practices that reduce redundancy through reuse and sharing
Identify and document enterprise data requirements
Encourage 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 information, advice, guidance, and consultancy to initiatives and projects aligning with the data architecture
Establish and participate in design and architectural reviews
Support other members of the enterprise architecture team as required

Requirements

What you’ll need

Senior-level data architecture capability
Experience reviewing and profiling data marts and database tables
Ability to analyze and create design and mapping specifications
Knowledge of dimensions and facts in data warehouse design
Experience developing and testing Extract Transform Load (ETL) processes
Power BI report development experience
Experience testing dimensions and facts for quality assurance
Experience updating data models and adding fact attributes
Knowledge of enterprise data requirements and data governance
Ability to develop data architecture principles, strategies, models, standards, guidelines, and plans
Knowledge of data redundancy reduction through reuse and sharing
Ability to develop transition plans for current and future-state data
Understanding of Government of Alberta Enterprise Architecture (GAEA) data architecture and IMT strategies
Experience with enterprise architecture frameworks and solution design and delivery methods

Benefits

Comp & perks

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