Data Systems Analyst

CGI; Toronto; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A leading tech firm in Canada is looking for a Data Systems Analyst in Toronto. You'll lead the data systems analysis team to enhance data and analytics capabilities, ensuring compliance and quality standards. The ideal candidate should have over 8 years of business analysis experience, strong leadership skills, and expertise in data tools like Snowflake and Informatica. This hybrid role offers a dynamic work environment with collaborative opportunities.

Qualifications

• 5+ years of experience leading Data Systems Analysis teams.
• 8+ years of experience on mid-large data projects.
• Strong knowledge of data technologies and tools.

Responsibilities

• Lead the data systems analysis team to scale data and analytics capabilities.
• Collaborate with various business units and technical data teams.
• Design and prepare regulatory reports meeting compliance standards.

Skills

Big Data

Business Analysis

Data Analysis

ETL

Informatica

Postgre SQL

Snowflake

Statistical Analysis

Education

University degree in Computer Engineering or Computer Science

Job description

Position Description

This role is hybrid and requires you to be at our downtown Toronto and/or Client office at a minimum 3 days per week - subject to change at any time.

Your future duties and responsibilities

Individually these are just words, but together they are our Values – Care, Commitment, Community, and Confidence. We are seeking a collaborative and resourceful Data Systems Analyst for our fast-paced Technology Delivery Data function. You will be leading the data systems analysis team and help scale the data and analytics capabilities. You will be responsible for being a liaison between various business units and technical data teams. You\'ll be required to apply your depth of knowledge and expertise to all areas including requirements, documentation, road mapping, data analysis, and data analytics. Further, you will be part of the data transformation initiatives to build the right data mindset to enable our direct-to-consumer business, data science capabilities, and expand our digital footprint. This role will be part of and a member of our Information Technology Data Delivery Group. You will be responsible for creating the center of excellence for the data ecosystem artifacts creation, maintenance, and project requirements in a high-performing, and experienced team.

You\'ll be required to apply your depth of knowledge and expertise to all many areas including requirements, infrastructure, and solution documentations. Exciting journey to modernize, craft, and build a next generation of data platform to support the growing data needs for data engineering, analytics, and Data Science. We embrace a culture challenging the status quo and constantly look to efficiently simplify processes, technology, and workflow.

What you\'ll bring

• University degree in Computer Engineering or Computer Science.
• Minimum 5 years\' of experience successfully leading Data Systems Analysis organizations with expertise in building large-scale enterprise data assets.
• 8+ years\' experience as a Business Analyst working on mid-large projects for data design, development, and implementation of business-critical enterprise data systems.
• Solid grasp / experience with data technologies & tools (Snowflake, Hadoop, PostgreSQL, Informatica, etc.).
• Outstanding knowledge and experience in ETL with Informatica product suite.
• Experience establishing documentation standards frameworks for data quality, data governance, stewardship and metadata management.
• Ability to foundationally understand complex business process driving technical systems.
• Strong leadership and influencing skills at the senior management level.
• Strong analytical, critical thinking and problem-solving skills.
• Strong stakeholder management.
• Solid understanding of Project and Program Management processes.
• Excellent verbal and written communication skills.
• Insurance knowledge an asset.

Responsibilities by focus area

• Customer & Risk Insights — Segment customers based on behavior, risk profiles, and product usage; analyze customer lifetime value, churn risk, and cross-sell / up-sell opportunities; collaborate with risk and compliance teams to monitor exposure and regulatory thresholds.
• Regulatory & Compliance Reporting — Prepare data extracts and reports for regulatory bodies (e.g., OSFI, FSRA, NAIC); ensure data lineage and traceability for audit and compliance purposes; validate data accuracy and completeness for filings and disclosures.
• Data Wrangling & Preparation — Clean and transform raw data from diverse sources (e.g., policy admin systems, CRM, claims systems) into analytics-ready formats; leverage lakehouse tools (e.g., Delta Lake, Apache Iceberg) to manage versioned and time-travel datasets; collaborate with data engineers to ensure efficient ETL / ELT processes.
• Business Intelligence & Visualization — Build dashboards and visualizations for underwriting, claims, finance, and product teams; use tools like Power BI, Tableau, or Qlik to present insights from lakehouse data; enable self-service analytics by creating reusable datasets and semantic layers.
• Data Quality & Governance — Profile and validate data to ensure consistency across policy, claims, and financial domains; tag and catalog datasets using metadata tools (e.g., Unity Catalog, Collibra); support master data management and reference data initiatives.
• Collaboration & Stakeholder Engagement — Work with actuaries, underwriters, product managers, and IT teams to understand data needs; translate business questions into analytical queries and data models; document business logic, assumptions, and data definitions clearly.
• Predictive & Advanced Analytics Support — Assist data scientists with feature engineering and exploratory data analysis; provide historical data extracts for model training and validation; interpret model outputs and integrate them into business reporting.

What you will bring

• University degree in Computer Engineering or Computer Science (already listed above but included here for clarity).
• Minimum 5 years of experience leading Data Systems Analysis teams with enterprise data asset experience.
• 8+ years of experience as a Business Analyst on mid-large data projects.
• Strong knowledge of data technologies and tools (Snowflake, Hadoop, PostgreSQL, Informatica, etc.).
• Experience with ETL/ELT and Informatica.
• Experience establishing data quality, governance, and metadata management documentation.
• Strong business process understanding and leadership capabilities.
• Excellent communication and stakeholder management skills.
• Insurance knowledge an asset.

Skills

• Big Data
• Big Data & Analytics Operation
• Business Analysis
• Data Analysis
• ETL
• Financial Services
• Informatica
• Postgre SQL
• Snowflake
• Statistical Analysis