Job Description

This is a remote position.

Job Title : QA Analyst

Job Type : Contract; Full-Time

Location : Canada, USA (Offshore)

Term : 2024 / 12 / 16– 2025 / 12 / 31

About the Company :

Our client is a Crown corporation providing specialized and personalized financial services to farming operations. Our client offers financing, insurance, software, learning programs, and other business services to producers, agribusiness owners and agri-food entrepreneurs across the country.

Responsibilities :

Testing existing system processes and provide recommendations for improvements

Meeting with key stakeholders to determine business system needs and requirements

Conducting and reporting on technical and business analyses

Assessing new software for compatibility with current systems

Ensuring product quality throughout the development process

Flagging opportunities for test automation and process automation

Working independently

Requirements :

Required Experience :

3-5 years of QA experience

5+ years of IT experience

Requirements

Specific Project Requirements : Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy. Demonstrated experience in SQL programming is required. Demonstrated experience in ETL is required. Strong knowledge and demonstrated experience in current and future state data mapping. Carry out data validation and identify and resolve discrepancies (format, content, values). Work with business team members on troubleshooting Top Skills Required : Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy. Well-rounded experience in the whole data lifecycle management and hands-on experience in the following data management domains : dimensional and relational data modeling, data quality, SQL programming (minimum 5 years), ETL development, metadata management and master data management, and business intelligence. Experience with reverse engineering the source to target mapping to gain data insights Experience refactoring existing SQL code to new / alternate data sources. Other Skills Required : Experience with Azure Data Platform technologies or other public cloud offerings Programming experience : SQL Experience with Databricks Excellent verbal and written communication, critical thinking, time management, priority planning and interpersonal skills. Ability to understand and interpret requirements and design documents Ability to write and maintain documentation Demonstrated experience working with key business stakeholders in areas of Finance, Risk Management and Insurance Assets : Experience working in an Agile environment / team Bilingualism in both official languages (English and French) Greater than 5 years of SQL development and refactoring existing SQL