This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
Our client, a premier organization in the Canadian insurance and financial services sector, is seeking two Intermediate to Senior Data Analysts specializing in data engineering. In this role, you will collaborate closely with internal teams to build a brand-new, modern data warehouse dedicated to savings and disability management solutions. This is an exceptional opportunity to influence data maturity and deployment frameworks within a large-scale enterprise environment.
Job Responsibility
Design, optimize, and maintain robust ETL/ELT data integration flows to ingest, enrich, and expose data from disparate operational systems
Formulate and document clear enterprise data requirements, ensuring structures align with the organizational data governance framework
Conduct rigorous unit, functional, and non-regression testing to preserve the structural integrity of corporate datasets
support business units through User Acceptance Testing (UAT)
Actively engage in SAFe Agile ceremonies, including PI Planning, daily standups, and sprint reviews, to facilitate iterative solution deliveries
Coordinate seamless deployments across diverse business units and provide level-3 production support and ad-hoc data extractions for business strategy teams
Requirements
Over 7 years of overall IT experience, with at least 5 years specifically focused on data analysis and engineering
Advanced proficiency in cloud data platforms like Snowflake, Azure Data Factory, and SQL
Proven track record with DataVault modeling and Medallion architecture (Bronze, Silver, Gold processing environments)
familiarity with SSIS is highly preferred
Deep understanding of the Software Development Lifecycle (SDLC), DevOps practices, and Agile/SAFe frameworks
Exceptional communication skills with a proven knack for translating complex technical architectures into digestible business terms
strong leadership, negotiation, and collaborative problem-solving capabilities
Previous experience within the insurance or financial services sectors is considered a strong asset
Bilingualism (English and French) is required
Nice to have
familiarity with SSIS is highly preferred
Previous experience within the insurance or financial services sectors is considered a strong asset
What we offer
Work-Life Balance: Standard 35-hour work week with a flexible schedule
Hybrid Flexibility: Collaborative hybrid structure based out of Montreal or Quebec City, allowing you to balance remote productivity with impactful on-site team touchpoints
Cutting-Edge Tech Stack: Hands-on exposure to modern cloud data warehousing frameworks and methodologies
Professional Growth: Deep integration within an established SAFe Agile environment, driving strategic 'Build, Buy, or Reuse' technical decisions