Senior Programmer Analyst

PrecisionERP / PrecisionIT; Fredericton; On-site; CAD 80,000 - 100,000; Part time

Job summary

A leading IT consulting firm is seeking a Senior Programmer Analyst in Fredericton, NB, for a 12-month contract role. You will support a significant legacy data migration initiative, ensuring data integrity and collaborating with stakeholders. Ideal candidates will have over 5 years of experience in programming analysis and data conversion, as well as strong SQL skills. This onsite position requires someone ready to work directly in Fredericton with a competitive hourly rate based on experience.

Qualifications

• 5+ years experience as a Programmer Analyst / Systems Analyst.
• Experience with data migration and data conversion.
• Strong SQL experience with Oracle SQL, PL/SQL, T-SQL.

Responsibilities

• Migrate data from multiple legacy systems into a modern COTS platform.
• Perform data mapping, transformation, cleansing, and reconciliation.
• Ensure data integrity through validation and conversion testing.

Skills

SQL

Data Migration

Data Conversion

Communication Skills

Tools

Oracle SQL

PL/SQL

T-SQL

Microsoft Access

Excel

Visual Studio

Visual Basic

Job description

Senior Programmer Analyst (Data Migration / Loans Systems)

📍 Location: Fredericton, NB (Onsite)

🕒 Contract: 12 months

💼 Type: Contract

💰 Rate: $60–$90/hour (depending on experience)

About the Role

We are seeking a Senior Programmer Analyst to support a large-scale legacy data migration initiative within a regulated, enterprise environment. This role is hands-on and focused on data conversion, validation, and reconciliation for financial/loan systems as part of a COTS implementation.

Key Responsibilities

• Migrate data from multiple legacy systems into a modern COTS platform
• Perform data mapping, transformation, cleansing, and reconciliation
• Ensure data integrity through validation and conversion testing
• Identify and manage data conversion risks and issues
• Collaborate with business stakeholders, QA teams, and external vendors
• Support production deployment and cutover activities

Required Experience

• 5+ years experience as a Programmer Analyst / Systems Analyst
• 5+ years experience with data migration / data conversion
• Strong SQL experience (Oracle SQL, PL/SQL, T-SQL)
• Experience with financial, lending, or loan systems
• Strong communication and documentation skills

Technical Skills

• SQL (Oracle, PL/SQL, T-SQL)
• Microsoft Access & Excel
• Visual Studio
• Visual Basic / VB Scripting

Nice to Have

• Public sector or highly regulated environment experience
• Legacy system modernization projects
• Data archiving and conversion testing experience

⚠️ Note: This is an onsite role in Fredericton, NB. Only candidates able to work onsite should apply.