About the Role
Our public sector client is seeking an Intermediate Data Architect for a 6-month, full time contract, with the possibility of up to a 3-month extension. The Data Architect will be required on a full time basis (7.25 hour work day, 36.25 hours/week) and will work with the client’s team that requires the support of contingent labour to support a data integration project aimed to re-design and implement several reporting data marts, with conformed dimensions, containing court data into an Enterprise Data Warehouse (EDW) and a set of dependent views.
The position will be responsible for performing technical strategic functions, ensuring the architecture supports the client’s data analytics and reporting needs. Additionally, this role may support application of the Data Fabric architecture, data quality, data standards, and best practices to development as needed.
Responsibilities will include:
The successful candidate is expected to have a broad skill set and be capable of performing diverse functions and activities, including but not limited to:
Understanding of data warehouse design principles, including dimensional modeling, star schemas, snowflake schemas, and the use of conformed dimensions to ensure consistency across data marts.
Create both logical and physical data models that efficiently store data and support business processes.
Support the development and adoption of best practices for data management, integration and common data management, and standardized methodologies.
Contribute to development of individual data architectures and data quality practices, as needed, to support business objectives.
Work with datasets using ETL (Extract, Transform, Load) tools and techniques for integrating data from various sources into the EDW.
Interact with clients/partners (client-internal and/or external).
Duties:
Design the data architecture, including the EDW structure, data marts, and conformed dimensions, to support reporting and analytical needs.
Develop logical and physical data models for the EDW and data marts, ensuring they are optimized for performance and aligned with business processes.
Plan and oversee the integration of data from various sources into the EDW, designing ETL processes that ensure data quality and consistency.
Establish data governance policies and practices to manage data access, quality, and security throughout the project.
Support the development, adoption, and implementation of best practices in data management, which includes data architecture, data sharing, data integration, data quality, common data, and standardized methodologies.
Lead or assist in communicating activities surrounding the Data architecture.
Document the data architecture, models, and processes, and ensure knowledge transfer to IT and business teams for ongoing operations and maintenance.
Contribute to development of data sharing, data integration, data quality, common data and standardized methodologies.
Participate in design reviews, regular or ad-hoc architectural reviews – ensuring correct interpretation of the data architecture.
Respond to requests for extensions to the scope of the data architecture, as needed.
Work with developers and supporting information technology (IT) resources to manage ongoing data assets and process changes, as needed.
Work with IT and business stakeholders to ensure the data architecture meets business requirements and is aligned with the organization’s strategic goals.
Deliverables:
- Specific deliverables and due dates will be determined by the client team.
- Status reports - weekly and monthly.
Equipment requirements:
Resource must provide their own computer and related equipment. The computer's operating system must be a modern version of Windows or MacOS that is compatible with Azure Virtual Desktop (AVD) and related software for remote access. Windows is preferred due to better compatibility. AVD/remote-related software will be installed on the resource's computer.
Working Hours
Standard Hours of work are 08:15 – 16:30 Alberta time, Monday through Friday excluding holidays observed by the Province.
Work must be done from within Canada, due to network and data security issues.
It is anticipated the role will be 100% remote, however in the event of an onsite meeting (potentially 3-4 times/month), the client/Handis Consulting does not pay for travel to attend on-site meetings, nor any expenses related to relocation, commuting, housing/accommodation, food/drink.
Requirements
Requirements:
Education
The proposed resource must meet or exceed one of the following:
University graduation in business, management or a related discipline and 2-yr Data Architect (DA) experience; OR
2-yr diploma in business, management or a related discipline and 4-yr DA experience; OR
1-yr certificate in business, management or a related discipline and 5-yr DA experience; OR
6-yr DA experience
Other
Proposed resource has agreed to a Criminal Records Check and Enhanced Security Clearance including a credit check prior to commencement
Work Experience
2 years experience dealing with clients and explaining complex data principles in a thoughtful manner
2 years experience designing, planning, implementing and supporting enterprise solution databases in an environment equivalent in size and complexity to an enterprise client
2 years experience documenting enterprise solution databases in an environment equivalent in size and complexity to an enterprise client
5 years experience in performing threat and risk assessments and presenting recommendations for risk mitigation to senior management
6 years experience with enterprise architecture principles and associated best practices, methods, standards, tools, policies, and processes
6 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 directly with clients, and coordinating with both external stakeholders and internal business areas to ensure communications are relayed to all parties
.5 years of experience working with Justice Courts data marts or data warehousing
Other Work Experience
2 years experience of direct, hands-on experience with design and implementation of data security, data privacy, policies, data de-identification/anonymization, data audits/reviews, synthetic data
2 years experience and understanding of software quality assurance QA, Testing and Defect Lifecycle
2 years experience designing and implementing enterprise architecture database plans and models that help align an organization's data, information or technology with it's required business capabilities in a large enterprise IT environment equivalent size and complexity to an enterprise client
2 years experience in Agile Projects
3 years experience in using a tool for architecture models such as: PowerDesigner, ER Studio, Er-win, BPwin, Rational Rose
2 years experience providing leadership, planning, estimating, and presentations of ideas and solutions
2 years experience with building, testing and deploy Artificial Intelligence models and knowledge of Artificial Intelligence Infrastructure
1 year experience with cloud computing or big data platforms and infrastructure
1 year experience working in or for the public sector
2 years experience working with querying data with Microsoft Transact-SQL Server
2 years experience with advanced Data Warehouse and business Intelligence planning, and architecture skills in Microsoft technology stack
Standard and Enhanced Background Check
The contractor shall, prior to commencement of the Services, provide the client, on its request and at no cost to the client, with criminal record checks.
An Enhanced Security Clearance will be required for this position, which will be coordinated by the client only for this position. Enhanced Security Clearance includes a standard Criminal Records Check and enhanced security including a Credit Check.
Resource References
Three references, for whom similar work has been performed, must be provided. The most recent reference should be listed first. Reference checks may or may not be completed to assist with scoring of the proposed resource by the client.
SUBMISSION MUST INCLUDE:
• RESUME
• ALL REQUIRED EXPERIENCE MUST BE DESCRIBED IN RESUME UNDER THE JOB/PROJECT WHERE EXPERIENCE WAS ATTAINED.
• RESOURCE REFERENCES
KEYWORDS TO INCLUDE IN DETAILED WORK EXPERIENCES: COMPLEX DATA PRINCIPLE EXPLANATION; DESIGN, PLANNING, IMPLEMENTATING and SUPPORTING ENTERPRISE SOLUTION DATABASES; THREAT AND RISK ASSESSMENTS WITH RECOMMENDATIONS; RISK MITIGATION PRESENTATIONS; ENTERPRISE ARCHITECTURE PRINCIPLES; Cognos BI Suite, Microsoft SQL Server Services, MS Power BI (Query, View) or MicroStrategy; JUSTICE COURTS
About the Company