Programmer Analyst II – Community and Connected Care
Fredericton - Canada
Job Summary
- Develop document code test implement and maintain technical solutions that meet business and operational requirements.
- Perform programming systems analysis application enhancements defect resolution and software maintenance.
- Provide ongoing operational and technical support for provincial healthcare applications and electronic health record (EHR) systems.
- Investigate and resolve application incidents system errors service requests and production problems.
- Support application upgrades releases deployments configuration changes and performance optimization.
- Develop maintain and troubleshoot database objects queries stored procedures reports and data extracts using Oracle and Microsoft SQL Server.
- Develop and maintain Microsoft SQL Server Reporting Services (SSRS) reports and reporting solutions.
- Develop and maintain PowerShell scripts to automate operational tasks support application administration and improve system efficiency.
- Support application integration and interface processing using integration engines including Rhapsody.
- Work with Enterprise Master Patient Index (EMPI) and client identity management solutions including IBM Initiate and IBM InfoSphere where applicable.
- Maintain and applications and related database components.
- Support the investigation and resolution of healthcare data integration registry matching reporting and application interoperability issues.
- Prepare and update technical documentation operational procedures release documentation and team knowledge-base materials.
- Participate in team scrums technical discussions release planning and continuous improvement initiatives as required.
- Provide operational support as part of the teams on-call rotation including approved after-hours and weekend support.
- Collaborate with business stakeholders technical teams application vendors and other support groups to ensure reliable healthcare application services.
- Comply with applicable privacy confidentiality information security and healthcare data protection requirements.
- Complete the required confidentiality agreement and departmental privacy training before commencing the assignment.
- A university degree in Computer Science or a similar discipline is preferred.
- An equivalent combination of relevant education and practical experience may be considered.
- Minimum 15 years of Information Management / Information Technology (IM/IT) experience.
- Minimum 10 years of experience as a Senior Programmer with hands-on programming and systems analysis responsibilities.
- Excellent verbal and written communication skills in English including the ability to communicate technical information clearly prepare technical documentation and collaborate with business and technical stakeholders.
- Must be available to commence the assignment on or about December 1 2026.
- Only one candidate may be submitted per vendor for this requisition. Multiple submissions from the same vendor will result in disqualification of all that vendors applications.
- Minimum 4 years of experience working with provincial healthcare applications and Electronic Health Record (EHR) systems.
- Experience supporting maintaining enhancing or integrating healthcare applications clinical information systems patient records or healthcare data repositories is required.
- Minimum 15 years of experience developing documenting coding testing and implementing technical solutions to meet business requirements.
- Strong experience in programming systems analysis application maintenance defect resolution and production implementation.
- Minimum 4 years of experience working with healthcare or enterprise integration engines such as Rhapsody Integration Engine.
- Experience troubleshooting interfaces supporting system integrations and resolving data exchange issues is an asset.
- Minimum 15 years of experience working with Oracle and/or Microsoft SQL Server.
- Experience with database development SQL queries stored procedures data extracts troubleshooting and performance optimization.
- Minimum 5 years of experience developing and maintaining PowerShell scripts for automation application support system administration or operational processes.
- Minimum 10 years of experience with Microsoft SSRS including report development maintenance troubleshooting and data presentation.
- Minimum 1 year of experience working with EMPI solutions such as IBM Initiate and IBM InfoSphere including patient or client identity matching registry management or related integration and data quality activities.
- Minimum 10 years of experience developing maintaining enhancing or applications.
- Client Registry: IBM Initiate
- Provider Registry: NextGate MatchMetrix Provider Registry
- Location Index: application and SQL database
- eHealthNB Clinical Data Repository (CDR): Orion Health
- Electronic Health Record (EHR): Orion Health Concerto
- NB Labs (NBAMA) Mapping Assistant: Custom PHP application
- Provincial Integration Engine: Orion Health Rhapsody Integration Engine
- Data Extracts Views and Reports: Oracle Microsoft SQL Server and SSIS
- Electronic Medical Record (EMR): IntraHealth solutions including Rhapsody Integration Engine Client Registry and Electronic Health Record Viewer
- Drug Information System: Maximus/Deltaware Medigent
- Completing assigned application releases and implementation activities.
- Delivering assigned maintenance support and development activities including service requests incidents problems and releases.
- Resolving incident and problem management tasks within established operational processes.
- Maintaining and updating team documentation and knowledge repositories.
- Participating in application operations and the teams on-call rotation.
- Supporting team scrums technical reviews and other assigned activities.
- Ensuring that technical solutions are documented tested and implemented appropriately.
- The position is 100% onsite at 520 King Street HSBC Place Fredericton New Brunswick for the duration of the engagement.
- Remote work may be possible only when requested and approved by SNB.
- Travel outside Fredericton is not expected.
- Any overtime or work outside regular business hours requires prior approval.
- The successful candidate must sign a non-disclosure agreement and complete departmental privacy training before starting.
Required Skills:
M2 IM/IT Experience Minimum 15 years of Information Management / Information Technology (IM/IT) experience. M3 Senior Programmer Experience Minimum 10 years of experience as a Senior Programmer with hands-on programming and systems analysis responsibilities. M4 English Communication Excellent verbal and written communication skills in English including the ability to communicate technical information clearly prepare technical documentation and collaborate with business and technical stakeholders. M5 Availability Must be available to commence the assignment on or about December 1 2026. S1 Provincial Healthcare and Electronic Health Records Minimum 4 years of experience working with provincial healthcare applications and Electronic Health Record (EHR) systems. Experience supporting maintaining enhancing or integrating healthcare applications clinical information systems patient records or healthcare data repositories is required. S2 Software Development and Technical Solutions Minimum 15 years of experience developing documenting coding testing and implementing technical solutions to meet business requirements. Strong experience in programming systems analysis application maintenance defect resolution and production implementation. S3 Integration Engines Minimum 4 years of experience working with healthcare or enterprise integration engines such as Rhapsody Integration Engine. Experience troubleshooting interfaces supporting system integrations and resolving data exchange issues is an asset. S4 Oracle and Microsoft SQL Server Minimum 15 years of experience working with Oracle and/or Microsoft SQL Server. Experience with database development SQL queries stored procedures data extracts troubleshooting and performance optimization. S5 PowerShell Scripting Minimum 5 years of experience developing and maintaining PowerShell scripts for automation application support system administration or operational processes. S6 Microsoft SQL Server Reporting Services (SSRS) Minimum 10 years of experience with Microsoft SSRS including report development maintenance troubleshooting and data presentation. S7 Enterprise Master Patient Index (EMPI) Minimum 1 year of experience working with EMPI solutions such as IBM Initiate and IBM InfoSphere including patient or client identity matching registry management or related integration and data quality activities. Development Minimum 10 years of experience developing maintaining enhancing or applications. Candidates should provide detailed examples for each scored requirement. Each example must identify the client or employer project or role duration technical responsibilities and relevant achievements.
Required Education:
M1 EducationA university degree in Computer Science or a similar discipline is equivalent combination of education and relevant professional experience may be considered.