Programmer Analyst - Remote / Telecommute

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.

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

M8 – Submission Compliance

~ Vendor must submit only one candidate (multiple submissions will result in disqualification)

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
Evaluation Criteria

Mandatory Requirements: Pass/Fail
Technical Scoring (S1–S8): 70%
Cost: 20%
Interview (optional): 10%
Minimum qualifying score: 70%

Additional Requirements

Provide 3 professional references (2 recent within last 5 years)
Must comply with confidentiality and privacy policies
Must complete privacy training and NDA before onboarding