Data Architect

Data Architect

Back to All Jobs
[social_share]

Our client requires a Data Architect to join the client’s Justice Information Management System (JIMS) 3.0 project, a data integration project aimed to amalgamate, re-design and implement several disjointed reporting data marts containing court data into an Enterprise Data Warehouse (EDW) and a set of dependent data mart and views. This project will replace the existing six stand-alone IBM Cognos BI data marts JIMS, Crown File Ownership (CFO), Court Case Management (CCM), Courtroom Utilization, Courtroom Activity, and Case Adjournment) with a well-integrated data warehouse. The existing data marts extract, process, re-structure and aggregate data required for strategic, operational and ad hoc reporting of court data stored in the Justice Online Information Network (JOIN) database. The goal of the project is to evolve availability, governance and reporting of court data by implementing a more efficient, user-friendly, faster and cost-effective reporting architecture

This Data Architect will review existing data marts, perform detailed data profiling, analyze and create design and mapping specifications, identify Dimensions required for Facts, and complete detailed data profiling of tables included in Facts. The data architect will then develop and test Extract Transform Load (ETL) processes, develop Power BI reports for testing for several Dimensions, test Dimensions and Fact for quality assurance update JOIN as-is data models for new Fact attributes, stage the required data address minor fixes in delivered data marts, and provide feedback and lessons learned at project close out.

Resource will work remotely but must be available to be on-site when requested for meetings. Work must be done from within Canada, due to network and data security issues. Resource is responsible to pay for travel to on-site meetings.

Edmonton, Alberta (Remote within Canada)

Mandatory Requirements

• College or Bachelor degree in Computer Science or a related field of study.
• 8 years’ experience designing, planning, implementing and supporting enterprise solution databases in a large and complex environment.
• 8 years’ experience documenting enterprise solution of legacy databases by recording the “as built” implementations after multiple iterations in a large and complex environment.
• 3 years’ experience in performing threat and risk assessments and presenting recommendations for risk mitigation to senior management.
• 8 years’ experience with enterprise architecture principles and associated best practices, methods, standards, tools, policies, and processes.
• 8 years’ experience working as a Data Architect designing and implementing enterprise database solutions within a large and complex organization.
• Experience providing leadership, planning, estimating, and presentations of ideas and solutions.

Desirable Requirements

• Certification in The Open Group Architecture Framework (TOGAF).
• 5 years’ experience designing and implementing enterprise architecture database plans and models that help align an organization’s data, information or technology with its required business capabilities in a large and complex enterprise IT environment.
• 2 years’ experience in using a tool for architecture models such as: PowerDesigner, ER Studio, Er-win, BPwin, Rational Rose.
• 3 years’ experience project managing application development projects using Agile sprint development.
• 5 years’ experience with cloud computing or big data platforms and infrastructure.
• 5 years’ experience with enterprise business intelligence and performance management products. Specifically Cognos BI Suite, Microsoft SQL Server Services, MS Power BI (Query, View) or MicroStrategy.
• 5 years’ experience working as a Data Architect in a large and complex enterprise IT environment.
• 5 years’ experience working with developing SQL databases.
• 5 years’ experience working with implementing a SQL data warehouse.
• 5 years’ experience working with querying data with Transact-SQL.
• Ability to learn quickly, problem solve/troubleshoot, work independently and in a team.
• Ability to manage conflict.
• Ability to manage stress.
• Ability to work with minimum mentoring.
• Excellent verbal and written communication skills and ability to interact and collaborate professionally with a diverse group.