Programmer Analyst (PA2)

Job Description – Programmer Analyst (PA2)

Requisition ID:   RQ00307 (PA2)

Client: Service New Brunswick (SNB) – Health Application Services

Location: Fredericton, New Brunswick (Onsite)

Duration: 12 Months (May 12, 2026 – May 10, 2027) + Optional Extension

Engagement Type: Contract (Full-Time – 7.25 hrs/day)

Overview

Service New Brunswick (SNB), under the Provincial Health Application Services (PHAS) branch, is seeking a   Programmer Analyst (PA2)to support mission-critical health systems used by Regional Health Authorities and the Department of Health.

The role involves   development, maintenance, enhancement, and support of complex health applications , with a focus on   SSRS reporting, SSIS integration, and database systems . The successful candidate will work in a hybrid of   operational support and project-based delivery within a highly regulated healthcare environment.

Requirements

Key Responsibilities

• Design, develop, implement, and maintain   SSRS reports
  
• Develop and manage   SSIS packages and ETL processes
  
• Support   health analytics and reporting systems
  
• Develop   .NET-based user interfaces
  
• Troubleshoot application, database, and reporting issues
  
• Collaborate with stakeholders including Business Teams, DBAs, and Architecture groups
  
• Ensure compliance with   enterprise architecture, privacy, and security standards
  
• Maintain technical documentation and contribute to knowledge repositories
  
• Participate in   release cycles, incident resolution, and system enhancements
  

Mandatory Requirements (M1–M8)

Candidates   must meet ALL of the following:

M1 – Education

• University degree in   Computer Science or related discipline
  
• Equivalent combination of education and experience may be considered
  

M2 – IT Experience

• Minimum  10 years of IM/IT experience
  

M3 – Health Domain Experience

• Minimum  2 years supporting health applications
  
• Must be within a   Canadian Provincial Health Authority or Department of Health
  

M4 – SSRS Expertise

• Minimum  6 years experience designing, developing, maintaining, and troubleshooting   SSRS reports
  

M5 – SSIS Expertise

• Minimum  6 years experience with SQL Server Integration Services (SSIS)
  
• Must include   creation and maintenance of SSIS packages
  

M6 – Communication Skills

• Strong   written and verbal communication skills in English
  

M7 – Availability

• Must be available to   start immediately onsite in Fredericton, NB
  

Scored Requirements (S1–S8)

Candidates will be evaluated and scored based on the following:

S1 – Health Analytics Systems (Recent Experience)

• Minimum  2+ years (within last 5 years)as a   Senior Programmer/Developer
  
• Experience in   health analytics/reporting systems for Canadian provincial health organizations
  

S2 – Database Technologies

• Minimum  6+ years experience with:
  
• SQL Server (2012 or later)
  
• Oracle (preferred)
  

S3 – SSRS Development

• Minimum  6+ years experience designing, developing, implementing, and maintaining SSRS reports
  

S4 – SSIS Development

• Minimum  6+ years experience designing, implementing, and troubleshooting SSIS packages
  

S5 – Database Development

• Minimum  6+ years experience with:
  
• Tables, views, stored procedures
  
• Functions, indexes
  
• Performance tuning and troubleshooting
  

S6 – .NET Development

• Minimum  5+ years experience designing and building   user interfaces using .NET technologies
  

S7 – Cognos/Impromptu Reporting

• Minimum  3+ years experience analyzing, troubleshooting, and converting   Cognos/Impromptu reports
  

S8 – Technical Solution Delivery

• Minimum  7+ years experience delivering and managing   technical solutions in operational environments
  

Work Environment

• Primary work location:   Fredericton, NB (onsite)
  
• Limited remote work may be permitted with approval
  
• Occasional   after-hours/weekend work (pre-approved)
  

Deliverables

• Functional and optimized   SSRS reports and SSIS packages
  
• Stable and scalable   health application solutions
  
• Technical documentation and knowledge transfer artifacts
  
• Timely completion of   incidents, service requests, and project deliverables