Data Conversion Specialist - Senior

LanceSoft; Toronto; Hybrid; CAD 80,000 - 100,000; Full time

Job summary

A leading data service provider is seeking a Data Conversion Specialist in Toronto to oversee the data conversion process and ensure accuracy. The ideal candidate should have over 3 years of experience in data migration and ETL processes, strong skills in Python, SQL, and a working knowledge of AWS services. This role offers a hybrid work model and emphasizes collaboration and client relationship management.

Qualifications

• 3+ years of experience in data migration, conversion, or ETL processes.
• Hands-on experience with AWS Connect, Databricks or other data platform, and data transformation techniques.
• Proficiency in Python and SQL; experience with Scala is a plus.

Responsibilities

• Oversee all the facilities of the conversion process.
• Complete mapping, interfaces, mock conversion work, and verify accuracy of converted data.
• Establish a strong working relationship with all clients and provide conversion support.
• Analyze and coordinate data file conversions.

Skills

Data Migration

Data Transformation

ETL Processes

Python

SQL

AWS Connect

Databricks

Data Engineering

Tools

ETL Tools

AWS Lambda

AWS Glue

Amazon S3

Job description

Overview

Data Conversion Specialist - Senior — Location: Toronto, ON M7A 0B6 (Hybrid – 3 days Onsite). Duration: 144 days with possibility of extension.

Must Haves

• 3+ years of experience in data migration, conversion, or ETL processes.
• Hands-on experience with AWS Connect, Databricks or other data platform, and data transformation techniques.
• Data Transformation Tools: Expertise in ETL tools and data engineering processes.
• Programming Languages: Proficiency in Python and SQL; experience with Scala is a plus.
• AWS Services: working knowledge of AWS Connect, Amazon S3, AWS Lambda, and AWS Glue.

Responsibilities

• Oversee all the facilities of the conversion process.
• Completes mapping, interfaces, mock conversion work, enhancements, actual conversion, and verifies completeness and accuracy of converted data.
• Establish a strong working relationship with all clients, interact effectively with all levels of client personnel, and provide conversion support.
• Analyzes and coordinates data file conversions.
• Works with importing files from heterogeneous platforms.

Ideal Candidate

• 3+ years of experience in data migration, conversion, or ETL processes.
• Hands-on experience with AWS Connect, Databricks or other data platform, and data transformation techniques.
• Data Transformation Tools: Expertise in ETL tools and data engineering processes.
• Programming Languages: Proficiency in Python and SQL; experience with Scala is a plus.
• AWS Services: working knowledge of AWS Connect, Amazon S3, AWS Lambda, and AWS Glue

General Skills

• Full life-cycle data conversion experience with Enterprise Resource Planning (ERP) Systems, including deployment experience
• Proficiency in query languages
• Familiarity with and construction of complex query statements
• Knowledge of various database structures
• Data analysis, investigative and logic skills
• Experience with data conversion scripts and tools
• Experience with overseeing /completing all tasks involved in the conversion process including data extraction, cleansing, transformation and loading
• Experience liaising with teams to understand to-be migration requirements.
• Establish a strong working relationship with all groups, interact effectively with all levels of client personnel, and provide conversion support.
• Experience completing mapping, interfaces, conversion work, documentation and verifying completeness and accuracy of converted data.
• Experience delivering the required system changes and/or working with the development team or a dedicated conversion team to specify loads programs.
• Experience providing support through the cutover process
• A team player with a track record for meeting deadlines, managing competing priorities and client relationship management experience
• Communication, facilitation, negotiation, consensus building, and problem-solving skills

Desirable Skills

• Knowledge and experience in business case development
• Knowledge and understanding of Information Management principles, concepts, policies and practices
• Excellent understanding of master data and transactional data concepts and interdependence