Intermediate / Senior Data Analyst

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.

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

Responsibilities
Pipeline & Core Development: Design, optimize, and maintain robust ETL/ELT data integration flows to ingest, enrich, and expose data from disparate operational systems.

Data Modeling & Strategy: Formulate and document clear enterprise data requirements, ensuring structures align with the organizational data governance framework.

Quality Assurance: Conduct rigorous unit, functional, and non-regression testing to preserve the structural integrity of corporate datasets; support business units through User Acceptance Testing (UAT).

Agile Collaboration: Actively engage in SAFe Agile ceremonies, including PI Planning, daily standups, and sprint reviews, to facilitate iterative solution deliveries.

Production & Support: Coordinate seamless deployments across diverse business units and provide level-3 production support and ad-hoc data extractions for business strategy teams.

Qualifications
Core Experience: Over 7 years of overall IT experience, with at least 5 years specifically focused on data analysis and engineering.

Technical Ecosystem: Advanced proficiency in cloud data platforms like Snowflake, Azure Data Factory, and SQL.

Architectural Expertise: Proven track record with DataVault modeling and Medallion architecture (Bronze, Silver, Gold processing environments); familiarity with SSIS is highly preferred.

Frameworks: Deep understanding of the Software Development Lifecycle (SDLC), DevOps practices, and Agile/SAFe frameworks.

Soft Skills: Exceptional communication skills with a proven knack for translating complex technical architectures into digestible business terms; strong leadership, negotiation, and collaborative problem-solving capabilities.

Domain Knowledge: Previous experience within the insurance or financial services sectors is considered a strong asset.

Language Requirements: Bilingualism (English and French) is required. Our client operates in Canada. The company takes all reasonable steps to limit the number of positions in Quebec that require knowledge of a language other than French, and only requires it when necessary and its existing bilingual employees are unable to perform these duties. Based on an assessment conducted by our client, it has been determined that this position requires candidates to be fluent in English (both spoken and written). In particular, this position will require the employee to interact with centralized internal departments (e.g., Operations / HR / Finance / Legal / Contracts / Sales) that support the organization in Canada and that do not speak French.

Summary
Location: Montreal or Quebec City (Hybrid model, mostly remote with occasional on-site meetings)

Duration: Contract until March 31, 2027 (with strong possibility of renewal)

Work Schedule: 35 hours per week

Randstad Canada is committed to fostering a workforce reflective of all peoples of Canada. As a result, we are committed to developing and implementing strategies to increase the equity, diversity and inclusion within the workplace by examining our internal policies, practices, and systems throughout the entire lifecycle of our workforce, including its recruitment, retention and advancement for all employees. In addition to our deep commitment to respecting human rights, we are dedicated to positive actions to affect change to ensure everyone has full participation in the workforce free from any barriers, systemic or otherwise, especially equity-seeking groups who are usually underrepresented in Canada's workforce, including those who identify as women or non-binary/gender non-conforming; Indigenous or Aboriginal Peoples; persons with disabilities (visible or invisible) and; members of visible minorities, racialized groups and the LGBTQ2+ community.

Randstad Canada is committed to creating and maintaining an inclusive and accessible workplace for all its candidates and employees by supporting their accessibility and accommodation needs throughout the employment lifecycle. We ask that all job applications please identify any accommodation requirements by sending an email to accessibility@randstad.ca to ensure their ability to fully participate in the interview process.