Senior Data Architect, EDW & Governance

Pathlion; Edmonton; Remote; CAD 120,000 - 170,000; Full time

Job summary

Pathlion is seeking a Senior Data Architect to lead the design, profiling, and integration of data across JIMS 3.0. You will craft mapping specs, refine data marts, and oversee ETL development, ensuring quality data delivery to enterprise reporting layers.

You willpartner with IT and business teams to update data models, implement governance, and support Power BI reporting for multiple dimensions and tests.

Qualifications

• Experience in enterprise data architecture and data warehouse design.
• Ability to review data marts and create mapping specifications.
• Proven track record in ETL development and quality assurance.

Responsibilities

• Review existing data marts and perform detailed data profiling.
• Analyze and create design and mapping specifications.
• Develop and test ETL processes and Power BI reports.
• Update data models and address data-quality issues.
• Provide guidance on enterprise data architecture standards.

Skills

Data modeling

ETL design

Data profiling

Data governance

SQL / data warehouse

BI reporting

Education

Bachelor's degree in CS/IS

Tools

Power BI

Job description

Pathlion is seeking a Senior Data Architect to lead the design, profiling, and integration of data across JIMS 3.0. You will craft mapping specs, refine data marts, and oversee ETL development, ensuring quality data delivery to enterprise reporting layers.

You willpartner with IT and business teams to update data models, implement governance, and support Power BI reporting for multiple dimensions and tests.