Senior Programmer Analyst

Government of New Brunswick / Gouvernement du Nouveau-Brunswick

. Provide day-to-day application development, maintenance, and support functions .

Posted 9/29/2026full-timeRemote • CanadaSenior💰 CA$68,614 - CA$95,810 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in application development, maintenance, and support, with a strong focus on SQL Server database management, T-SQL proficiency, and SSAS development. Capable of collaborating with cross-functional teams to deliver effective technical solutions while managing multiple priorities in a fast-paced environment.

Highest-signal resume keywords

SQL Server Database DevelopmentT-SQL ProficiencySSAS DevelopmentPower BI Reporting ServicesRelational Database Design

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Application DevelopmentDatabase MaintenanceT-SQLDAX ExpressionsSSAS Tabular ModelsQuery OptimizationIndexing StrategiesPaginated ReportsTechnical DocumentationPreventative Maintenance

Soft Skills

Technical MentoringCollaborationTime ManagementCommunicationProblem Solving

Tools & Technologies

SQL ServerPower BISSASReporting ServicesData Hierarchies

Industry Keywords

Application SupportUser Acceptance TestingOperational EnvironmentSystem PerformanceBusiness Requirements

Tech Stack

Tools & technologies

SQL

About the role

Key responsibilities & impact

Provide day-to-day application development, maintenance, and support functions
Provide technical expertise and mentoring in application development, maintenance, support, standards, and deliverable processes
Ensure application design, development, maintenance, and support activities adhere to policies, standards, processes, and procedures
Interact with business teams, application support teams, DBAs, and other SNB teams to gather client and technical requirements
Estimate effort and timelines for proposed solutions
Work with Application Leads and Business Owners to prioritize and schedule activities
Develop, document, test, and implement technical solutions in an operational environment
Conduct preventative maintenance to improve system performance and application usability
Collaborate with Technology Services teams to investigate and implement effective system solutions
Plan technology upgrades to maintain a stable and secure operational environment
Support Business Owners with user acceptance testing
Manage multiple priorities, projects, and deadlines in a fast-paced environment

Requirements

What you’ll need

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
An equivalent combination of training and experience may be considered
Experience in relational database design and development, primarily SQL Server
Experience maintaining and developing SQL Server databases, tables, views, queries, stored procedures, functions, scheduled jobs, and packages
Proficiency in T-SQL and understanding of query optimization and indexing strategies
Experience in SSAS development, including building and deploying SSAS tabular models and designing dimensions, facts, measures, relationships, and data hierarchies
Experience writing DAX expressions for SSAS tabular models and Power BI
Experience developing paginated reports in Power BI Reporting Services
Written and spoken competence in English
Some weekday evening and weekend work hours may be required on occasion
Candidates must undergo Criminal History Clearance prior to appointment
Resumes must be in chronological order and specify education and employment in months and years, including part-time and full-time employment

Benefits

Comp & perks

Employee recognition program
Mentoring program
Training & development opportunities
Employee townhalls
Ongoing leadership development
Comprehensive employee benefits package
Flexible workplace culture and flexibility
Professional development and career advancement opportunities