Service New Brunswick (SNB) under the Provincial Health Application Services (PHAS) branch is seeking aProgrammer Analyst (PA2) to support mission-critical health systems used by Regional Health Authorities and the Department of Health.
The role involvesdevelopment maintenance enhancement and support of complex health applications with a focus onSSRS reporting SSIS integration and database systems. The successful candidate will work in a hybrid ofoperational support and project-based delivery within a highly regulated healthcare environment.
Requirements
Key Responsibilities
Design develop implement and maintainSSRS reports
Develop and manageSSIS packages and ETL processes
Supporthealth 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 withenterprise architecture privacy and security standards
Maintain technical documentation and contribute to knowledge repositories
Participate inrelease cycles incident resolution and system enhancements
Mandatory Requirements (M1M8)
Candidatesmust meet ALL of the following:
M1 Education
University degree inComputer Science or related discipline
Equivalent combination of education and experience may be considered
M2 IT Experience
Minimum10 years of IM/IT experience
M3 Health Domain Experience
Minimum2 years supporting health applications
Must be within aCanadian Provincial Health Authority or Department of Health
M4 SSRS Expertise
Minimum6 years experience designing developing maintaining and troubleshootingSSRS reports
M5 SSIS Expertise
Minimum6 years experience with SQL Server Integration Services (SSIS)
Must includecreation and maintenance of SSIS packages
M6 Communication Skills
Strongwritten and verbal communication skills in English
M7 Availability
Must be available tostart immediately onsite in Fredericton NB
Scored Requirements (S1S8)
Candidates will be evaluated and scored based on the following:
S1 Health Analytics Systems (Recent Experience)
Minimum2 years (within last 5 years) as aSenior Programmer/Developer
Experience inhealth analytics/reporting systems for Canadian provincial health organizations
S2 Database Technologies
Minimum6 years experience with:
SQL Server (2012 or later)
Oracle (preferred)
S3 SSRS Development
Minimum6 years experience designing developing implementing and maintaining SSRS reports
S4 SSIS Development
Minimum6 years experience designing implementing and troubleshooting SSIS packages
S5 Database Development
Minimum6 years experience with:
Tables views stored procedures
Functions indexes
Performance tuning and troubleshooting
Development
Minimum5 years experience designing and buildinguser interfaces technologies
S7 Cognos/Impromptu Reporting
Minimum3 years experience analyzing troubleshooting and convertingCognos/Impromptu reports
S8 Technical Solution Delivery
Minimum7 years experience delivering and managingtechnical solutions in operational environments
Work Environment
Primary work location:Fredericton NB (onsite)
Limited remote work may be permitted with approval
Occasionalafter-hours/weekend work (pre-approved)
Deliverables
Functional and optimizedSSRS reports and SSIS packages
Stable and scalablehealth application solutions
Technical documentation and knowledge transfer artifacts
Timely completion ofincidents 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
Service New Brunswick (SNB) under the Provincial Health Application Services (PHAS) branch is seeking aProgrammer Analyst (PA2) to support mission-critical health systems used by Regional Health Authorities and the Department of Health.
The role involvesdevelopment maintenance enhancement and support of complex health applications with a focus onSSRS reporting SSIS integration and database systems. The successful candidate will work in a hybrid ofoperational support and project-based delivery within a highly regulated healthcare environment.
Requirements
Key Responsibilities
Design develop implement and maintainSSRS reports
Develop and manageSSIS packages and ETL processes
Supporthealth 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 withenterprise architecture privacy and security standards
Maintain technical documentation and contribute to knowledge repositories
Participate inrelease cycles incident resolution and system enhancements
Mandatory Requirements (M1M8)
Candidatesmust meet ALL of the following:
M1 Education
University degree inComputer Science or related discipline
Equivalent combination of education and experience may be considered
M2 IT Experience
Minimum10 years of IM/IT experience
M3 Health Domain Experience
Minimum2 years supporting health applications
Must be within aCanadian Provincial Health Authority or Department of Health
M4 SSRS Expertise
Minimum6 years experience designing developing maintaining and troubleshootingSSRS reports
M5 SSIS Expertise
Minimum6 years experience with SQL Server Integration Services (SSIS)
Must includecreation and maintenance of SSIS packages
M6 Communication Skills
Strongwritten and verbal communication skills in English
M7 Availability
Must be available tostart immediately onsite in Fredericton NB
Scored Requirements (S1S8)
Candidates will be evaluated and scored based on the following:
S1 Health Analytics Systems (Recent Experience)
Minimum2 years (within last 5 years) as aSenior Programmer/Developer
Experience inhealth analytics/reporting systems for Canadian provincial health organizations
S2 Database Technologies
Minimum6 years experience with:
SQL Server (2012 or later)
Oracle (preferred)
S3 SSRS Development
Minimum6 years experience designing developing implementing and maintaining SSRS reports
S4 SSIS Development
Minimum6 years experience designing implementing and troubleshooting SSIS packages
S5 Database Development
Minimum6 years experience with:
Tables views stored procedures
Functions indexes
Performance tuning and troubleshooting
Development
Minimum5 years experience designing and buildinguser interfaces technologies
S7 Cognos/Impromptu Reporting
Minimum3 years experience analyzing troubleshooting and convertingCognos/Impromptu reports
S8 Technical Solution Delivery
Minimum7 years experience delivering and managingtechnical solutions in operational environments
Work Environment
Primary work location:Fredericton NB (onsite)
Limited remote work may be permitted with approval
Occasionalafter-hours/weekend work (pre-approved)
Deliverables
Functional and optimizedSSRS reports and SSIS packages
Stable and scalablehealth application solutions
Technical documentation and knowledge transfer artifacts
Timely completion ofincidents 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 Location:
Monthly Salary:
Experience Required:
Posted on:
Vacancies:
