Data Analyst

This is a key opportunity to contribute to an enterprise-wide shift towards a data-driven, cloud-native ecosystem supporting business and technology innovation.

Advantages
Contribute to a large-scale digital transformation project using cutting-edge Azure cloud technologies
Work remotely with a skilled and collaborative team
Gain valuable experience in modern data architecture, including medallion architecture and Databricks
Long-term, full-time contract with a high-impact federal initiative
Opportunity to influence enterprise-level data strategy and design



Responsibilities
Analyze and document data requirements through document analysis and legacy ETL reverse engineering
Design and implement scalable data solutions using enterprise cloud platforms
Create and validate conceptual, logical, and physical data models aligned with organizational architecture and governance
Build and optimize data flows and pipelines, including migration of legacy data
Collaborate with data architects, information governance teams, and stakeholders to ensure alignment with enterprise standards
Communicate findings, recommendations, and technical issues clearly across various stakeholder groups

Qualifications
Required Experience and Skills
7+ years of experience in SQL programming, including code refactoring and optimization
Strong analytical skills with attention to detail and data accuracy
Proven experience in:
Reverse engineering legacy ETL builds and designing source-to-target mappings
Dimensional and relational data modeling
ETL development and modernization
Hands-on experience with:
Databricks and medallion architecture
SQL, Python, and Apache Spark
Microsoft Azure or other public cloud platforms
Agile delivery methodologies
IBM Data Manager
Strong documentation and communication skills with the ability to tailor messages for technical and non-technical stakeholders

Assets (Nice to Have)
Experience with ERWIN or similar data modeling tools
Familiarity with Denodo data virtualization
Experience developing reports with Power BI
Bilingualism in English and French

Summary
If you are an experienced data analyst with a passion for solving complex data challenges in a modern, cloud-based environment, we encourage you to apply.

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.