Data Analyst

About the Role

CI Financial fosters a workplace that values safety, empowerment, and continuous growth. We are currently seeking experienced Data Analysts to contribute to a major data migration and integration project. This role involves deep analysis of existing data frameworks, reverse engineering business logic from queries and reports, aligning source data with target systems, and active collaboration with business stakeholders to ensure precise and comprehensive outcomes.

This is a hands-on investigative position, requiring proficiency in technical scrutiny combined with clear communication skills to explain complex topics to both technical and non-technical audiences. Comfort with exploring undocumented systems and summarizing findings is essential.

Key Responsibilities

• Examine source databases and systems to grasp data relationships and structures.
• Interpret existing SQL scripts, reports, and stored procedures to extract embedded business rules.
• Perform mapping of source data fields to corresponding target models.
• Detect data gaps, quality concerns, and necessary transformations.
• Collaborate with data engineers to verify ETL and transformation protocols.
• Engage with subject matter experts and business partners to clarify data definitions, logic, and requirements.
• Convert technical insights into clear, accessible documentation for broader stakeholders.
• Create detailed data dictionaries, mapping artifacts, and gap analyses to document findings.
• Record undocumented business processes revealed during analysis.
• Assist with data validation, reconciliation during development phases, and user acceptance testing, ensuring discrepancies between systems are addressed.

Required Skills & Experience

• Expertise in SQL for analyzing and crafting intricate queries.
• Substantial experience in data migration, warehousing, or integration projects.
• At least five years as a Data Analyst working with extensive datasets.
• Strong capabilities in data profiling, mapping, and reconciliation.
• Exceptional analytical thinking and problem-solving in ambiguous settings.
• Effective communication skills for interaction with both technical teams and business stakeholders.
• Experience developing data documentation such as dictionaries, mappings, and gap reports.
• Familiarity with dashboard platforms like Sigma or similar tools.
• Experience using code repositories such as Bitbucket or Git.

Preferred Qualifications

• Knowledge of Snowflake or other cloud-based data platforms.
• Understanding of ETL/ELT methodologies and tools.
• Experience in financial services or regulated environments.

Compensation and Benefits

The position offers a base salary between $55,000 and $95,000, variable based on skills, experience, education, and location. Additionally, eligibility includes participation in a bonus program and comprehensive benefits such as health insurance, wellness initiatives, life and disability coverage, retirement plans, paid leave, education support, holidays, and more, with many benefits fully or partially paid by the company.

Work Environment

This role complies with an in-office work model, requiring team members to be present onsite four days a week to facilitate collaboration and meet business objectives. CI Financial maintains a supportive environment that promotes professional and personal growth.

Additional Information

• Headquarters located near Union Station, Toronto.
• Opportunities for training reimbursement and paid professional certifications.
• Employee savings plans and corporate discount programs.
• Enhanced group benefits and a parental leave top-up program.
• Paid volunteering time off.

CI Financial commits to creating a diverse and inclusive workplace and encourages all interested candidates to apply regardless of meeting every listed qualification. The recruitment process is accessible, and reasonable accommodations will be provided if requested.