iA Financial Group is building a dynamic and innovative data management team that will lay the foundation for the company's digital transformation to become Data Driven. Are you passionate about data? Do you want to have a leadership role while being responsible for delivering business intelligence and artificial intelligence solutions to multiple business sectors? We have an opportunity for you. This position will have several exciting challenges, including the responsibility to propose and implement innovative solutions to improve access and availability of financial information (primarily). He/she will also be responsible for optimizing the use of data management systems with the various teams.
The Data Analyst - Data Engineering contributes to the implementation and evolution of data sets and corporate data management solutions such as data warehouses and data counters, data integration, data ingestion and visualization solutions. The Data Analyst is responsible for defining, documenting and tracking the organization's data solution requirements. He/she must ensure understanding of the business needs related to the solutions he/she supports. He/she must coordinate the formalization and implementation of business rules to ensure the accuracy, completeness, consistency and compliance of the data according to the business needs. The Data Analyst is also responsible for ensuring that the software platforms supporting the data solutions are deployed and evolve according to the needs of the organization.
Build data solutions that collect data from multiple data sources, then enrich and expose it for users
Perform data mining in advance of building data solutions
Build ETL/ELT data loading workflows to integrate, transform and expose data
Implement integrated functional and system test cases during application modification to ensure operational integrity of corporate data solutions, perform unit, functional and non-regression testing
Support the business partner during acceptance testing
Ensure the support of data solutions in production
Perform data extractions for the business team
Participate in SAFe agile ceremonies such as: IP planning, daily Scrums, sprint planning, end of sprint demos, etc.
Oversee the iterative release of solutions, working with teams from different business units to establish and execute the necessary tasks in a well established order.
Promote the reuse of existing components, participate in the selection of software packages, services or external components (e.g. cloud-based) and ultimately recommend building in-house when required (REUSE, BUY, BUILD).
Work in collaboration with the various Business and IT stakeholders to design components that respect the company's orientations and are viable, efficient and profitable.
Technical profile required
Bachelor's degree in computer science, business computing, information systems, computer or software engineering, or any other relevant training at the same level
More than 5 years of experience in information technology, including 3 years of experience relevant to the position
Experience with data warehouses and business intelligence solutions (SQL Server, SSIS, PowerBI, Snowflake, Databricks, Azure Data Factory,)
Good knowledge of ETL/ELT data loading tools
Mastery of SQL language and knowledge of the SSIS data integration tool
Mastery of techniques, frameworks and methodologies specific to his/her field of expertise (SAFe®, Agile, DevOps, Software Development Lifecycle, etc.)
Knowledge of the insurance and financial services industry (asset)
Excellent communicator, structured and technical popularizer with a good ability to synthesize and work effectively in a team.
A natural leader with the ability to influence and guide others, particularly solution delivery teams and collaborators on the periphery of the business.
Strong problem identification and resolution skills.
Excellent coordination, negotiation and decision making skills.
*Please note that the in-house title will be Data Analyst*
Our employees are our best investment and we have much to offer them.
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 50,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.
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.