Data Migration Consultant (ID#4678)

New Value Solutions, a national IT consulting company is seeking a Data Migration Consultant to help our client ensure data quality, accuracy, and integrity during migration/integration activities by analyzing, cleansing, and mapping data to support successful system transitions.

• Be responsible for data modeling, data mapping data quality and data cleanliness in advance of the migration and/or integration activities.
• Perform database analysis & database mining and develops routine as well as complex ad-hoc and custom queries.
• Identify areas where data cleansing may be required by the health authorities and work closely with associated representatives who may elect to scrub pieces of questionable data before any migration/ integration run.
• Perform source and target mapping – conducts discovery and requirements gathering sessions for the data migration and/or integration requirements to identify how items from the source system will be mapped to the target system.
• Make migration or integration source data available in a standard format to be determined by analysis (i.e., a staging database, Excel, etc.).
• Map the source system data to system elements. Identifies and documents any static cross-reference information.
• Collaborate with the project System Integrator vendor to ensure the successful migration of the current source date to the new system.
• Perform source system data analysis to manage source to target data mapping.
• Develop and produce reports upon request including dashboards and report visualizations
• Providing a high level of data quality awareness across multiple staff profiles e.g. manager, credentials etc.
• Support data dictionary alignment activities and coordinate with HA representatives for their implementation and quality follow up

• Bachelor’s degree or certification in computer science, Statistics, mathematics or a related field.
• 5+ years of proven experience in data quality, data analysis, data cleansing and data migration activities
• Proficiency in SQL, Python, Java and other programming languages and associated data cleansing and migration tools
• Proven data analysis and profiling experience, data mapping and transformation
• Knowledge of data warehousing and ETL processes
• Experienced at using data quality tools such as Informatica Data Quality or similar
• Strong analytical and problem-solving skills with the ability to gather and interpret data effectively.
• Attention to detail
• Very good communication and interpersonal skills to collaborate with stakeholders, present findings, and recommendations, and facilitate change.
• Ability to work independently, prioritizing tasks and meeting deadlines.
• Experience in migrating data to Salesforce as an asset.

If you have this expertise, and are able to work in Canada, please submit your resume. While we thank all candidates in advance for their application, only those candidates who are shortlisted will be contacted.

ID# 4678

The hourly rate range for this position is $50- $80, with the final rate based on consultant experience and fit for the role.