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 (M1M8)
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 (S1S8)
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
Development
- Minimum 5 years experience designing and building user interfaces 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
Required Skills:
Mandatory Requirements (M1M8) 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 (S1S8) 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 Development Minimum 5 years experience designing and building user interfaces 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
Required Education:
Mandatory Requirements (M1M8)Candidates must meet ALL of the following:M1 EducationUniversity degree in Computer Science or related disciplineEquivalent combination of education and experience may be consideredM2 IT ExperienceMinimum 10 years of IM/IT experience
Job Description Programmer Analyst (PA2)Requisition ID: RQ00307 (PA2)Client: Service New Brunswick (SNB) Health Application ServicesLocation: Fredericton New Brunswick (Onsite)Duration: 12 Months (May 12 2026 May 10 2027) Optional ExtensionEngagement Type: Contract (Full-Time 7.25 hrs/day)Overv...
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 (M1M8)
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 (S1S8)
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
Development
- Minimum 5 years experience designing and building user interfaces 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
Required Skills:
Mandatory Requirements (M1M8) 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 (S1S8) 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 Development Minimum 5 years experience designing and building user interfaces 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
Required Education:
Mandatory Requirements (M1M8)Candidates must meet ALL of the following:M1 EducationUniversity degree in Computer Science or related disciplineEquivalent combination of education and experience may be consideredM2 IT ExperienceMinimum 10 years of IM/IT experience
View more
View less
Job Location:
Monthly Salary:
Experience Required:
Posted on:
18 hours ago
Vacancies:
1 Vacancy
