Senior Data Architect [Data Warehousing, Kimball, ETL]

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

Senior Data Architect [Data Warehousing, Kimball, ETL]

Job Description :Our Client is looking for a Senior Data Architect in Edmonton!

Must Have Primary Skills :

• 5+ years of experience defining data architecture and using Kimball architecture to develop data marts.
• Strong experience with data profiling, including detailed profiling of tables and source data.
• Experience creating design and data mapping specifications.
• Strong knowledge of Facts and Dimensions and dimensional data modeling.
• Hands‑on experience developing and testing ETL (Extract, Transform, Load) processes.
• Experience developing Power BI reports for data validation and testing.
• Experience with SQL/database development, including T‑SQL, Oracle, and/or PL/SQL.
• Recent training in Cloud Computing, Microsoft Azure, and Azure Architecture within the past 5–10 years.
• Experience working with data marts, Enterprise Data Warehouses (EDW), and data models.
• 2+ years of experience working in or with public‑sector environments, including awareness of privacy legislation such as FOIP.Experience with data modeling tools such as PowerDesigner, ERWin, Oracle Designer, SQL Developer Data Modeler, or Microsoft Visio is an asset.
• Experience with JOIN (Justice Online Information Network) and JIMS (Justice Information Management System) is an asset.
• Experience working in court environments and understanding judicial processes is an asset.
• Strong communication skills with the ability to translate technical concepts for non‑technical stakeholders and influence decision‑ making.
• Post‑secondary degree or diploma in Computer Science, Information Technology, Cybersecurity, or a related field is strongly preferred; equivalent experience may be considered.
• Must be able to work within Canada and attend meetings/work sessions in Edmonton when required.

Nice To Have Secondary Skills :

• Experience using JOIN (Justice Online Information Network) and JIMS (Justice Information Management System) data and structures. Knowledge of business rules and processes related to judicial/court environments.
• Experience working in or with court environments, with awareness of judicial independence.
• Experience with data modeling tools such as SAP/Sybase PowerDesigner, ERWin, Oracle Designer, SQL Developer Data Modeler, or Microsoft Visio.
• Experience working with information management and cybersecurity policies, directives, and guidelines.

Proven Experience In :

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

Skills Industry experience required: Government