Intermediate Analyst, Application Support

**Job Type**:

Employee

• *Duration in Months**(for fixed-term jobs):

12

• *Job Family**:

IT Support

• *# of Open Positions**:

1

• *Faculty/Service - Department**:

Facilities and Risk Management, IT Solutions

• *Campus**:

Main Campus

• *Union Affiliation**:

UOITP

• *Date Posted**:

June 19, 2025

• *Applications must be received**BEFORE**:

June 28, 2025

• *Hours per week**:

35

• *Salary Grade**:

UOITP Grade 10

• *Salary Range**:

$82,450.00 - $102,514.00

About Information Technology:

Information Technology is a dynamic and collaborative environment. We are focused on prioritizing and optimizing technological investments that facilitate the best student experience, as well as the activities of faculty, researchers and staff. Our greatest strength is the people working with us. People like you, professionals eager to flex their intellectual muscle and achieve new heights in their career. Working here gives you access to a great IT environment, rich with a diverse range of platforms, products, and services. This is a place where innovative ideas are welcome.

In a nutshell: working here is challenging and rewarding. It will bring out the best of you. We want people that have the drive to advance IT in higher education. We have the technologies to keep your inner fires burning, and benefits that can help you sustain a better lifestyle. And all these minutes away from gyms, the Byward Market, downtown, and the Rideau Canal at lunch time for runners and skaters.

• *Position Purpose**
• *In this role, your responsibilities will include**:
• ** Analysis**: Evaluates client’s business and functional requirements in order to fully explore their needs. Recommends solutions to improve systems and automation.
• ** Design**: Creates technical designs, specifications or plans in order to translate requirements into technical specification documents. Designs, plans and coordinates effective software using appropriate tools and operating systems facilitating the function of the various departments, to increase their efficiency and productivity, and to reduce costs.
• ** Deployment**: Installs or releases new software in alignment with established procedures and processes. Integrates the final product to existing software.
• ** Maintenance**: Reviews and identifies the requirement to repair and maintain current systems and software to ensure they continue to perform in keeping with client expectations. Ensures that all issues concerning data integrity, security, and confidentiality and user secrecy are dealt with. Ensures daily that the systems in production are functional and performing, and that backup and recovery processes and procedures are completed properly.
• *What you will bring**:
• University degree in Computer Science or a related field or an equivalent combination of education and experience.
• Minimum 3 years of experience in the development and implementation of system and software programs.
• Experience in Information Services, preferably in support of BI solutions.
• Experience in a complex and diverse IT environment demonstrating experience in project planning, risk analysis and project management.
• Mastering of the tools of the Microsoft BI suite (SSIS, SSAS, SSRS, SQL Server 2014-2016).
• Expertise in SQL programming.
• Knowledge of databases (e.g., DB2, SQL Server, Oracle).
• Demonstrated experience of BI architect concepts, including modeling and technology selection and implementation.
• Experience in working with Agile methodology.
• Demonstrated understanding of data warehouse concepts (ODS, DW, DM, BI OLAP, ETL, metadata).
• Knowledge of big data and cloud technology Microsoft Azure.
• Knowledge of University policies, guidelines and standards regarding system and software development and deployment.
• Knowledge of and experience with programming tools, languages, techniques and industry standards and best practices.
• Experience in troubleshooting and repairing programs.
• Analytical skills to diagnose debug and repair programming issues.
• Ability to proactively keep abreast of new/emerging technologies.
• Ability to communicate technical concepts to users.
• Bilingualism - both French and English (spoken and written).

LI-Hybrid

• *Key Competencies at uOttawa**:

Here are the required competencies for all or our employees at uOttawa:

• *Planning**:Organize in time a series of actions or events in order to realize an objective or a project. Plan and organize own work and priorities in regular daily activities.
• *Initiative**:Demonstrate creativity and initiative to suggest improvements and encourage positive results. Is proactive and self-starting. Show availability and willingness to go above and beyond whenever it is possible.
• *Client Service Orientation**:Help or serve others to meet their needs. This implies anticipating and identifying the needs of internal and external clients and finding solutions on how to meet them.
• *Teamwork and Cooperation**:Cooperate and work well with other members of