Senior Data Architect — Data Warehousing & Kimball

Finney-Taylor Consulting Group Ltd.; Edmonton; On-site; CAD 110,000 - 150,000; Full time

Job summary

Finney-Taylor Consulting Group Ltd. in Edmonton is seeking a Senior Data Architect to lead data warehouse design and implementation. The role focuses on Kimball architecture for data marts, with hands-on ETL development and data modeling expertise.

You will profile data, map designs, and build robust EDW solutions while communicating complex concepts to non-technical stakeholders. Required experience includes 5+ years in data architecture, strong SQL/DB skills (T-SQL, Oracle, PL/SQL), and recent

Qualifications

• 5+ years defining data architecture and Kimball data marts.
• Strong data profiling of tables and source data.
• Design and data mapping specifications experience.
• Facts and Dimensions and dimensional data modeling knowledge.
• ETL (Extract, Transform, Load) development experience.
• Power BI reports for data validation and testing.
• SQL/database development including T-SQL, Oracle, or PL/SQL.
• Cloud Computing, Microsoft Azure, and Azure Architecture training in the last 5–10 years.
• Experience with EDW/data marts and data models.
• Experience with data modeling tools (PowerDesigner, ERWin, Oracle Designer, SQL Developer Data Modeler, Visio).
• Experience with JOIN/JIMS and court environments is a plus.

Responsibilities

• Review existing data marts and perform detailed data profiling.
• Create data design and mapping specifications.
• Define Facts and Dimensions using Kimball architecture; develop and test ETL processes.
• Develop Power BI reports for data validation and testing.
• Update data models and stage required data.
• Perform QA testing of Facts and Dimensions.
• Support data governance and data quality initiatives.
• Participate in architecture and design reviews.
• Provide data architecture guidance to stakeholders.

Skills

Kimball architecture

Data marts

Data profiling

Data mapping design

Dimensional data modeling

ETL development

Power BI reports

SQL/DB development

Azure cloud

Public-sector experience

Education

Post-secondary degree in Computer Science/IT/Cybersecurity

Tools

PowerDesigner

ERWin

Oracle Designer

SQL Developer Data Modeler

Microsoft Visio

Job description

Finney-Taylor Consulting Group Ltd. in Edmonton is seeking a Senior Data Architect to lead data warehouse design and implementation. The role focuses on Kimball architecture for data marts, with hands-on ETL development and data modeling expertise.

You will profile data, map designs, and build robust EDW solutions while communicating complex concepts to non-technical stakeholders. Required experience includes 5+ years in data architecture, strong SQL/DB skills (T-SQL, Oracle, PL/SQL), and recent