Programmer Analyst

S M SOFTWARE SOLUTIONS INC. - Fredericton, NB (16 months ago)

Apply Now

1. Background

The ERP Project is a business transformation project with a vision: “Timely access to information that drives decision making”. The GNB ERP Solution will cover the following three business domains: Human Resource Management, Financial Management and Procurement. The goal of the ERP Project is to build and implement, across all parts of GNB (Part I, II, III and sections of part IV – NBCC and CCNB), a quality ERP solution. The Finance and Treasury Board and SNB are partners in the delivery of a single ERP Solution for Government. This project will support, and be a step towards, the objectives of the Digital New Brunswick Strategy to support enterprise information sharing and enable citizen and business centric provision of public services in the most efficient and effective manner using digital technologies. This solution will be developed over time and will encompass multiple business processes, technology systems, and information.

GNB recognizes that to enable the implementation of such a large-scale project that data migration will be a key activity. The ERP project team has developed an approved data migration strategy that will be foundational to the success of the project. The tool of choice for data migration will be SQL Server Integration Services (SSIS) to move data from existing systems to a secure data server where full data analysis activities will be executed. When the project is ready to migrate data from existing systems to our ERP system, SSIS will be used where possible.

Based on the ERP project plan, GNB needs to start data migration activities that involve a resource that has a skill set in SSIS.

The primary focus of the SQL Server Integration Services (SSIS) Developer under the terms of this Statement of Work will be to work with the ERP data migration team to develop and maintain SQL Server Integration Services (SSIS) packages.

2. Services Sought

Service New Brunswick (SNB) requires a SQL Server Integration Services (SSIS) Developer

3. Mandatory Requirements

M1 A University degree in Computer Science or Information Technology is preferred but an equivalent combination of education and experience may be considered.

M2 A minimum of five (5) years of IM/IT experience.

M3 Demonstrated experience with data migrations (Extract-Transform-Load).

M4 Good verbal and written communication skills in English

4. Scored Requirements

SNB seeks a resource that demonstrates the following scored requirements.

S1 Demonstrated experience in design, development, testing and deploying SSIS packages. Describe function, scope and size of the referenced experience. 3 Years

S2 Demonstrated experience in SQL with experience in complex query design. Describe function, scope and size of the referenced experience. 3 Years

S3 Demonstrated ability to work with a range of development methodologies (e.g. Agile, Scrum, Waterfall). Describe function, scope and size of the referenced experience. 3 Years

S4 Demonstrated ability to work in a fast-paced, team-focused environment; proven ability to manage time effectively and prioritize tasks/projects is essential. Describe function, scope and size of the referenced experience. 3 Years

S5 Demonstrated ability to understand, adhere to, and drive existing team processes and ongoing improvements. Describe function, scope and size of the referenced experience. 3 Years

S6 Demonstrated experience working within multi-vendor teams would be considered an asset. Describe role and responsibilities. 2+ years

5. Cost

Proponents MUST provide a per diem rate based on a 7.25-hour work day to complete the services outlined in this SOW and subsequent service agreement.

6. References

Vendors are requested to include references as per the table included within the Vendor Response Matrix. References may be contacted to validate information provided in the Vendor’s response.

If SNB is unable to reach the reference(s) provided, SNB reserves the right to disqualify the Vendor’s response from further consideration.

SNB reserves the right to contact references other than those provided, who are familiar with the work of the Vendor.

7. Reporting Structure

The successful candidate will report to the data migration team lead.

8. Duration/Effort

The successful candidate will be required on a full-time basis for a period of two (2) years, commencing June 24, 2019 (or sooner if possible) and ending in June 2021.

SNB reserves the right to truncate the engagement, as needed.

SNB may extend the engagement, monetarily, by 25% or 6 months, whichever is reached first, if it deems necessary.

9. Work Location and Travel

It is anticipated that the Vendor will be required to work fulltime in the Fredericton office during the engagement. Office space with current technology and access to necessary information will be provided at Kings Place, Fredericton, NB for the duration of the engagement.

The Vendor will be required to participate in daily stand ups with the data migration team for the duration of the engagement.

The Vendor must be available during SNB working hours, Monday through Friday, 8:15 AM through 4:30 PM AST.

10. Supplied Devices

SNB will provide technology devices as required to complete the services requested in this Statement of Work.

In the event a vendor’s laptop or desktop computer are requested to be used for the engagement, the successful candidate may be required to meet with the SNB’s Information Security Officer and may be required to sign an agreement governing the terms under which non-GNB devices may be connected to the GNB network.

11. Deliverables

The successful candidate must deliver the following in order to successfully complete the engagement:

  • Work with the architects and leads to analyze and clarify technical specifications to implement business logic;
  • Help develop the infrastructure requirements for a data repository;
  • Participate in application development and/or configuration activities to meet business requirements;
  • Participate in data migration, cleansing and transformation (ETL) activities – such as the design, development and deployment;
  • Analyze functional requirements and transform into transformational code;
  • Adhere to Guiding Principles and Developer Technical principles;
  • Develop and version control SSIS packages for data migration activities
  • Develop data views from a data repository as identified during the project
  • Participate in defect triage meetings.

The individual will be required to sign a non-disclosure agreement and complete the Department’s Privacy Training prior to commencing the assignment.

Job Type: Contract

Salary: $55.00 to $70.00 /hour


  • IM/IT: 5 years (Preferred)