SYSTEMS INTEGRATOR 2

Job ID: 46090

Job Category: Information &  Technology

Division & Section: Technology Services, Technology Standardization Delivery

Work Location: City Hall, 100 Queen St W, Toronto, M5H 2N1

Job Type & Duration: Full-time, Temporary (12 months) Vacancy

Hourly Rate: $43.58 - $47.75

Shift Information: Monday to Friday, 35 hours per week

Affiliation: L79 Full-time

Candidate List will be established. For applicability and duration, see below.

Number of Positions Open: 1

Posting Period: 15-APR-2024 to 29-APR-2024

Major Responsibilities:

• Conducts feasibility studies on business opportunities & challenges.
• Assesses, analyzes, evaluates and recommends process & policy alternatives.
• Provides inputs on improvements to current business environment & processes.
• Recommend improvements to current methodology, process, standards, and policies.
• Liaises and co-ordinates with internal & external groups on accomplishment of deliverables.
• Facilitates collection of business requirements and build consensus amongst clients on accomplishment of deliverables.
• Prepares Business Case, Business Requirements, Gap Analysis, Logical Data Models and Design documents for proposed solutions.
• Provides inputs to Data Management teams on transformation of clients' business requirements as represented by logical data models into physical data models.
• Designs and implements business & data / information requirements into databases or file management systems.
• Develops programs to translate business requirements & designs into information systems.
• Prepares test data.
• Conducts testing of programs and systems for unit, system, performance, usability, user acceptance, disaster recovery and implementation tests.
• Prepares test strategy, test cases & test scripts for system, performance, usability and acceptance testing of system solutions developed.
• Participates in walk-through of deliverables to identify potential problems.
• Prepares implementation & rollout strategies and plans.
• Prepares documentation for systems to facilitate transfer of knowledge.
• Provides inputs to "Go / No Go" cut-over decisions e.g. roll-outs.
• Travels to off-site locations.

Key Qualifications:

Your application must describe your qualifications as they relate to:

1. Post-secondary education in computer science or the approved equivalent combination of education and/or experience.
2. Considerable experience in web application development for large scale projects with J2EE, ExtJS 4/5/6, JavaScript, and Oracle.
3. Considerable experience in SQL programming, including ability to write complex scripts, optimize database performance and troubleshoot data-related issues.
4. Considerable experience in designing, developing, and deploying business reports with Crystal Reports, SAP BusinessObjects, JasperReports and PowerBI.
5. Considerable experience utilizing all the following tools and technologies: Struts, JSP, Spring and Hibernate.
6. Experience developing AODA compliant web-based applications.
7. Experience with application security, data privacy, and auditing.

You must also have:

• Ability to effectively communicate verbally and in writing.
• Proven technical skills to develop and maintain high performance integrated solution to meet complex application requirements.
• Strong analytical and problem-solving skills, listening and interpersonal skills are essential.
• Knowledge of MS PowerBI, Crystal Report & BOE Server, an asset.
• Understanding of application deployment approaches, and standard dev-QA-Production cycles.
• Ability to work with competing demands and meet deadlines.
• Ability to work effectively with a group of multidisciplinary staff in a project team setting.
• Strong customer service orientation.
• Ability to work day, afternoon and nights, including weekends as required.
• Ability to travel within the City of Toronto as required.

NOTE TO INTERNAL FULL-TIME AND PART-TIME CITY OF TORONTO EMPLOYEES:

City of Toronto employees must apply to full-time or part-time employment opportunities posted on the City's Internal Job Posting Portal.

Equity, Diversity and Inclusion

The City is an equal opportunity employer, dedicated to creating a workplace culture of inclusiveness that reflects the diverse residents that we serve. Learn more about the City’s commitment to employment equity.

Accommodation

The City of Toronto is committed to creating an accessible and inclusive organization. We are committed to providing barrier-free and accessible employment practices in compliance with the Accessibility for Ontarians with Disabilities Act (AODA). Should you require Code-protected accommodation through any stage of the recruitment process, please make them known when contacted and we will work with you to meet your needs. Disability-related accommodation during the application process is available upon request. Learn more about the City’s Hiring Policies and Accommodation Process.