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

Intact FC • Toronto, ON

41d • Hybrid

About The Position

We’re IntacLab—the tech arm of Intact—where we turn bold ideas into real-world impact. Our team spans product, design, data, AI, and engineering, and we build digital products that are simple to use, powerful under the hood, and focused on outcomes. We believe in autonomy, high standards, and genuine teamwork. You’ll find a culture that values continuous learning, clear thinking, and craftsmanship. If you join us, you’ll work on high-stakes projects with a supportive team that challenges you to do your best.

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 experience, Snowflake Iceberg experience
Cloud migration experience, 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.

Requirements

• 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).
• Experience with CI/CD, automated data testing, quality/observability.
• Eligible to work in Canada; no prior Canadian work experience required.

Nice To Haves

• Python and Java (a plus).
• Basic understanding of AI/machine learning (advantageous for collaborating with Data Science).
• Bilinguism (FR-EN) - For candidates located in Quebec, bilingualism is required considering the necessity to interact on a regular basis with English-speaking colleagues across the country.

Responsibilities

• 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.

Benefits

• Flexible work arrangements and a hybrid work model
• Possibility to purchase up to 5 extra days off per year
• Multiple benefits offered to support physical and mental wellbeing, including telemedicine, Wellness account and much more
• Share plan & other savings: up to 12% of salary or even more (ask how you could earn guaranteed income for life)
• Annual bonus target, based on the base salary, with a potential payout of up to double the target (subject to personal and company performance): 15%
• Employee Share Purchase Plan (ESPP) – with Intact matching 50% of your net shares.
• Opportunity to receive guaranteed income for life via our defined benefit pension plan.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 5,001-10,000 employees