Senior Programmer Analyst

Service New Brunswick
Senior Programmer Analyst
R85- 2026/27-430 (17610)
Open Competition
1 Year Personal Service Contract
Pay Band 5
Flexible

Service New Brunswick is seeking an individual to join the Health Application Services Branch supporting various Government Departments as a Senior Programmer Analyst in Fredericton.

Working at Service New Brunswick is more than just a job — it's an opportunity to build a meaningful career. Guided by our vision of "Excellence in Service Delivery", our teams provide high-quality, innovative public services for customers with a focus on value for all New Brunswickers. Known for our people-oriented workplace culture, we foster an environment where innovation, inclusivity, and teamwork are celebrated. We are proud to be recognized as one of Atlantic Canada's Top Employers of 2026!

What We Offer

At SNB, our people are at the heart of everything we do.

We are:

Human-Centered: We prioritize well-being and flexibility for our employees.
Driven by Growth: We invest in your professional development and career advancement.
Celebrating Excellence: We recognize and reward outstanding contributions.
United by Purpose: Every project you work on makes a real difference for New Brunswickers.
Empowered to Decide: We trust our teams to make decisions and innovate boldly.

With offices and locations in most New Brunswick cities and a wide variety of positions and job roles, SNB offers unmatched opportunities for growth and impact, including an employee recognition program, a mentoring program, training & development opportunities, employee townhalls and ongoing leadership development.

SNB also offers a comprehensive employee benefits package.

As a member of the Provincial Health Applications team, you will be responsible for supporting application systems for a variety of systems and clients. Responsibilities will include but are not limited to:

• Providing day-to-day application development, maintenance and support functions
• Providing technical expertise and mentoring in all aspects of application development, maintenance and support, including standards and processes for deliverables.
• Ensuring application design/development, maintenance and support activities adhere to policies, standards, processes and procedures
• Interacting with various stakeholders (Business Team, Application Support Team, DBAs, other SNB teams) to collect and understand client and technical requirements
• Estimating effort and timelines for the implementation of proposed solutions
• Working closely with Application Leads and Business Owners to effectively prioritize and schedule activities
• Developing, documenting, testing, and implementing technical solutions in an operational environment and ensuring that solutions meet business requirements
• Conducting preventative maintenance, which includes changes to the applications that would improve system performance or application usability
• Collaborating with other teams within Technology Services to investigate and ensure implementation and support of effective system solutions
• Planning technology upgrades to maintain a stable and secure operational environment
• Providing support to Business Owners for user acceptance testing
• Multi-tasking in a fast-paced environment with multiple priorities, projects, and deadlines

Who are you?

• You are client-centric and passionate about delivering exceptional service.
• You demonstrate initiative and are adaptable, organized and solution oriented.
• You are an effective communicator and collaborator.

ESSENTIAL QUALIFICATIONS:

A Bachelor's degree in Computer Science, Information Technology, Software Engineering, or a related field and a minimum of five (5) years of related experience OR a college diploma in a related discipline and a minimum of seven (7) years of related experience. Subject to the response to this competition, an equivalent combination of training and experience may be considered, or the required years of experience may be increased.

• Must have experience in relational database design and development, primarily SQL Server.
• Must have experience in maintaining and developing SQL Server databases, tables, views, queries, stored procedures, functions, scheduled jobs, packages, etc.
• Must be proficient in T-SQL and understand query optimization and indexing strategies
• Must have experience in SSAS development with an in-depth understanding of building and deploying SSAS tabular models including a strong understanding of dimensions, facts, measures, relationships, and data hierarchy design.
• Must have experience in writing DAX expressions for SSAS tabular models and Power BI.
• Must have experience in developing paginated reports in Power BI Reporting Services.

Written and spoken competence in English is required.

Applicants must clearly demonstrate the essential qualifications to be given further consideration. Please state your language capability on your application and ensure that preferred language for assessment is clearly identified.

ASSET QUALIFICATIONS: Preference may be given to candidates who demonstrate they have training or experience in one or more of the following areas:

• Experience supporting applications in a health care setting.
• Experience with data warehousing.
• Experience with SSRS.
• Experience with ETL tools like SSIS or other ETL frameworks.
• Experience working with version control systems like Git.

Subject to the response to this competition, candidates may be required to demonstrate on their application one or more of the asset qualifications in addition to the essential qualifications in order to be given further consideration.

OPERATIONAL REQUIREMENTS:

• Some weekday evening and weekend work hours may be required on occasion.
• Candidates will be required to undergo Criminal History Clearance prior to appointment.

BEHAVIOURAL COMPETENCIES: The successful candidate will possess the following behavioral competencies:

• Strategy and Innovation
• Client Service & Results Orientation
• Teamwork and Collaboration
• Integrity and Self-Awareness

TECHNICAL COMPETENCIES: The successful candidate will possess the following technical competencies:

• Ability to Use Office Technology, Software, Application
• Specialized Subject Matter Expertise and Knowledge
• Planning and Organizing Skills
• Consulting Skills
• Written Communication

Resumes should be in chronological order specifying education and employment in months and years including part-time and full-time employment.

Salary: $68,614 - $95,810 annually – Pay Band 5 - Management and Non-Union Pay Plan

We thank all those who apply however only those selected for further consideration will be contacted.

We strongly encourage you to submit your application via the online portal here by clicking Apply to increase the efficiency and maintain a consistent candidate experience. Please ensure your application is complete by October 13, 2026

If you experience technical difficulties or are unable to complete your application online, please contact [email protected]. Please ensure your application is complete by October 13, 2026 indicating competition number R85-2026/27-430 (17610).

This competition may be used to fill future vacancies at the same level.

We thank all those who apply however only those selected for further consideration will be contacted.

Veterans who demonstrate they are among the most qualified, shall be given preference at the time of appointment.

We are an Equal Opportunity Employer.