RFS Number: 1231551
Client: Toronto Police Service
Position: Senior BI Programmer/Developer
Anticipated Start Date: September 21st, 2017 or earlier pending background checks
Anticipated End Date: March 31st, 2018
Location: 40 College St., Toronto
Engagement Description
The engagement is to acquire a resource with the requisite skills, background, experience and professional accreditation to provide services to the Business Intelligence & Analytics Unit of the Toronto Police Service for master data management reporting activities. The resources for this contract will be engaged to develop business intelligence tools, analytical product s and data visualization using available internal and external master data records. Applicants are expected to have recent experience in the areas of Business Intelligence and master data management with highly developed technical skills.
The Service has ongoing Business Intelligence and master data management requirements which require support for a period up to March 31st 2018 with no option for extensions.
Working Conditions for all positions
The location of the engagement will be at Toronto Police Headquarters, 40 College Street, Toronto, Ontario, MSG 213.
Work day is 7-hours, Monday to Friday excluding statutory holidays; working hours will be determined at the start of the engagement but will be between the hours of 8 am and 5 p.m. There may be an occasional need for overtime or work outside of regularly scheduled hours, due to tasks or project accommodations.
All positions will be required to fill in a time sheet on a daily basis , indicating start and end time , time lunch hour taken and activities with associated time spent. Time Sheet must be authorized by assigned TPS Supervisor.
Senior Programmer/Developer
Specialist Role Name: Senior Programmer /Developer
Number of Specialists: One (I)
Experience: Minimum of 10 years of experience
Contract Term
The term of this contract is for a period of 7 months commencing in September, 2017 pending security background checks.
Responsibilities:
Elaborates and constructs technical and functional systems specifications into working, tested application programs. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, unit testing and coordinating quality assurance and user acceptance. The resource will also be required to prepare /coordinate user, system and operations documentation.
Design, develop and implement quality mechanisms for business-driven programs, unit testing and coordinate qua li ty assurance and user acceptance. The resource will also be required to prepare and coordinate user, system and operations documentation.
Description of Work:
Description of Engagement:
The Senior Programmer /Developer will work with the TPS Business Intelligence & Analytics team providing automated alert notifications and reports to various organizational stakeholders pertaining to master data management.
This development work will entail working with architects, application owners, customers/business user groups and consultants (both internal and external) to understand business and technical requirement; implement applications and integration solutions, using a specific set of tools to satisfy the requirements.
Objectives of the Specialist's Engagement:
The successful applicant will:
- contribute to all phases of the Report s Development Lifecycle for the duration of the initiative.
- ensure the stability, integrity, and efficient operation of information systems that support the core organizational functions.
- propose custom solutions that will integrate with other solutions or standalone to improve or contribute to the improvement of the organizational efficiency.
Deliverables:
The Senior Programmer/Developer selected for this role is responsible for the following activities and deliverables:
- Creating quality mechanisms incorporating visualizations in reporting
- Develop processes for automated notifications
- The design, development, implementation and documentation of results
- Propose solutions to any issues associated to the project.
- Prepare/coordinate user, system and operations documentation and training where required
Transfer of Knowledge:
This engagement requires the transfer of knowledge to TPS/ITS personnel included but not limited to training and coaching TPS/lTS team members.
Education, Training, Certifications or Designations Required:
Mandatory
- Bachelor Degree in Computer Science or a related discipline.
Preferred
- Data Management or Business Intelligence Certification from ICCP, etc
Knowledge, Skills and Experience Required:
Mandatory
- Minimum 10 years business intelligence and data visualization experience
- Experience in current web development and reporting technologies and languages
- Experience with relational and hierarchical database technologies
- Experience with master data management
- Experience in developing automated reporting
- Knowledge and experience in Client-Server structured environment
- Experience developing reports with Cognos
- Knowledge and experience with programming distributed and multi-tiered applications
- Effective troubleshooting and problem-solving skills to aid in the identification of root cause issues and ability to develop creative solutions
Preferred
- Experience working with Microsoft Windows SharePoint Services development
- Experience in current web development and reporting technologies and languages
- Experience in Public Safety/Law Enforcement business intelligence
- Data analysis skill s including proficiency in the use of statistical software packages including: Excel, SPSS Statistics, SPSS Modeller, R, STATA, SAS, SQL as well as ability to perform statistical analyses, such as regression, correlation, factor analysis, cluster analysis and structural equation modeling is highly desirable.
- Knowledge and experience in Cognos 11
Soft Skills Required:
- Excellent communication, time-management, and information-gathering (including requirements gathering) skills
- Demonstrated team building and relationship management skills
- Strong problem solving and analytical skills
- Strong written and presentation skills
- A team player with a proven track record for meeting deadlines
