Data Architect - REMOTE

Are you an experienced Senior Data Architect ready to modernize complex reporting systems and build enterprise-grade data warehouse solutions? Our Edmonton client is seeking a skilled technical professional to join their team for an initial 12-month contract with remote flexibility. In this role, you will assist in modernizing court reporting structures, consolidating legacy data marts into a centralized Enterprise Data Warehouse, and improving data governance across key public sector initiatives.

Advantages
• Work with remote flexibility while contributing to high-priority public sector modernization efforts.
• Design modern enterprise data architectures utilizing Azure cloud services and Kimball methodology.
• Drive meaningful improvements in data governance, reporting speeds, and historical data preservation.
• Collaborate with a supportive enterprise architecture team committed to quality technical solutions.
• Expand your professional portfolio by centralizing legacy systems into a unified reporting warehouse.

Responsibilities
• Review existing data marts and complete detailed data profiling across legacy database structures.
• Facilitate the effective definition and management of data architecture principles, strategies, and design standards.
• Promote reusable data models and practices that reduce data redundancy across enterprise systems.
• Analyze and create design mapping specifications, identifying required dimension and fact tables.
• Develop and test Extract Transform Load processes while staging required data for reporting structures.
• Create interactive Power BI reports to support quality assurance testing across dimensions and facts.
• Provide technical guidance, advice, and architectural reviews to project teams to ensure framework compliance.

Qualifications
• At least 5 years of experience defining data architecture and using Kimball architecture to develop data marts.
• Proven hands-on experience with SQL languages including Microsoft T-SQL, Oracle, PL/SQL, and database development.
• Relevant training completed within the past 5 to 10 years focused on Cloud Computing, Microsoft Azure, and Azure Architecture.
• Minimum 2 years of experience working within public-sector environments with awareness of FOIP legislation.
• Post-secondary degree or diploma in Computer Science, Information Technology, or equivalent field experience.

Summary
If you are a Senior Data Architect looking for an exciting new contract opportunity, 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 [email protected] to ensure their ability to fully participate in the interview process.