The Programmer Analyst provides specialized database development services, solutions and applications to enable the Client-Partners to better monitor, measure, manage and report on their programs and projects. The incumbent communicates with stakeholders, defines business requirements, considers technology options, recommends and implements optimal database development work, performs testing, debugging and fixes, migrates data to new or improved database applications, and provides maintenance, support and training to the Client-Partners.
KEY AND PERIODIC ACTIVITIES
The duties and responsibilities listed below are representative but not all-inclusive:
Primary
-
Define, design and develop systems architecture specifications and parameters for hardware and software capabilities
-
Define scope and nature of work, and gather user needs information and business requirements
-
Perform testing and find solutions to existing or potential problems (e.g. debugging)
Other
-
Carry out maintenance, including migrating data to new or improved databases
-
Provide support and training to the Client-Partners
-
Other duties as assigned
SKILLS
General and Specific Knowledge
-
Software development, database design and computer science
Formal Education and/or Certification(s) and Experience
-
Minimum: college diploma in computer science with six years’ relevant experience, or the equivalent
-
Preferred: university degree in computer science or software engineering and/or additional training in software development, process analysis, project management or business analysis
Abilities
-
Use applicable computer software and operating systems
-
Design relational databases, and define software, architecture and development needs
-
Experience with the following is preferred: CSS, JQuery/Javascript, VBA in MS Office Applications, MS Power Apps, SharePoint Designer and SharePoint Framework (SPFx).
-
Knowledge of both official languages is an asset
DEVELOPMENT AND LEADERSHIP
-
Provide functional advice and guidance to employees and the Client-Partners
WORKING CONDITIONS
-
Typical office environment with occasional travel
CHECK OUT YOUR BENEFITS
Working with us offers excellent opportunities for growth and advancement—and entitles you to one of the job market’s best benefits packages valued at between 25 and 30% of your salary.
Your package includes:
Health and Wellness
o 100% employer-paid annual sick leave, and health and dental premiums
o $400 wellness allowance to help cover expenses such as a gym membership
o $2,500 for mental health services on top of regular $2,500 paramedical coverage
o Telus Virtual Health Care and $750 Health Care Spending Account for some expenses not covered under provincial plans
Home and Family
o Life, accidental-death, and short-term disability insurance
o Enhanced inConfidence employee and family assistance program
o Maternity and parental leave top-up plan to 93% of regular gross earnings for up to 37 weeks
o Flexible workplace options, including $400 allowance every two years, to support working from home
Leave and Retirement
o Public-service pension
o Comprehensive vacation and other paid-leave plans, along with enhanced travel benefits coverage