Software Developer Specialist (Informatica Power Center & Snowflake Iceberg experience)

The Role

As a specialist software developer, you bring strong modeling experience, excellent analytical skills, and technical leadership. You design and evolve our data platform, which is used on a large scale for business decisions and high‑impact innovative initiatives.

Technology Environment

Informatica Power Center, Snowflake Iceberg, Cloud migration, Snowflake (SQL), S3, Git, Unix, Visual Studio Code, Control‑M. Always on the lookout for new tools, we test and approve those that could improve our daily operations.

Your Daily Mission

• Integrated into a multidisciplinary team, you balance autonomy with collective work to deliver user‑centered solutions.
• Design, develop, and optimize ingestion and transformation pipelines (batch and real‑time).
• Model robust analytical data (star, Data Vault, bronze/silver/gold) for BI and data science.
• Improve reliability, performance, and governance (security, cataloging, quality, costs).
• Collaborate with analysts, testers, architects, and stakeholders to translate needs into solutions.
• Provide technical guidance to the team, promote best practices (code reviews, standards, tests, documentation), and drive change.
• Contribute to an Agile culture (Scrum/Kanban) focused on value and incremental delivery.

Desired Profile

• Bachelor’s degree in computer science/software engineering or equivalent.
• 10 years in software/data engineering, including ETL/ELT and large‑scale data warehousing.
• Proficient in data modeling and analytical architectures.
• Excellent SQL skills and optimization; hands‑on experience with Snowflake.
• Strong knowledge of Unix and the Cloud ecosystem (preferably AWS).
• Python and Java (a plus).
• Experience with CI/CD, automated data testing, quality/observability.
• Basic understanding of AI/machine learning (advantageous for collaborating with Data Science).
• Bilingualism (FR‑EN) – required for candidates located in Quebec.
• Must have authorization to work in Canada.

Compensation and Benefits

Salary range (35‑hour workweek): 118,700 – 145,100

Annual bonus target, with potential payout up to double the target: 15%

Benefits include flexible work arrangements and a hybrid model, possibility to purchase up to 5 extra days off per year, telemedicine, wellness account, and an Employee Share Purchase Plan with Intact matching 50% of net shares.

Equal Opportunity

We are an equal opportunity employer. At Intact, we strive to create an accessible workplace where employees feel valued, included, and encouraged to share their unique perspectives.

We encourage applications from individuals who are members of equity‑deserving groups, including women, Indigenous peoples, persons with disabilities, Black people, and members of the 2SLGBTQI+ community.

As part of Intact’s commitment to reconciliation, we acknowledge that we work across the land called Canada, originally inhabited by First Nations, Metis, and Inuit people.

We have policies to ensure equal access and participation for people with disabilities, including providing workplace adjustments. A copy of applicable policies is available on request.

Intact does not provide sponsorship or other support for immigration‑related matters. Candidates must be eligible to work in Canada from the anticipated start date and throughout employment and are responsible for maintaining work eligibility.