Competition Status: Position Filled
Approximately 134 individuals applied for this opportunity.
We have completed the recruitment process and successfully hired the top candidate into the position.
To look for other job opportunities that match your skills and experience go to Job Search. You may also subscribe to our Job Alert service to receive emails when new jobs open up that match your determined search criteria.
Thank you for your interest in the Ontario Public Service.
Business Data Specialist
Organization:
Ministry of the Solicitor General
Division:
Corrections - Operational Support, Business Planning and Support Services
City:
Kanata, Kingston, London, Newmarket, North Bay, Sarnia, Sault Ste Marie, Toronto
Language of Position(s):
English
Job Term:
1 Temporary - up to 12 months with possible extension
Job Code:
17158 - Systems Officer 4
Salary:
$1,377.69 - $1,760.77 Per Week*
*Indicates the salary listed as per the OPSEU Collective Agreement.
Are you looking for an inclusive and team environment where you can showcase your IT expertise? If you are a dedicated IT professional committed to the integrity of business data, then join our team at Business Planning and Support Services Branch with the Ministry of the Solicitor General!
About Us
The Business Planning and Support Services Branch (BPSSB) is responsible for delivering strategic forward-thinking solutions to support the successful delivery of ministry priorities. The BPSSB provides financial management services for correctional services and develops and delivers multi-year correctional services information technology projects. The Branch is responsible for researching, analyzing and preparing correspondence and communications for urgent and sensitive corporate and operational correctional files and facilitates improved communications between the ministry, police services and other justice sector partners.
Why work for the Ontario Public Service (OPS)?
The OPS supports career and leadership development, invests in learning opportunities, recognizes team and individual achievements, and supports flexible work arrangements.
We are re-thinking how we deliver our services. Through various modernization initiatives, we are now accessing and delivering critical services remotely. We are striving to enable a future-ready OPS workforce through enterprise-wide strategies.
Please note: The successful candidate will have the option of working out of the following satellite office locations:
· 25 Heakes Lane, Kingston
· 10A Hearst Way, Kanata
· 659 Exeter Road, London
· 17310 Yonge Street, Newmarket
· 200 First Avenue West, North Bay
· 720 Christina Street North, Sarnia
· 800 Great Northern Road, Sault Ste Marie
· 25 Grosvenor Street, Toronto
What can I expect to do in this role?
As a Business Data Specialist, you will:
• preserve the integrity of business data through completion of merge/delete and business data management requests in support of business applications
• lead the continuous development of business data audit processes, performing business data quality audits and take corrective actions
• deliver application support to peers and front-line staff, and in all phases of application development projects
• develop, maintain technical documentation and oversee data integrity/merge delete testing of related application functionalities
• participate in the development of standards, processes, methods, techniques and controls
• establish and maintain tools, techniques, standards, documentation and performance criteria required for maintaining enterprise applications and ensuring quality control
How do I qualify?
Technical Knowledge and Skills
You have knowledge and experience of:
• mainframe, relational databases, and server and/or micro/personal computer system technologies (operating systems, application software, networks)
• emerging technologies for electronic service and internet/intranet deliveries
• theory and principles of systems design and development, and related methods, techniques, practices and standards
• Windows Operating Systems, AIX/Linux/Unix, relational databases and supporting tools and utilities.
• N-tier enterprise IT solution environments, including a fundamental knowledge of all aspects of the technology solution - server, network, Windows Active Directory, middleware, database
• Databases such as Oracle, SQL, Access; SQL and PL/SQL scripting and database management tools including TOAD for Oracle, APOS for BOE.
• IT Service Management (ITSM) concepts
• Programming language such as .NET, C++, Visual Basic, Oracle forms
• Structured Query Language (SQL and PL/SQL) and other tools to construct, test and execute scripts
Communication and Interpersonal Skills
• You can discuss client requirement, lead discussion of data maintenance options and technical processes among project team and stakeholders
• You can document work, explain analysis/recommendations, prepare procedure documentation and manuals
• You can elicit, explain, illustrate solutions and client's business requirements
• You can discuss impact on client's service delivery and achievement of business goals
• You can work directly with front line staff and stakeholders to understand details of data issues and business process impacts, investigate root cause, remediate or determine plan of action, document data changes required, design, develop, test and implement
Analytical and Problem-Solving Skills
• You can assess complex business data issues and develop solutions
• You can address new business requirements or new ways of completing day to day tasks
• You can conduct intricate systems analysis and design
• You can evaluate and recommend new data management, data auditing techniques, and software and technology for acquisition
Other Essential Knowledge
• You have knowledge of the Occupational Health and Safety Act and Regulations
• You have the ability to acquire knowledge of government and ministry's IT plans, mandates, legislative framework, policies, programs, program delivery and business goals
• You have knowledge of records and information management standards and best practices
• You have knowledge of project management methodologies and experience in leading effective business application testing
Additional Information:
Address:
- 1 English Temporary, duration up to 12 months, 25 Grosvenor St, Toronto, Toronto Region or 720 Christina St N, Sarnia, West Region or 659 Exeter Rd, London, West Region or 10A Hearst Way, Kanata, East Region or 800 Great Northern Rd, Sault Ste Marie, North Region or 200 First Ave W, North Bay, North Region or 17017 Yonge St, Newmarket, Central Region or 25 Heakes Ln, Kingston, East Region, Criminal Record and Judicial Matters Check (Fingerprint Based), Canadian Border Services Check, Credit History Check, Driver's License History, Local Police Databases Search, Social Networking Search
Compensation Group:
Ontario Public Service Employees Union
Schedule:
6
Category:
Information Technology
Posted on:
Monday, May 10, 2021
Note:
- In accordance with the Ontario Public Service (OPS), Employment Screening Checks Policy (ESCP), the top candidate(s) may be required to undergo a security screening check. Refer to the above to determine the screening checks that are required for this position.
Required security screening checks along with your written consent, will be sent to the Transition and Security Office (TSO), Talent Acquisition Branch (TAB), HR Service Delivery Division (HRSDD) to evaluate the results. If applicable, the TSO, with your written consent, will request and obtain any additional employment screening checks that were not obtained directly by you.
A record under the Criminal Code and/or other federal offence record(s) does not automatically mean you will be ineligible for the position. The employment screening check(s) will only be reviewed and evaluated by the TSO for the purpose of making a security clearance decision. The details of an individual's employment screening check(s) will be considered in specific relation to the duties and responsibilities of the position being filled. Employment screening check records will be maintained by the TSO and kept strictly confidential. - T-CL-163835/21 - The information that you provide for the purpose of this competition and the results from this competition may be used to fill other positions. These positions may be of various tenures, including short-term assignments. Your information and the results from this competition will be retained for the purpose of filling vacancies in accordance with the applicable collective agreement or policy provisions.
Please be advised that the results of this competition may be used to form an eligibility list of qualified candidates to potentially fill future vacancies represented by the Ontario Public Service Employees Union (OPSEU). In accordance with the Collective Agreement, eligibility lists are shared with OPSEU representatives. By applying to this competition, you are providing consent that your name may be shared with OPSEU representatives.
All external applicants (including former employees of the Ontario Public Service) applying to a competition in a ministry or Commission public body must disclose (either in the cover letter or resume) previous employment with the Ontario Public Service. Disclosure must include positions held, dates of employment and any active restrictions as applicable from being rehired by the Ontario Public Service. Active restrictions can include time and/or ministry-specific restrictions currently in force, and may preclude a former employee from being offered a position with the Ontario Public Service for a specific time period (e.g. one year), or from being offered a position with a specific ministry (either for a pre-determined time period or indefinitely). The circumstances around an employee's exit will be considered prior to an offer of employment.
Remember: The deadline to apply is Tuesday, May 25, 2021 11:59 pm EDT. Late applications will not be accepted.
We thank you for your interest. Only those selected for further screening or an interview will be contacted.
All Ontario Public Service external job advertisements are posted in English and French. To confirm the language requirements of a job, check the "language of position" information at the top of each job ad. For all positions, candidates will be assessed in English, the business language of the Ontario Public Service. For English/French designated bilingual positions, candidates will also be assessed through French-language proficiency testing.
Toutes les offres d'emploi externes de la fonction publique de l'Ontario sont affichées en anglais et en français. Pour connaître les exigences linguistiques, vérifiez les renseignements sur la « langue du poste » figurant dans le haut de chaque offre d'emploi. Pour tous les postes, l'évaluation des candidates et candidats se fera en anglais, la langue usuelle de la fonction publique de l'Ontario. En ce qui concerne les postes désignés bilingues, la maîtrise du français des candidates et candidats sera également évaluée.
