Senior Software Developer - Snowflake

Our client, a leading organization in the insurance and financial services sector, is seeking a Senior Software Developer to join their data and analytics team.

This role focuses on the development and technical support of a major data retention project. You will work within a rich technological environment, leveraging both modern cloud platforms and traditional on-premises databases.

This is a 9-month contract starting in late March and ending in December 2026, with strong possibilities for subsequent renewal. The position operates on a hybrid model, requiring an office presence two days a week. Candidates can be based out of the Montreal, Toronto, or Saint-Hyacinthe offices.

Advantages
Enjoy a stable contract through the end of the year with excellent extension potential.

Benefit from hybrid flexibility within a highly stimulating work environment.

Work with cutting-edge data architectures combining cloud and on-premises solutions.

Evolve within a multidisciplinary team that fosters innovation and autonomy.

Responsibilities
Actively support the development of the data retention project across the cloud platform and on-premises infrastructures.

Ensure seamless data integration and transformation for data warehouses and data marts.

Leverage extraction, transformation, and loading techniques to optimize information flows.

Provide second-level production support to guarantee the stability and performance of delivered solutions.

Remain open to and adopt emerging technologies for code automation, testing, and continuous deployments.

Collaborate effectively within a multidisciplinary team navigating a complex technological landscape.

Qualifications
Bachelor's degree in information technology, software engineering, or an equivalent combination of training and relevant experience.

5 to 8 years of overall experience in software development and data integration.

5 to 8 years of practical experience with Informatica solutions.

Strong technical expertise with Snowflake cloud databases and SnowSQL programming.

Strong experience with Oracle databases and PL/SQL programming.

Mastery of data extraction, transformation, and loading techniques.

Strong overall experience with SQL programming.

Concrete experience with Data Vault modeling and relational data models.

Perfect bilingualism in French and English is required for effective communication.

Innovative mindset, versatility, high autonomy, and the ability to learn quickly.

Knowledge of the insurance or financial services sector is considered an advantageous asset.

Experience with IICS, AWS S3, Lambda, JAVA, GIT, Jenkins, Business Objects, and Power BI is a strong asset.

**Our client operates in Canada. The company takes all reasonable steps to limit the number of positions in Quebec that require knowledge of a language other than French, and only requires it when necessary and its existing bilingual employees are unable to perform these duties.

Based on an assessment conducted by our client, it has been determined that this position requires candidates to be fluent in English (both spoken and written). In particular, this position will require the employee to interact with centralized internal departments (e.g., Operations / HR / Finance / Legal / Contracts / Sales) that support the organization in Canada and that do not speak French.**


Summary
We are looking for a Senior Software Developer with a deep passion for data integration and cloud environments. If you master Snowflake, Oracle, and Informatica, and are looking for a hybrid mandate through the end of 2026 based in Montreal, Toronto, or Saint-Hyacinthe, this opportunity will perfectly align with your career goals.

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.