Date Posted: 01/05/2026
Hiring Organization: Rose International
Position Number: 495138
Industry: Government
Job Title: Senior Programmer Analyst
Job Location: Fredericton, NB, Canada, E3B 6G3
Work Model: Onsite
Employment Type: Temporary
FT/PT: Full-Time
Estimated Duration (In months): 13
Min Hourly Rate($): 50.00
Max Hourly Rate($): 70.00
Must Have Skills/Attributes: Database, MS Access, Oracle, PL/SQL, SQL, Visual Basic
Experience Desired: Previous State government experience (2 yrs)
Required Minimum Education: Bachelor’s Degree
**C2C is not available**
Job Description
***Client seeking only qualified Senior Programmer Analyst candidates located near the Fredericton, NB, CAN area due to the position requiring an onsite presence***
Required Education:
• Bachelor’s degree in Business Administration, Computer Science, or a related discipline
• An equivalent combination of education and relevant experience may be considered
Required Skills:
• 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
• Strong analytical skills for reviewing data mappings, conversion logic, and legacy data structures
• Excellent written and verbal communication skills in English
Desired Skills:
• Experience working with Commercial Off-The-Shelf (COTS) enterprise solutions
• Experience supporting housing, financial services, or loan management systems
• Familiarity with data archiving strategies for legacy system decommissioning
• Experience collaborating with Quality Assurance teams for data validation and testing
Project Overview:
The role supports the restart and completion of a previously paused loans modernization initiative. The successful candidate will review prior conversion work, validate and update data mappings, lead data cleanup efforts, and collaborate with internal teams and an external vendor to complete data conversion, testing, and deployment activities.
Job Responsibilities:
Data Conversion & Migration
• Convert existing loan data from multiple legacy systems into the modern housing COTS solution using vendor-provided dataloaders
• Review prior project work to understand historical data mappings and conversion approaches
• Analyze updated vendor documentation and identify required changes to existing data mappings
Data Analysis & Cleanup
• Analyze legacy system data to identify quality issues and cleanup requirements
• Lead facilitated sessions to define, document, and gain consensus on data cleanup and configuration requirements
Technical & Business Collaboration
• Maintain working knowledge of the housing COTS solution
• Identify risks, issues, and conflicts arising from business or technical changes
• Work with project stakeholders to determine data archiving approaches for records not migrated
Testing & Deployment
• Collaborate with Quality Assurance teams to ensure successful testing of data conversions
• Assist with deployment activities and support the transition to production
Project Support
• Collaborate with project team members, multiple government departments, and an external vendor to meet project milestones
• Attend project status meetings and working group sessions as required - **Only those lawfully authorized to work in the designated country associated with the position will be considered.**
- **Please note that all Position start dates and duration are estimates and may be reduced or lengthened based upon a client’s business needs and requirements.**
Benefits:
For information and details on employment benefits offered with this position, please visit here. Should you have any questions/concerns, please contact our HR Department via our secure website.
California Pay Equity:
For information and details on pay equity laws in California, please visit the State of California Department of Industrial Relations' website here.
Rose International is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, age, sex, sexual orientation, gender (expression or identity), national origin, arrest and conviction records, disability, veteran status or any other characteristic protected by law. Positions located in San Francisco and Los Angeles, California will be administered in accordance with their respective Fair Chance Ordinances.
If you need assistance in completing this application, or during any phase of the application, interview, hiring, or employment process, whether due to a disability or otherwise, please contact our HR Department.
Rose International has an official agreement (ID #132522), effective June 30, 2008, with the U.S. Department of Homeland Security, U.S. Citizenship and Immigration Services, Employment Verification Program (E-Verify). (Posting required by OCGA 13/10-91.).
I had a very positive experience working for Rose. The entire process is very efficient and easy.
Joanne, Consultant
I have been very pleased with my experience with Rose International. Everyone that I encountered was very helpful and courteous.
Stephanie, Consultant
Rose International has been great to me. I thank everyone there for all of their hard work; it has not gone unnoticed.
Melody, Consultant
Your team at Rose International is always very helpful and responsive.
Barbara, Consultant
As a contractor, I have to say that Rose International was by far the best agency I have worked for.
Q'testdalir, Consultant
EMPLOYEE COMMENTS