Are you a Senior Data Architect looking to shape enterprise data systems and modernize public infrastructure? Our Edmonton client is seeking an experienced professional for an initial 12-month remote contract to lead the transformation of court reporting data marts into a unified enterprise data warehouse. This high-impact role allows you to optimize data governance, rebuild reporting models, and improve analytical accessibility for critical public-sector systems.
...
Advantages
• Enjoy the flexibility of a remote work setup based out of Edmonton.
• Modernize legacy reporting architecture into a clean enterprise data warehouse.
• Collaborate with public sector teams to enhance data governance standards.
• Work with modern technologies including Power BI, SQL Server, and Microsoft Azure Virtual Desktop.
• Build solutions that preserve valuable historical records and improve reporting speed.
Responsibilities
• Conduct detailed profiling of legacy data marts and map specifications for the enterprise data warehouse.
• Identify required dimensions for facts and complete detailed data table profiling.
• Develop and test extract transform load processes to move data efficiently.
• Build and test Power BI reports to validate quality assurance across dimensions and facts.
• Design and manage enterprise data architectures, standards, and mapping models.
• Establish and participate in architectural reviews to ensure alignment with organizational goals.
• Create transition plans that guide existing data structures to their future state.
Qualifications
• Post-secondary degree or diploma in Computer Science, Information Technology, or a related field.
• At least 2 years of experience in public sector environments with knowledge of privacy rules like FOIP.
• At least 5 years of experience in data architecture assessment, data profiling, and data mart design.
• At least 5 years of experience using data modeling tools such as PowerDesigner, ERWin, or Visio.
• Hands-on experience with SQL Server, SSIS, Power BI, and judicial database processes.
Summary
If you are ready to bring your enterprise data architecture expertise to a transformative public project, we want to hear from you. Please 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
Are you a Senior Data Architect looking to shape enterprise data systems and modernize public infrastructure? Our Edmonton client is seeking an experienced professional for an initial 12-month remote contract to lead the transformation of court reporting data marts into a unified enterprise data warehouse. This high-impact role allows you to optimize data governance, rebuild reporting models, and improve analytical accessibility for critical public-sector systems.
Advantages
• Enjoy the flexibility of a remote work setup based out of Edmonton.
• Modernize legacy reporting architecture into a clean enterprise data warehouse.
• Collaborate with public sector teams to enhance data governance standards.
• Work with modern technologies including Power BI, SQL Server, and Microsoft Azure Virtual Desktop.
• Build solutions that preserve valuable historical records and improve reporting speed.
Responsibilities
• Conduct detailed profiling of legacy data marts and map specifications for the enterprise data warehouse.
• Identify required dimensions for facts and complete detailed data table profiling.
• Develop and test extract transform load processes to move data efficiently.
...
• Build and test Power BI reports to validate quality assurance across dimensions and facts.
• Design and manage enterprise data architectures, standards, and mapping models.
• Establish and participate in architectural reviews to ensure alignment with organizational goals.
• Create transition plans that guide existing data structures to their future state.
Qualifications
• Post-secondary degree or diploma in Computer Science, Information Technology, or a related field.
• At least 2 years of experience in public sector environments with knowledge of privacy rules like FOIP.
• At least 5 years of experience in data architecture assessment, data profiling, and data mart design.
• At least 5 years of experience using data modeling tools such as PowerDesigner, ERWin, or Visio.
• Hands-on experience with SQL Server, SSIS, Power BI, and judicial database processes.
Summary
If you are ready to bring your enterprise data architecture expertise to a transformative public project, we want to hear from you. Please 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
