Programmer Analyst II – Community and Connected Care

Programmer Analyst II – Community and Connected Care

Client: Service New Brunswick (SNB)

Department: Health Application Services – Provincial Health Application Services (PHAS)

Location: 520 King Street, HSBC Place, Fredericton, New Brunswick, Canada

Work Arrangement: 100% Onsite

Contract Duration: December 1, 2026 – November 30, 2027

Contract Term: 12 months, full-time

Hours: 7.25 hours per day, 5 days per week

Position Overview

Service New Brunswick (SNB) is seeking an experienced Programmer Analyst II – Community and Connected Care to join the Provincial Health Application Services (PHAS) team. The successful candidate will support, maintain, enhance and develop provincial healthcare applications that serve New Brunswick's healthcare sector, including Regional Health Authorities and the Department of Health.

This role combines application development, programming and analysis, production support, incident and problem resolution, system enhancements, database development, integration support and application release activities. The successful candidate will work with complex healthcare information systems and electronic health records, ensuring application stability, security, performance and alignment with business requirements.

The resource will also participate in the team's on-call rotation and provide after-hours support when required and approved.

Key Responsibilities

• 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 enhance .NET 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 team's 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.

Requirements

Mandatory Requirements – M1 to M6

Candidates must clearly demonstrate compliance with all mandatory requirements. The resume and submission matrix must specify employers or clients, project or role descriptions, responsibilities, and employment dates in Month/Year–Month/Year format.

M1 – Education

• A university degree in Computer Science or a similar discipline is preferred.

• An equivalent combination of relevant education and practical experience may be considered.

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.

M6 – Submission Limit

• Only one candidate may be submitted per vendor for this requisition. Multiple submissions from the same vendor will result in disqualification of all that vendor's applications.

Required Technical Skills and Scored Requirements – S1 to S8

Candidates should demonstrate the following experience with specific project examples, responsibilities and dates.

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.

S8 – .NET Development

• Minimum 10 years of experience developing, maintaining, enhancing or supporting .NET 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.

Healthcare Applications and Technology Environment

The Community and Connected Care portfolio includes the following systems and technologies:

• Client Registry: IBM Initiate

• Provider Registry: NextGate MatchMetrix Provider Registry

• Location Index: Custom .NET 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

Experience with these platforms is beneficial, particularly where it demonstrates the candidate's ability to support healthcare application operations, integrations, registries, clinical data and reporting. Other applications may be added to the portfolio during the contract.

Deliverables

The successful candidate will be responsible for:

• 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 team's on-call rotation.

• Supporting team scrums, technical reviews and other assigned activities.

• Ensuring that technical solutions are documented, tested and implemented appropriately.

Work Location and Conditions

• 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.

Ideal Candidate Profile

The ideal candidate is a highly experienced Programmer Analyst with a strong background in enterprise application development and production support, preferably within provincial healthcare environments. The candidate should combine extensive programming and analysis experience with hands-on expertise in Oracle/SQL Server, .NET, PowerShell, SSRS, healthcare integration engines and EMPI technologies.

The successful resource will be comfortable supporting business-critical healthcare systems, resolving production issues, implementing technical enhancements, documenting solutions and participating in operational support rotations while working collaboratively with SNB's Health Application Services team.