Data Cleansing and Migration Consultant

**DATA CLEANSING AND DATA MIGRATION CONSULTANT**

**THE OPPORTUNITY**

The **consultant is expected to start ASAP and the contract length is 2 years.**

**Project Context**

In 2015 a provincial credentialing and privileging solution was implemented to provide a single standard web-based platform and to align and standardize business processes across all health organizations in BC. To support the expansion and growth into a new solution, data cleansing, transformation, and migration services are required.

The BC MQI C&P project requires a highly skilled and experienced senior data migration specialist to conduct data cleansing of the existing data and support the data migration activities in collaboration with the data owners from each of the health organizations and the BC MQI team.

Each health authority owns the data associated with their organization. Over time, the quality and consistency of the data has evolved to vary slightly from one health organization to the other, depending on internal processes and data field interpretations/usage. Transformation of the health organization data from its current state to the needs of the future state solution will require data cleansing to allow for effective transformation of the data set. Data migration activities for the project will be handled by the vendor responsible for the delivery of the end solution however the BC MQI project team will play a direct and active role in the data transformation and migration activities lead by the senior data migration specialist.

**Service Required**
- 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, credentialers etc.
- Support data dictionary alignment activities and coordinate with HA representatives for their implementation and quality follow up

**Consultant Qualifications**
- 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 an asset.

**Job Types**: Part-time, Fixed term contract

Pay: Up to $70.00 per hour

Flexible language requirement:

- French not required

Schedule:

- 8 hour shift
- Monday to Friday

Application question(s):

- Where on your resume have you been involved in a large Data migration project?

**Education**:

- Bachelor's Degree (preferred)

**Experience**:

- Data Quality, analysis, cleansing and migration: 5 years (required)
- SQL, Python, Java, Other Language: 5 years (preferred)
- Data warehousing and ETL processes: 5 years (preferred)
- migrating data to Salesforce: 1 year (preferred)

Work Location: In person

Application deadline: 2024-09-27
Expected start date: 2024-10-15