Service New Brunswick

Senior Programmer Analyst

Open Competition

R85 2024/25-635 (13093)

Pay Band 5

Flexible within New Brunswick

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.

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.

What will you be doing?

As a member of the Provincal 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

What do you need to be successful?

ESSENTIAL QUALIFICATIONS: A university degree in Computer Science or related discipline 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 with relational database systems, primarily SQL Server

• Must have experience with maintaining and developing SQL Server databases, tables, views, queries, stored procedures, functions, scheduled jobs, triggers, packages, etc.

• Must have experience with SSIS, specifically ETL development

• Must have experience with SSRS

Written and spoken competence in English is required. Please state your language capability.

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 with data warehousing
• Experience with SSAS
• Experience with Cloud products (e.g. Azure, Power BI);
• Experience with management tools such as Active Directory Administrative Centre, Azure DevOps or TFS

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
• Teamwork and Collaboration
• Client Service & Results Orientation
• 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.

What can GNB offer you?

• Meaningful work
• Opportunities for career growth and advancement
• Career diversity within a single large employer
• Comprehensive benefits package (paid vacation plus health, dental, life and long-term disability plans) and pension.

Salary: $64,974 - $90,740 annually â?? Pay Band 5 - Management and Non-Union Pay Plan

We strongly encourage you to submit your application via the online portal https://www.ere.gnb.ca/competition.aspx?lang=E&t=Y, by using the â??Apply Onlineâ? button, to increase the efficiency and maintain a consistent candidate experience. Please ensure your application is complete by January 28, 2025 and indicate competition number R85 2024/25-635.

In the unlikely event that you experience technical difficulties or are unable to complete your application online, you can submit your application documents to [email protected] or by mail at the below address.

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.

Candidates registered with the Equal Employment Opportunity Program and veterans, who demonstrate they are among the most qualified, shall be given preference at the time of appointment.

We promote a scent-reduced environment.

We are an Equal Opportunity Employer.

The New Brunswick Public Service: Improving the lives of New Brunswickers every day!