Junior Data Analyst jobs in United States

Title: 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.

Skillet:

• Data Extraction and Transformation: Design and execute data extraction processes to gather data from AWS Connect, ensuring that all relevant contact center data is accurately transferred. (25%)
• ETL Process Development: Create and manage ETL pipelines for the efficient transfer of large data sets from AWS Connect to Databricks, optimizing for performance and scalability. (25%)
• Data Quality and Validation: Implement data validation, cleansing, and transformation protocols to ensure that data is accurate, consistent, and accessible post-migration. (20%)

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.

Responsibilities:

• Oversee all the facilities of the conversion process.
• Complete mapping, interfaces, mock conversion work, enhancements, actual conversion, and verify 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.
• Analyze and coordinate data file conversions.
• Work with importing files from heterogeneous platforms.

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 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.