Over 10 years we help companies reach their financial and branding goals. Engitech is a values-driven technology agency dedicated.
411 University St, Seattle, USA
engitech@oceanthemes.net
+1 -800-456-478-23
Justice Information Management System (JIMS) . 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 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 • Reporting lag • Preservation of historical data • Improved data governance This Senior Data Architect role will: • 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.
Data Architect provides architectural and technical expertise, leadership, project management and services related to data management to improve the quality, security, effectiveness and value of data and information. Responsibilities include the following but are not limited to: • Provide advice and consulting services regarding data management strategies, data architecture, and ministry data. • Consult with project stakeholders on an ongoing basis. • Assist in developing project plans, schedules, and estimates pertaining to architectural deployment and services delivery. • Assist in developing task lists and resource assignments within the context of architectural planning. • Document technical recommendations; provide technical advice and guidance to management, operations and project team members and within shared IT services. • Ensure change management processes are followed. • Make recommendations to project team members pertaining to issues, risks and client satisfaction. • Provide tracking and reporting of time and status on all work as required.
| Description of Skill | Min Years of Experience |
|---|---|
| M1 - Proposed resource must be submitted at an hourly rate of $xx.xx per hour or less for all possible terms. Note that proposed rates which are lower than this maximum rate will receive a higher score in evaluation. *Select 'Verified' for YES, 'Not Verified' for NO. | 0.0 |
| M2 - The proposed resource must meet or exceed one of the following: • University graduation in business, management or a related discipline and 6-yr Data Architect (DA) experience; OR • 2-yr diploma in business, management or a related discipline and 8-yr DA experience; OR • 1-yr certificate in business, management or a related discipline and 9-yr DA experience; OR • 10-yr DA experience | 6.0 |
| M3 - Experience designing, planning, implementing and supporting enterprise solution databases in an environment equivalent in size and complexity to the Government of Alberta. | 8.0 |
| M4 - Experience documenting enterprise solution databases in an environment equivalent in size and complexity to the Government of Alberta. | 8.0 |
| M5 - Experience with the Government of Alberta Enterprise Architecture or similar corporate architectures, and all associated best practices, methods, standards, tools, policies, and processes. | 8.0 |
| M6 - Experience with enterprise business intelligence and performance management products. Specifically Cognos BI Suite, Microsoft SQL Server Services, MS Power BI (Query, View) or MicroStrategy. | 8.0 |
| M7 - Experience working as a data architect in an enterprise IT environment equivalent in size and complexity to the Government of Alberta. | 5.0 |
| M8 - Experience communicating with stakeholders at all levels within an organization. | 5.0 |
| M9 - Experience in performing threat and risk assessments and presenting recommendations for risk mitigation to senior management. | 5.0 |
| Description of Skill | Min Years of Experience |
|---|---|
| D1 - Experience providing leadership, planning, estimating, and presentations of architecture ideas and solutions. | 5.0 |
| D2 - Experience and technical knowledge of SQL server architecture. | 5.0 |
| D3 - Experience and technical knowledge of querying data with Transact-SQL. | 5.0 |
| D4 - Experience with building, testing and deploy Artificial Intelligence models and knowledge of Artificial Intelligence Infrastructure | 5.0 |
| D5 - Experience in architecture reviews of application system design | 5.0 |
| D6 - Experience in Agile Projects | 5.0 |
| D7 - Experience in using a tool for architecture models such as: PowerDesigner, ER Studio, Er-win, BPwin, Rational Rose. | 3.0 |
| D8 - Experience with cloud computing or big data platforms and infrastructure. | 1.0 |
| D9 - Experience working in or for the public sector. | 3.0 |
| D10 - Experience with advanced Data Warehouse and business Intelligence planning, and architecture skills in Microsoft technology stack. | 5.0 |
| D11 - Do you have related Canadian education (e.g. certificate, diploma or degree) or your foreign credentials certified by Immigration Canada, IQAS or any accreditation acceptable to the Government of Canada or Alberta? Provide information regarding certification of foreign credentials. *Enter “1” for “Yes” and “0” for “No”. | 1.0 |
