We are seeking a skilled Data Architect to support a critical data integration project within the Justice sector. This role will involve redesigning and implementing several reporting data marts, integrating court data into an Enterprise Data Warehouse (EDW), and ensuring the architecture aligns with business needs for analytics and reporting. The successful candidate will have expertise in data warehouse design, dimensional modeling, and ETL processes, and will contribute to establishing best practices in data governance and quality. A broad skill set, including experience with enterprise architecture and client-facing communication, is essential for success in this role.
...
Advantages
• Opportunity to work on a high-impact data integration project in the Justice sector.
• Gain hands-on experience with enterprise data architecture and advanced ETL processes.
• Contribute to the development of best practices in data governance and quality.
• Work alongside a collaborative team in a dynamic, solution-driven environment.
• Engage with internal and external stakeholders, enhancing client communication and project leadership skills.
Responsibilities
• 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.
Qualifications
Mandatory Qualifications:
• 2 years of experience dealing with clients and explaining complex data principles in a thoughtful manner.
• 2 years of experience designing, planning, implementing, and supporting enterprise solution databases in an environment equivalent in size and complexity to the Government of Alberta.
• 2 years of experience documenting enterprise solution databases in an environment equivalent in size and complexity to the Government of Alberta.
• 5 years of experience in performing threat and risk assessments and presenting recommendations for risk mitigation to senior management.
• 6 years of experience with enterprise architecture principles and associated best practices, methods, standards, tools, policies, and processes.
• 6 years of 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 of experience working directly with clients, and coordinating with both external stakeholders and internal business areas to ensure communications are relayed to all parties.
• 0.5 years of experience working with Justice Courts data marts or data warehousing.
Desirable Qualifications:
• 2 years 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 of experience and understanding of software quality assurance QA, Testing and Defect Lifecycle.
• 2 years of 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 enterprise IT environment equivalent size and complexity to the Government of Alberta.
• 2 years of experience in Agile Projects.
• 3 years of experience in using a tool for architecture models such as: PowerDesigner, ER Studio, Er-win, BPwin, Rational Rose.
• 2 years of experience providing leadership, planning, estimating, and presentations of ideas and solutions.
• 2 years of experience with building, testing and deploying Artificial Intelligence models and knowledge of Artificial Intelligence Infrastructure.
• 1 year of experience with cloud computing or big data platforms and infrastructure.
• 1 year of experience working in or for the public sector.
• 2 years of experience working with querying data with Microsoft Transact-SQL Server.
• 2 years of experience with advanced Data Warehouse and business Intelligence planning, and architecture skills in Microsoft technology stack.
Summary
If you’re ready to make a meaningful impact on a high-profile project and bring your expertise in data architecture to a dynamic and rewarding role, we want to hear from you. Apply directly to this job ad or reach out to your Randstad Digital representative immediately!
P.S. Don’t forget that when you update your profile on Randstad.ca it helps us find you faster when we do have roles that match your skills! So even if this role isn’t for you please update your profile so we can find you!
We look forward to supporting you in your job search!
Good luck!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more
We are seeking a skilled Data Architect to support a critical data integration project within the Justice sector. This role will involve redesigning and implementing several reporting data marts, integrating court data into an Enterprise Data Warehouse (EDW), and ensuring the architecture aligns with business needs for analytics and reporting. The successful candidate will have expertise in data warehouse design, dimensional modeling, and ETL processes, and will contribute to establishing best practices in data governance and quality. A broad skill set, including experience with enterprise architecture and client-facing communication, is essential for success in this role.
Advantages
• Opportunity to work on a high-impact data integration project in the Justice sector.
• Gain hands-on experience with enterprise data architecture and advanced ETL processes.
• Contribute to the development of best practices in data governance and quality.
• Work alongside a collaborative team in a dynamic, solution-driven environment.
• Engage with internal and external stakeholders, enhancing client communication and project leadership skills.
Responsibilities
...
• 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.
Qualifications
Mandatory Qualifications:
• 2 years of experience dealing with clients and explaining complex data principles in a thoughtful manner.
• 2 years of experience designing, planning, implementing, and supporting enterprise solution databases in an environment equivalent in size and complexity to the Government of Alberta.
• 2 years of experience documenting enterprise solution databases in an environment equivalent in size and complexity to the Government of Alberta.
• 5 years of experience in performing threat and risk assessments and presenting recommendations for risk mitigation to senior management.
• 6 years of experience with enterprise architecture principles and associated best practices, methods, standards, tools, policies, and processes.
• 6 years of 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 of experience working directly with clients, and coordinating with both external stakeholders and internal business areas to ensure communications are relayed to all parties.
• 0.5 years of experience working with Justice Courts data marts or data warehousing.
Desirable Qualifications:
• 2 years 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 of experience and understanding of software quality assurance QA, Testing and Defect Lifecycle.
• 2 years of 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 enterprise IT environment equivalent size and complexity to the Government of Alberta.
• 2 years of experience in Agile Projects.
• 3 years of experience in using a tool for architecture models such as: PowerDesigner, ER Studio, Er-win, BPwin, Rational Rose.
• 2 years of experience providing leadership, planning, estimating, and presentations of ideas and solutions.
• 2 years of experience with building, testing and deploying Artificial Intelligence models and knowledge of Artificial Intelligence Infrastructure.
• 1 year of experience with cloud computing or big data platforms and infrastructure.
• 1 year of experience working in or for the public sector.
• 2 years of experience working with querying data with Microsoft Transact-SQL Server.
• 2 years of experience with advanced Data Warehouse and business Intelligence planning, and architecture skills in Microsoft technology stack.
Summary
If you’re ready to make a meaningful impact on a high-profile project and bring your expertise in data architecture to a dynamic and rewarding role, we want to hear from you. Apply directly to this job ad or reach out to your Randstad Digital representative immediately!
P.S. Don’t forget that when you update your profile on Randstad.ca it helps us find you faster when we do have roles that match your skills! So even if this role isn’t for you please update your profile so we can find you!
We look forward to supporting you in your job search!
Good luck!
Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.
Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.
show more
