IT Solutions and Data Designer

IA Financial Services Inc.; Montreal; Hybrid; CAD 90,000 - 130,000; Full time

Benefits offered by this job

Competitive Benefits

Hybrid work model

Wellness program

Employee and Family Assistance Program

Discounts on iA products

Job summary

iA Financial Group is seeking an IT Solutions and Data Designer to design, develop, and maintain robust, secure data solutions within Corporate IT Solution Delivery, Strategy and Performance. You will collaborate with partners and delivery teams to transform business needs into practical technology solutions and act as a technical reference throughout development, testing, and maintenance.

The role emphasizes data warehouses, pipelines, data quality, and compliance, with a hybrid work model and

Qualifications

• Must analyze business needs and translate to technical designs.
• Design, develop, test, and maintain data components and data pipelines.
• Implement and enhance data warehouses, marts, and analytical solutions with quality and reliability.
• Act as technical reference for the team; guide testing and code reviews.
• Contribute to estimations, planning, documentation, obsolescence and deployment with security/compliance awareness.

Responsibilities

• Analyze business needs, translate into practical technology solutions and detailed designs.
• Design, develop, test, and maintain application and data components including data flows and ETL/ELT pipelines.
• Implement and enhance data warehouses, data marts, interfaces, and analytical solutions with data quality and reliability.
• Act as technical reference; guide delivery teams and coordinate testing and code reviews.
• Contribute to estimations, planning, documentation, and deployments while integrating security and compliance.

Skills

SQL

Python

Data modeling

ETL/ELT

Azure

Snowflake

Databricks

Data warehouses

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

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

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. As a reflection of our employees’ appreciation and engagement, iA once again stands out this year as one of Canada’s top employers according to Forbes. In 2026, iA Financial Group also ranks 1st among major publicly traded Canadian insurers. At iA Financial Group, our differences make us unique. We are committed to supporting and celebrating diversity because we believe that it is by bridging our differences that we will be stronger. Our employees’ wellbeing is our priority. We are also committed to creating a stimulating and safe work environment, in addition to offering a real work-life balance with our flexible work model. As a reflection of our employees’ appreciation, iA has been ranked as one of the top employers in Canada in 2023 by Glassdoor and Forbes.

Want to join the iA family, but there’s no job openings right now that match your profile? Let us know you’re interested!