Data Analyst - Data Migration & Integration
ci · Toronto
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
Why are you reporting this job?
Explore further
Salaries, guides and searches in Canada.
Salaries by job title
Apply in 30 seconds
Enter your email to apply. An account will be created automatically.
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
Related job offers
-
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