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