IT Solutions and Data Designer

iA Financial Group; Montreal; Hybrid; CAD 90,000 - 120,000; Full time

Benefits offered by this job

Insurance

Retirement plan

Employee share purchase plan

Vacation days

Telemedicine services

Employee Assistance Program

Ergonomic furniture program

Performance bonus

Discounts on company products

Job summary

iA Financial Group is seeking an IT Solutions and Data Designer to contribute to the design, development, and maintenance of robust, secure technology and data solutions in a hybrid Montreal setting. You will collaborate with partners and delivery teams to translate business needs into practical, scalable designs.

The role emphasizes technical leadership, solution architecture, and involvement across development, testing, and production deployments with a focus on data integration, data

Qualifications

• Strong proficiency in SQL and Python or an equivalent language.
• Experience designing IT and data solutions.
• Familiar with data modeling, databases, and ETL/ELT concepts.
• Knowledge of security, testing, deployment practices.
• Asset: knowledge of Azure, Snowflake, Databricks and insurance/financial services industry.
• Advanced French and intermediate English required for daily communication with suppliers and partners across Canada.

Responsibilities

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

Skills

SQL

Python

Data modeling

ETL/ELT concepts

Security & compliance

French/English language

Tools

Azure

Snowflake

Databricks

Job description

Job 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

As an IT Solutions and Data Designer, you will be at the heart of our mission. Your main responsibilities will include:

• 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

We are looking for someone who:

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

Location(s)

Montreal / 1981 McGill College Avenue

Other Possible Location(s)

Quebec / 1080, Grande Allee West

Company

iA Financial Group

Posting End Date

2026-11-20

Company Overview

iA Financial Group* is the strength of a company with a human side, with its over 8,000 employees. Together, we have earned the trust of our more than four million clients and 25,000 advisors who have chosen us for their insurance, savings, and wealth management.

With over $200 billion in assets and half a billion invested in technological innovation, we’re a key player in the financial services industry in Canada and the United States. The secret to our success? Investing in you, one person at a time. Because, for over 125 years, we have believed that it’s by supporting our employees and surrounding ourselves with the most reputable leaders in the industry, we will continue to innovate.

At iA, we’re invested in you.

* iA Financial group includes the following entities: iA Services financiers, iA assurance auto et habitation, iA Gestion privée de patrimoine, PPI Management, Investia, iA Gestion de placements, Prysm, iA Clarington, Michel Rhéaume et associés, Garanties Nationales, WGI Manufacturing, WGI Service Plan Division, Lubrico, iA Financement auto

Our Commitment to Diversity and Inclusion

At iA Financial Group, we support and celebrate diversity. We strive to provide a workplace that is recognized as inclusive for all, regardless of ethnic origin, nationality, language, religious beliefs, gender, sexual orientation, age, marital status, family situation, or physical or mental disability.

Please note that if you need help or assistance to make the recruitment process more accessible for you, please Contact us here. Someone from our team will be happy to assist you with your needs.

Technology and Artificial Intelligence in Recruitment

To optimize and support our recruitment process, iA Financial Group may use certain technological tools, including artificial intelligence. These tools support the work of our recruiters but do not replace their judgment. All hiring decisions continue to be made by authorized individuals within the organization. For more information, please refer to our Privacy Notice.