IT Solutions & Data Designer — Hybrid Role with Impact

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

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