Junior Programmer Analyst (New Grad) - VAC50F25

The Saskatchewan Liquor & Gaming Authority is seeking a self-motivated and detail-oriented individual to provide support as a Junior Programmer Analyst within the Information Technology Branch.

This Position Is Required To Work On-site.

The Junior Programmer Analyst develops, tests, documents, supports, and ensures the ongoing integrity of all business applications throughout the systems lifecycle of both custom and packaged systems. This position identifies possible solutions to information technology problems and provides information system support to both internal and external clients using their knowledge of the business functions of the user areas they support. The Junior Programmer Analyst also creates user requirements and/or system requirements determined by consulting, researching, creating screens and output reports and/or establishing processes for analyzing requirements and workflows.

Competencies (Job Family – Technical)

• Accountability (Level A) – Takes responsibility for one’s own actions, behaviours and commitments.
• Communication (Level A) – Clearly presents and receives information.
• Customer Service Excellence (Level B) – Anticipates problems and resolves issues.
• Adaptability (Level B) – Adapts behaviours and approaches to address specific situations.
• Teamwork (Level A) – Participates in team or group activities.

Primary Responsibilities

• Construction of new system functionality and enhancements.
• Make changes to application systems to permanently fix problems.
• Determine the underlying cause of data errors.
• Maintain data integrity by correcting data through SQL scripting.
• Investigate and answer questions users have regarding the business system.
• Develop, test and document new system functionality.
• Determine the effects of a planned change and how to minimize any unwanted impact.
• Document any in-depth knowledge gained through handling a potentially recurring production support incident.
• Manage support incidents, tasks, features and work items, as assigned.
• Gather and clarify the requirements provided by the business users.
• Communicate back to the users the cause and solution to a production support incident.
• Attend meetings, both formal and informal, with other ITB staff to stay informed of current support issues and collaborate to develop solutions.

Required Technical Knowledge, Skills And Qualifications

• The knowledge, skills and abilities for this position are gained through a degree or diploma specializing in Information Technology from a recognized Post-Secondary Educational Institution. The degree or diploma program must have been completed within the previous 12 months.
• A strong background in programming, developing and implementing solutions for enterprise applications or web-based computer systems, including knowledge of various programming concepts and languages.
• Knowledge of and work experience in the development and support of multi-tier systems, including:
• Programming tools or languages – C#, SQL, XML, JavaScript, HTML, Visual Studio, NET Framework.
• Databases - SQL Server.
• Operating systems – Microsoft Windows 10 or 11.
• Knowledge of applicable lifecycle methodologies.
• Business Intelligence Reporting experience would be considered an asset.
• Knowledge of database concepts, theories and principles such as structured SQL queries and stored procedures; basic database objects; relational databases (Oracle and/or SQL server), normalization, and data modelling (tables, indexes, primary or secondary keys, views).
• Knowledge of operating system functionality (for example, website administration; operating system services; and security concepts).
• Knowledge of application development concepts, techniques (for example, coding, troubleshooting, debugging) and languages, for example:
• Object-oriented languages (abstraction, composition, and inheritance).
• Web services.
• Service-oriented architecture.
• Content management.
• Knowledge of desktop commercial software applications, such as Microsoft Office, Microsoft Teams, and Microsoft SQL Management Studio.
• Ability to design or adapt systems and/or applications taking into account design alternatives, business requirements and/or resource and time constraints.
• Ability to create and/or modify a sequence of computer instructions that meet design requirements within established guidelines in order to build and test complex or distributed application components.

Working Conditions

• Office environment or setting.

What We Offer

We offer a range of benefits to support the wellbeing and professional growth of our employees, including:

Competitive Wages: $24.90 to $31.70 per hour.

Professional Development: Access to training and development programs.

Health and Safety: Comprehensive safety training.

Positive Work Environment: A supportive and inclusive workplace culture.

Comprehensive Benefits Package: Access to Employee and Family Assistance Plan (EFAP) resources and support for personal and professional challenges; matched pension; disability insurance; health and dental.

Both your cover letter and resume will be used in the screening process. You must clearly indicate how you have acquired the relevant technical knowledge outlined above. Candidates, who have been screened into the competition, will be required to participate in an assessment and interview.

The successful candidate will be subject to the SLGA Criminal Record Check and Code of Conduct policies.

Application deadline: 11:59 pm, January 21, 2025

Vacancy number: 50/F25

Expected Screening Start: January 22, 2025

Potential Start Date: February 3, 2025

SLGA is committed to achieving a representative workforce. We invite all qualified individuals to apply. Women, Aboriginal people, persons with disabilities and visible minorities are encouraged to self-identify.