Data Analyst

CI Investments Inc.; Fredericton; On-site; CAD 55,000 - 95,000; Full time

Benefits offered by this job

Health insurance coverage

Wellness programs

Paid holidays and vacation time

Job summary

CI Investments Inc. is seeking an experienced Data Analyst to support extensive data migration and integration initiatives. The role involves investigating data structures, analyzing business logic, and collaborating with stakeholders for accuracy.

Key responsibilities include mapping data, producing documentation, and supporting data validation. The anticipated salary ranges from $55,000 to $95,000, with participation in a bonus program and comprehensive benefits offered.

Qualifications

• Ability to read, analyze, and write complex SQL queries.
• Experience in data migration, data warehousing, or integration projects.
• Strong skills in data profiling and mapping.

Responsibilities

• Investigate source systems and data structures.
• Map source fields to target model requirements.
• Partner with business stakeholders for clarity in definitions.
• Produce detailed documentation and data dictionaries.
• Support data validation and reconcile discrepancies.

Skills

Strong SQL skills

Data migration experience

Data warehousing knowledge

Data mapping and reconciliation skills

Analytical and problem-solving abilities

Communication skills

Experience with dashboard tools

Experience with code repository systems

Tools

Sigma

Bitbucket

Git

Job description

We are seeking experienced Data Analysts to support a large-scale data migration and integration initiative. Your role will involve investigating existing data structures, analyzing business logic hidden in queries and reports, mapping source data to target systems, and collaborating with business stakeholders to ensure accuracy and completeness.

Key Responsibilities

Source System Analysis

• Investigate source systems and databases to understand data structures, relationships, and logic.
• Analyze existing SQL queries, reports, and stored procedures to reverse engineer business rules.

Data Mapping & Transformation

• Map source fields to target model requirements.
• Identify gaps, data quality issues, and transformation needs.
• Work closely with data engineers to validate ETL/transformation rules.

Stakeholder Collaboration

• Partner with business SMEs and stakeholders to clarify definitions, logic, and requirements.
• Translate technical findings into clear documentation for non-technical stakeholders.

Documentation & Knowledge Transfer

• Produce detailed data dictionaries, mapping documents, and gap analysis reports.
• Capture undocumented business logic and processes uncovered during investigation.

Validation & Testing

• Support data validation and reconciliation efforts during development and UAT.
• Assist in resolving discrepancies between source and target systems.

Required Skills & Experience

• Strong SQL skills, with the ability to read, analyze, and write complex queries.
• Proven experience in data migration, data warehousing, or system integration projects.
• Background in analyzing large datasets.
• Strong data profiling, mapping, and reconciliation skills.
• Excellent analytical and problem-solving abilities in ambiguous environments.
• Strong communication skills to work with both technical teams and business stakeholders.
• Experience creating data dictionaries, mapping documents, and gap analysis reports.
• Experience with dashboard tools such as Sigma or equivalent.
• Experience with code repository systems – Bitbucket or Git.

Nice to Have

• Experience with Snowflake or other modern cloud data platforms.
• Familiarity with ETL/ELT processes and tools.
• Exposure to financial services or other regulated industries.

Compensation & Benefits

The anticipated base salary range for this position is $55,000 - $95,000, though the exact amount depends on experience, skills, education, and budget. Salary may vary based on geographic location. In addition to base salary, this position is eligible for participation in a bonus program. The company offers a variety of benefits to eligible employees, including health insurance coverage, wellness programs, life and disability insurance, retirement savings plans, paid leave programs, education-related programs, paid holidays and vacation time, and many others. Many of these benefits are subsidized or fully paid for by the company.

This role follows our in-office work model and requires employees to be onsite four days per week to support collaboration and business needs.

Equal Employment Opportunity

CI Financial Corp. and all of our affiliates (“CI”) are committed to fair and accessible employment practices and provide reasonable accommodations for persons with disabilities. If you require accommodations in order to apply for any job opportunities or require this posting in an additional format, please contact [e-mail] or call 416-364-1145 ext. 4747.