Data Analyst - Data Migration & Integration
ci · Toronto
Description du poste
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
Pourquoi signalez-vous cette offre ?
Aller plus loin
Salaires, guides et recherches au Canada.
Salaires par métier
Postulez en 30 secondes
Entrez votre email pour postuler. Un compte sera cree automatiquement.
En continuant, vous acceptez nos conditions d'utilisation.
Deja un compte ? Connexion
Une question sur cette offre ?
Posez-la ici : vous recevrez le récapitulatif de l'offre par e-mail, tout de suite.
Publie il y a 5 heures
Expire dans 1 mois
6 vues · 0 interesses
Boostez vos chances
Importez votre CV : nous vous proposons les offres qui matchent votre profil.
Analyse de votre CV en cours...
ci
Toronto
Offres similaires
-
Product Manager - Payment Software
harriscomputer Toronto -
Software Developer (Ruby on Rails, Toronto)
clio Toronto -
Senior Product Manager, Ex-Lawyers and Attorneys
clio Toronto -
Programmeur·euse compétitif·ve – Benchmarks IA (Remote)
Vettedlance -
Enregistreur de flux de travail pour outils de développement (éditeurs de code, IDE, clients API)
Vettedlance