Senior Software Developer - Snowflake

Our client, a major insurance company, is seeking a Senior Software Developer to join their Data and Analytics team.

The primary mandate is to support business partners in building a new data mart on a modern cloud platform. This role requires a hybrid profile where you will act as both a technical developer and an analyst to fully grasp the consumption needs of various users.

This is a 6-month contract, starting April 1, 2026, and ending September 30, 2026. The position operates on a hybrid model, requiring 2 days a week in the office. Candidates can be based out of the Montreal, Toronto, or Saint-Hyacinthe offices.

Advantages
Play an active role in building a new cloud data mart from the ground up.

Evolve within a multidisciplinary team that fosters innovation and autonomy.

Enjoy a flexible hybrid work environment available across multiple key cities.

Expand your expertise with cutting-edge technologies like Snowflake and the AWS ecosystem.

Responsibilities
Support business partners on the cloud platform to build and model a new data mart.

Act as an analyst to accurately identify and understand the data consumption needs of different end users.

Translate business requirements into clear and precise technical specifications.

Integrate and transform data using robust extraction, transformation, and loading techniques.

Provide second-level production support to ensure the stability of delivered solutions.

Keep abreast of technological trends and remain open to emerging technologies for code automation, testing, and deployment.

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.

Strong technical experience with Snowflake cloud databases.

3 to 5 years of practical experience with Informatica solutions.

Strong experience with Oracle databases and PL/SQL programming.

Solid understanding of data extraction, transformation, and loading techniques for data warehouses and data marts.

Strong experience with SQL programming.

Experience with Data Vault modeling and relational data models.

Perfect bilingualism in French and English is required to communicate effectively across various teams.

Analytical mindset, versatility, autonomy, and technological curiosity.

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

Experience with IICS, AWS S3, Lambda, JAVA, GIT, Jenkins, Business Objects, and Power BI is an 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 passion for data integration and the ability to act as an analyst to model a new data mart. If you master Snowflake, Informatica, and Oracle, and are looking for a 6-month hybrid mandate in Montreal, Toronto, or Saint-Hyacinthe, this opportunity is for you.

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.