Programming Analyst

VLink Inc; Fredericton; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading tech service provider is seeking a Senior Programmer Analyst in Fredericton, NB for a long-term contract. The role involves leading data migration projects, ensuring data integrity from legacy systems to a Commercial Off-The-Shelf solution. Candidates should have a Bachelor's degree, and at least 5 years of experience in data migration and as a Programmer Analyst, with strong SQL and communication skills. This is an onsite position, ideal for professionals experienced in cross-functional teamwork and public sector environments.

Qualifications

• Minimum 5 years of experience in data migration from legacy systems to modern platforms.
• 5+ years of experience as a Programmer Analyst, including work with financial/loan systems.
• 4+ years of SQL development experience, including T-SQL, PL/SQL, or Oracle SQL.

Responsibilities

• Lead data migration and conversion activities from legacy systems.
• Perform data mapping and transformation between source and target systems.
• Ensure data integrity through validation and cleansing.

Skills

Data migration

SQL development

Communication skills

Collaboration with stakeholders

Education

Bachelor's degree in Computer Science or related discipline

Tools

SQL Server Management Studio

Microsoft Access

Microsoft Excel

Visual Studio

Job description

Job Title: Senior Programmer Analyst

Location: Fredericton, NB - (Onsite)

Employment: Long-term Contract opportunity

About VLink

Started in 2006 and headquartered in Connecticut, VLink is one of the fastest growing digital technology services and consulting companies. Since its inception, our innovative team members have been solving the most complex business, and IT challenges of our global clients.

Job Description

Project Overview

The client is seeking a Senior Programmer Analyst to support the Housing New Brunswick (HNB) Loans Project. The successful candidate will be responsible for the migration and conversion of loan data from multiple legacy systems into a Commercial Off-The-Shelf (COTS) solution, ensuring data integrity, accuracy, and successful deployment.

This role requires strong expertise in data migration, SQL development, financial/loan systems, and collaboration with government stakeholders and vendors.

Key Responsibilities

• Lead data migration and conversion activities from multiple legacy loan systems into the HNB COTS solution using vendor-supplied data loaders
• Perform detailed data mapping and transformation between source systems and the target platform
• Ensure data integrity through validation, cleansing, reconciliation, and error resolution
• Facilitate and lead data cleanup, configuration, and technical specification sessions with business and technical stakeholders
• Identify, document, and manage risks, issues, and dependencies related to data conversion
• Support the definition and execution of data archiving strategies for legacy records not being converted
• Work closely with Quality Assurance teams to support testing, defect resolution, and validation of migrated data
• Collaborate with HNB project teams, Service New Brunswick, multiple government departments, and external vendors to ensure project milestones are met
• Assist with production deployment and post-implementation data verification

Mandatory Qualifications

• Bachelor’s degree in Computer Science, Business Administration, or a related discipline (or equivalent combination of education and experience)
• Minimum 5 years of experience specializing in data migration from legacy systems to modern platforms
• Minimum 5 years of experience as a Programmer Analyst, including work with financial and/or loan systems
• Minimum 4 years of SQL development experience, including T-SQL, PL/SQL, and/or Oracle SQL
• Excellent written and verbal communication skills in English

Desired Qualifications

• Demonstrated experience migrating complex datasets with validation, cleansing, reconciliation, and archiving
• Experience working with financial, loan, or housing systems
• Strong experience with:
• SQL (T-SQL, PL/SQL, Oracle SQL)
• SQL Server Management Studio (SSMS)
• Microsoft Access and Microsoft Excel
• Visual Studio and VB Scripting
• Experience working within government or public-sector environments
• Proven ability to work with cross-functional teams, including internal staff and external vendors

Warm Regards,

[e-mail]

D: [phone]