IT Solutions and Data Designer

iA Financial Group (Industrial Alliance); Montreal (administrative region); Hybrid; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Flexible group insurance plans

Competitive retirement savings plan

Employee share purchase plan

Vacation program and wellness/personal

Telemedicine services

Employee and Family Assistance Program

Ergonomic furniture program

Performance bonus

Discounts on iA products

Job summary

iA Financial Group is seeking an IT Solutions and Data Designer within Corporate IT Solution Delivery, Strategy and Performance. You will design, develop, and evolve robust data and technology solutions, collaborating with business partners, architects, and delivery teams to translate needs into practical designs.

You will be a technical reference, involved in development, testing, and solution maintenance, contributing to security, compliance, and production deployments while growing your

Responsibilities

• Translate business needs into practical technology solutions and designs.
• Design, develop, test, and maintain application and data components, including models, data flows, processing rules, and ETL/ELT pipelines.
• Implement and enhance data warehouses, data marts, interfaces, and analytical solutions with quality controls and reliability.
• Act as a technical reference, guide the delivery team, coordinate testing and code reviews, ensure technical quality of deliverables.
• Contribute to estimations, planning, documentation, obsolescence management, change management, and production deployments with security and compliance in mind.

Skills

SQL

Python

Data Modeling

ETL/ELT

Bilingual (French/English)

Tools

Azure

Snowflake

Databricks

Job description

Description

Build the Future with Us

Are you passionate about designing technology solutions and looking to contribute to a company whose purpose is to help clients feel confident and secure about their future?

As an IT Solutions and Data Designer within Corporate IT Solution Delivery, Strategy and Performance, you will play a key role in the design, development, implementation, and evolution of robust, secure, and maintainable technology and data solutions.

You will collaborate with business partners, architects, and delivery teams to transform business needs into practical solutions. You will serve as a technical reference for the team while remaining actively involved in development, testing, and solution maintenance.

This position is an excellent opportunity to showcase your skills and fully realize your potential within a caring and trustworthy organization. Here, people and their development are at the heart of our priorities, fostering an environment that encourages collaboration and innovation.

What You Will Accomplish with Us

• Analyze business needs, translate them into practical technology solutions, and produce detailed designs aligned with architectural guidelines;
• Design, develop, test, and maintain application and data components, including models, data flows, processing rules, and data integration, transformation, and loading pipelines;
• Implement and enhance data warehouses, data marts, interfaces, and analytical solutions while ensuring data quality, traceability, and operational reliability;
• Act as a technical reference, guide the delivery team, contribute to the adoption of best practices, and ensure the technical quality of deliverables, including coordinating testing activities and code reviews;
• Contribute to estimations, planning, documentation, obsolescence management, change management, and production deployments while integrating security, compliance, and access management requirements, as well as participating in incident resolution and audit activities;

What Could Accelerate Your Success in This Role

• Is recognized for their technical leadership, autonomy, and attention to quality;
• Stands out for their ability to analyze complex business requirements and translate them into practical technology solutions;
• Demonstrates strong expertise in the design and development of IT and data solutions;
• Is recognized for their ability to collaborate effectively with business partners, architects, and multidisciplinary teams;
• Has significant experience in designing and developing IT solutions;
• Has strong proficiency in SQL and a solid knowledge of Python or an equivalent programming language;
• Possesses a solid understanding of data modeling, databases, and ETL/ELT concepts;
• Is familiar with software development, testing, security, and deployment practices;
• Has experience with Azure, Snowflake, Databricks, or similar technologies, which is considered an asset;
• Has knowledge of the insurance and financial services industry, which is considered an asset;
• Has an advanced level of French and an intermediate level of English, as the position requires daily communication with unilingual English‑speaking suppliers and partners across Canada through emails and phone calls;

Why You Will Love Working with Us

• A work environment where learning and development blend with a shared pursuit of excellence;
• Artificial intelligence is available to everyone, helping increase personal efficiency and support organizational growth;
• A healthy, safe, equitable, and inclusive workplace where individuals can grow and reach their full potential;
• The opportunity to work in a hybrid environment supported by flexibility and access to inspiring and innovative workspaces;

Competitive Benefits

• Flexible group insurance plans;
• Competitive retirement savings plan;
• Employee share purchase plan;
• Vacation program and wellness/personal development days;
• Telemedicine services;
• Employee and Family Assistance Program;
• Ergonomic furniture program;
• Performance bonus;
• Discounts on iA products;
• And much more!

At iA, we believe in potential and value diverse experiences. If this role inspires you, take the leap and apply. Your place may be with us, and we would love to get to know you!