IT Application Systems Analyst

Red Deer; Red Deer; Hybrid; CAD 52,000 - 79,000; Full time

Job summary

The City of Red Deer is seeking an IT Application Systems Analyst to provide ongoing support, development, and integration of enterprise business applications. You will work with business units, manage projects, and administer underlying databases while ensuring security and system integrity.

Responsibilities include application maintenance, SDLC oversight, reporting, UAT, end-user training, and collaboration with vendors. On-site role based at City Hall with potential after-hours work.

Qualifications

• Must have a 2-year Technical Computer Systems diploma or equivalent.
• Minimum 3 years in a similar IT role in a medium-sized networked environment.
• Experience with Microsoft operating systems, network products, and desktop hardware.
• Experience programming or maintaining application systems for at least 1 year.
• Preference for experience with enterprise HR/payroll systems, municipal business systems, and complex integrations.

Responsibilities

• Provide business application support and maintenance.
• Develop and integrate business applications.
• Support client business units in using business applications.
• Participate in IT projects and manage the SDLC lifecycle.
• Coordinate with vendors and stakeholders; administer security controls.
• Develop reports to support operational decision-making.
• Lead UAT and provide end-user training.
• Assist with database maintenance and IT administration.

Skills

Verbal communication

Written communication

Teamwork

Education

Diploma in Computer Systems

Tools

Microsoft SQL Server

Microsoft M365

BI reporting tools

Job description

About Red Deer

Red Deer sits at the heart of Central Alberta along the QEII corridor, perfectly positioned between Calgary and Edmonton. With more than 100,000 residents and a regional reach of over 300,000, it's a growing hub for business, services, and opportunity.

Here, big-city amenities meet small-city ease. Enjoy abundant parks and trails, vibrant arts and culture, excellent recreation and education, and a strong sense of community.

With easy access to lakes, outdoor adventures, and the mountains, plus a thriving economy and high quality of life, Red Deer is an inviting place to live, work, and grow.

About The City of Red Deer Municipal Government

The City of Red Deer is a dynamic municipal organization with a $480M operating budget, a $60M capital program, and a workforce of nearly 1,700 employees. It is focused on growing with purpose by attracting talented, community-minded people who want to make a difference.

Guided by the vision \"Our City, One Voice,\" Red Deer is building a thriving, inclusive, and connected community, with priorities centered on a vibrant economy, community wellbeing, and strong engagement.

At its core, the City values its people, embracing diverse perspectives and fostering a culture of collaboration, innovation, and shared success.

The Opportunity:

The City of Red Deer is currently recruiting for an IT Application Systems Analyst to fill a permanent full-time position. The IT Application Systems Analyst is responsible for the ongoing technical support of enterprise class business applications, development and integration of enterprise class business applications, and support of assigned business units in their use of business applications. In addition, this position will manage and/or participate in information technology projects, particularly those related to the delivery and deployment of new and enhanced business applications, and support and administer the underlying database technology for supported applications.

1. Business application support and maintenance


2. Development and integration of business applications


3. Support client business units in their use of business applications


4. Participates in and/or manages information technology projects


5. Database support and administration


6. Information Technology Administration

This position plays a key role in supporting the core IT functions of Requirements Gathering, Application Maintenance, Application Development Quality, Application Security, Application Integration, Business Intelligence and Reporting, Business Analysis, Project Management, and Innovation.

Top Key Responsibilities:

• Maintain and Support Business Applications - Ensure business applications operate effectively by troubleshooting issues, applying patches/upgrades, and maintaining system functionality.


• Analyze and Implement System Changes - Evaluate requests for enhancements or changes and implement approved updates to improve application performance and business alignment.


• Manage System Administration and Security - Administer user access, process security change requests, and ensure proper system controls are in place.


• Coordinate with Vendors and Stakeholders - Act as the primary liaison with software vendors and collaborate with internal business units to resolve issues and implement solutions.


• Develop Reports and Support Business Processes - Design and generate reports that support operational needs and improve decision-making for business units.


• Execute Application Development & Integration (SDLC) - Participate in all phases of the system development life cycle, including analysis, design, testing, deployment, and post-implementation support.


• Lead and Support User Acceptance Testing (UAT) - Develop test plans, oversee execution of test scripts, and ensure systems meet business requirements before final approval.


• Provide Training and End-User Support - Train staff and end users on application functionality and serve as ongoing support for application usage.


• Participate in and Manage IT Projects - Contribute to or lead IT projects, including planning, tracking progress, managing resources, and reporting to stakeholders.


• Support Database and IT Administration Activities - Assist with database maintenance, monitoring, backups, and general IT administrative duties including documentation, time tracking, and SLA compliance.

As our preferred candidate, you will have:

• Must have a recognized 2-year Technical Computer Systems diploma or equivalent combination of education and experience


• Must have 3 years' experience in a comparable position:
  
  
  
  • working with Microsoft operating systems, network products and desktop products
  
  
  • working in a medium sized networked environment
  
  
  • setting up hardware and software systems
  
  
  • performing maintenance and support on software and/or hardware systems
  
  
  • with at least one year's experience programming, developing, implementing or maintaining application systems in a medium sized organization
  
  
  • with at least one year's experience supporting medium to large scale purchased business applications
  
  
  • with a working knowledge of enterprise class database management systems
  
  
  
  


• To support current priorities within the IT Application Services team, preference may be given to candidates with experience in enterprise HR/payroll systems, municipal business systems, and complex system integrations including:
  
  
  
  • experience supporting or integrating enterprise Human Capital Management (HCM) or ERP systems, such as Oracle Cloud HCM or similar platforms
  
  
  • experience with Oracle Cloud HCM technologies and integrations (e.g., HDL, HCM Extracts, Oracle Integration Cloud (OIC))
  
  
  • experience supporting Infor Public Sector - Operations and Regulations (or similar municipal permitting, licensing, inspections, or work management systems) including custom coding and integrations.
  
  
  
  


• Preferred additional experience:
  
  
  
  • providing technical, application or user training
  
  
  • working with Microsoft M365 products, including business intelligence and reporting tools
  
  
  • working with financial, scheduling, registration, dispatching, and/or work management application systems
  
  
  • providing applications support in a Microsoft SQL Server environment
  
  
  • Must have demonstrated ability to establish and maintain effective working relationships with other Information Technology staff, end-user department personnel and outside vendors and consultants
  
  
  • Must have the ability to work with limited supervision
  
  
  • Must have the ability to work in a demanding and frequently stressful environment
  
  
  • Must have excellent verbal and written communication skills
  
  
  • Must be available to perform after hours call out duties on a scheduled basis
  
  
  • Must have valid driver's license and be able to perform field service calls
  
  
  
  

Affiliation: Canadian Union of Public Employees, Local 417
Status: Regular Full-time
Remuneration: $38.10 to $57.40 per hour
Hours of Work: 75 hours biweekly; Monday to Friday, potential for some evening and weekend work may be required when needed.

Additional Information:

• This position may require availability for call-out or standby outside of regular hours.


• Use of a personal vehicle is required.


• The location of work is onsite at City Hall.


• Remote work is not eligible for this position.

The City of Red Deer does not permit the use of unauthorized internet resources or Artificial Intelligence (AI) tools (for example, Copilot, ChatGPT or any other form of AI) during interviews or any supervised or timed assessments. Any violation may be investigated and result in serious consequences, including the rejection of your application.

We thank you for your application. Only those selected for an interview will be contacted.