Senior Programmer Analyst

Anglophone School District

2d•Remote

About The Position

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

Requirements

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.

Nice To Haves

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.

Responsibilities

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