Data Architect - Senior

TEKsystems • Edmonton, AB

2d • CA$110 - CA$110 • Remote

About The Position

The project is 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 the availability, governance, and reporting of court data by implementing a more efficient, user-friendly, faster, and cost-effective reporting architecture. The following benefits will be realized through the project: Integrated and dynamic architecture, Interactive reporting, Reduced reporting lag, Preservation of historical data, and Improved data governance.

Requirements

• Attestation - Conflict of Interest: Yes
• College or Bachelor degree in Computer Science or a related field of study: Yes
• 8 years of experience in enterprise solution architecture, design, implementation, and support
• 8 years of experience documenting enterprise solution databases in an environment equivalent in size and complexity
• 3 years of experience in performing threat and risk assessments and presenting recommendations
• 8 years of experience with enterprise architecture principles and associated best practices
• Experience providing leadership, planning, estimating, and presentations of ideas and solutions

Nice To Haves

• Certification in The Open Group Architecture Framework (TOGAF)
• Ability to learn quickly, problem solve/troubleshoot, work independently and in a team
• Ability to manage conflict
• 5 years of experience designing and implementing enterprise architecture database plans and models
• 2 years of experience using a tool for architecture models such as: PowerDesigner, ER Studio
• 3 years of project managing application development projects using Agile sprint methodology
• 5 years of experience with cloud computing or big data platforms and infrastructure
• 5 years of experience with enterprise business intelligence and performance management products
• 5 years of experience working as a Data Architect in an enterprise IT environment equivalent in size and complexity
• 5 years of experience working with developing SQL databases
• 5 years of experience working with implementing a SQL data warehouse
• 5 years of experience working with querying data with Transact-SQL

Responsibilities

• 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 for several Dimensions
• Testing of 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
• Provide feedback and lessons learned at project close out
• Facilitate the effective definition and management of the data architecture (principles, strategies, methods, models, standards, guidelines, plans, etc.)
• Encourage data models and practices that reduce data redundancy by promoting reuse/sharing in keeping with the IMT strategy
• Identify and document enterprise data requirements
• Encourage practices that improve data quality
• Develop and lead the transition plans that will guide current data to its ideal future state
• Lead or assist in communication activities surrounding the Sectors and Government of Alberta Enterprise Architecture (GAEA) data architecture
• Contribute to the definition and development of the enterprise architecture framework and associated corporate solution design and delivery methods, thus improving the proactive alignment of data architecture
• Respond to requests for extensions to the scope of the data architecture
• Provide information, advice, guidance, and consultancy to initiatives/projects that are defining or aligning to the data architecture, thus promoting compliance to the data architecture and IMT strategies
• Establish and participate in design reviews, regular or ad-hoc architectural reviews, ensuring correct interpretation of the data architecture and IMT strategies
• Provide support to other members of the enterprise architecture team as required

Benefits

• The fixed rate quoted must be inclusive of all overhead, office space and equipment including supplies, administrative burden, mark-up and all other costs to perform the Services for the duration of the Contract.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior