data architect - remote.

Our Edmonton client is seeking a Senior Data Architect for a long term contract to lead the modernization of their justice reporting systems. This critical initiative involves consolidating several isolated data marts into a unified enterprise data warehouse. You will drive the shift toward a faster, user friendly reporting architecture that preserves historical records and improves data governance. It is a fantastic opportunity to make a lasting impact on a large scale public sector system.

Advantages
• Remote work flexibility through Azure Virtual Desktop with full system access and credentials provided.
• Long term contract stability working on a major, high visibility public sector data integration project.
• Opportunity to work with modern reporting tools like Power BI to build interactive data solutions.
• Collaborative environment connecting with a diverse group of enterprise professionals.
• Professional growth from modernizing legacy architectures and shaping future state data models.

Responsibilities
• Define and manage the overall enterprise data architecture strategies, methods and guidelines.

• Review existing reporting data marts and perform detailed data profiling on core tables.
• Analyze data structures to create design specifications and identify dimensions for fact tables.
• Develop and test extract transform load processes to migrate legacy information.
• Build Power BI reports to support quality assurance testing of data models.
• Create transition plans that guide current assets toward the ideal future state setup.
• Establish architectural reviews to ensure project alignment with broader organizational strategies.

Qualifications
• Degree in computer science or a related field with eight years of enterprise data architect experience.
• Eight years of experience designing, planning and implementing database solutions in large, complex environments.
• Eight years documenting legacy systems and recording as built implementations after multiple iterations.
• Five years of experience working with SQL data warehouses and querying data using Transact SQL.
• Five years of experience utilizing business intelligence products such as Cognos BI and MS Power BI.

Summary
If you are a seasoned architect ready for your next challenge, 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 Voir email sur randstad.com to ensure their ability to fully participate in the interview process. show more