📢 New: get today's jobs on our WhatsApp Channel
Jobiglo

No results.

Data Analyst - Data Migration & Integration

ci · Toronto

New
Mid 55,000 - 95,000 CAD/year 🇬🇧 English
SQL Sigma Bitbucket Git Snowflake ETL/ELT

Job description

About the role

CI Financial is looking for experienced Data Analysts to support a large-scale data migration and integration initiative. The role is highly investigative and combines technical analysis with business communication: investigating existing data structures, analyzing business logic hidden in queries and reports, mapping source data to target systems and working with business stakeholders. It is an existing vacancy in Toronto, with an in-office model requiring four days per week onsite.

Key responsibilities

  • Analyze source systems and databases, and reverse-engineer business rules from SQL queries, reports and stored procedures.
  • Map source fields to target model requirements, identify data quality issues and work with data engineers to validate ETL/transformation rules.
  • Work with business SMEs to clarify definitions and requirements, and turn technical findings into clear documentation.
  • Produce data dictionaries, mapping documents and gap analysis reports, and capture undocumented business logic.
  • Support data validation and reconciliation during development and UAT, and help resolve discrepancies between source and target systems.

Required profile

  • Proven experience in data migration, data warehousing or system integration projects.
  • Background in analyzing large datasets and strong data profiling, mapping and reconciliation skills.
  • Ability to work in ambiguous environments and communicate with both technical teams and business stakeholders.
  • Nice to have: exposure to financial services or other regulated industries.

Required skills

  • Strong SQL, including reading, analyzing and writing complex queries.
  • Creating data dictionaries, mapping documents and gap analysis reports.
  • Dashboards such as Sigma or equivalent; code repositories such as Bitbucket or Git.
  • Nice to have: Snowflake or other cloud data platforms, ETL/ELT tools.

What we offer

  • Base salary range of $55,000 - $95,000, depending on experience, skills, education and budget; eligibility for a bonus program.
  • Health insurance, wellness programs, life and disability insurance, retirement savings plan, paid leave, education programs, paid holidays and vacation.
  • Modern HQ near Union Station, training reimbursement, professional designations, employee savings plan, corporate discount program, parental leave top-up and volunteer pay.

Questions fréquentes

Le salaire proposé pour ce poste est de 55-95k CAD par an. Le détail figure dans l'annonce.
Cliquez sur "Postuler maintenant" en haut de la page. Vous pouvez importer votre CV en 1 clic — Jobiglo extrait automatiquement vos informations et postule pour vous.
Source : ats:workday

Why are you reporting this job?

Thank you for your report. We will review this job.

Apply in 30 seconds

Enter your email to apply. An account will be created automatically.

Apply now →

By continuing, you accept our terms of use.

Already have an account? Login

A question about this job?

Ask it here: you will get the full job summary by e-mail, right away.

Published 5 hours ago

Expires 1 month from now

3 views · 0 interested

Boost your chances

Upload your CV — we will match you with relevant openings.

Analyzing your CV...

ci

Toronto