Service New Brunswick

Senior Programmer Analyst

R85-2022/23-1216

Open Competition

Pay Band 5

Flexible

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

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 Business 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
• Interacting with various stakeholders (Business Team, Application Support Team, DBAs, other development teams) to collect and understand client and technical requirements
• Estimating effort and timelines for the implementation of proposed solutions
• Developing, documenting, programming, testing and implementing technical solutions to meet business requirements
• Conducting preventative maintenance, which includes changes to the applications that would improve system performance or application usability
• Providing support to Business Owners for user acceptance testing
• Collaborating with other teams within Technology Services to investigate and ensure implementation of effective system solutions
• 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 utilizing SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS)

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 with relational database systems such as Oracle and SQL Server
• Experience with software development methodologies
• Experience with Power BI
• Experience with Data Warehousing (Big Data)
• Experience with SQL Server Analysis (SSAS)
• Experience with creating and maintaining SQL Server databases, tables, views, queries, procedures, functions, scheduled jobs and other database objects
• Experience with user access permission management in SQL Server database and reporting services
• Experience with powershell

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:

• Analytical Thinking/Judgment
• Client Service Orientation
• Effective Interactive Communication
• Information Seeking
• Teamwork and Cooperation

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
• 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: $61,828 - $86,372 annually - Pay Band 5 - Management and Non-Union Pay Plan

We strongly encourage you to submit your application via the online portal by using the "Apply Online" button, to increase the efficiency and maintain a consistent candidate experience. Please ensure your application is complete by May 18, 2023.

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

Service New Brunswick

Human Resources

850 Lincoln Rd

PO Box 1998

Fredericton, NB E3B 4Z7

Telephone: (506) 457-3580

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!