Apply By: Monday, August 17, 2015 11:59 pm EDT
Competition Status: Posting Cancelled
Approximately 117 individuals applied for this opportunity.
Due to operational reasons the recruitment for this position has been cancelled.
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.
Organization:
Ministry of Education
Division:
Education Quality and Accountability Office (EQAO)
Position(s) language:
English
Job code:
6A003 - InformationTechnology06
Salary:
$67,590.00 - $99,600.00 Per year
Are you a seasoned IT professional and project leader with a background in Microsoft SQL Server technology? Then consider this opportunity with the Education Quality and Accountability Office (EQAO) where you will lead the design, development and implementation of technical solutions.
About the job
• define, evaluate and recommend solutions for information and database architecture requirements
• provide information, interpretation and advice to clients related to ministry and corporate I&IT policies, standards, guidelines and procedures
• lead clients through the business development life cycle, manage the acquisition and implementation of technology solutions and manage IT consulting services and contractual deliverables
• develop project proposals, business cases and gain buy-in from business
• use secure database development methods to create well-performing T-SQL statements, T-SQL objects, MDX statements and programming code for in-house applications
• create technical specifications and perform gap analysis, hands-on integration and testing of acquired solutions
What you bring to the team
Technical knowledge:
You have knowledge of
• hands-on database, business intelligence and reporting development using Microsoft SQL Server technology.
• T-SQL development, including stored procedures, views, triggers and functions.
• design and development of OLAP solutions including the creation of MDX statements and SQL Server Analysis Services (SSAS) cubes and dimensions.
• Extract, Transform and Load (ETL) experience using SQL Server Integration Services (SSIS).
• And experience with reporting using SQL Server Reporting Services (SSRS).
• code control, code and system change management, team development tools, agile development methods and tools, database scripting, automated code builds, and automated deployment.
Systems and data analysis:
• You have knowledge of systems analysis, methods and technology solutions to advise clients on general and specific technology products, contribute to the development of I&IT strategic and operational business plans, and support the preparation of IT business cases.
• You have experience gathering requirements, conducting analysis of vendor solutions.
• You can work with large datasets containing millions of data points.
• You stay abreast of current and emerging technology solutions and industry trends for application development and maintenance, desktop computer systems, network communications and inter-connectivity to advise clients on technology products.
Stakeholder management and communication skills:
• You have communication skills to prepare submissions and planning documents, reports, briefing materials and correspondence.
• You can provide advice and guidance to support Agency business area management in I&IT operational and strategic matters and foster effective relationships with stakeholders and vendors
• You can persuade clients appreciate technology concepts and generate commitment to projects
• You can prepare and present information, explanations, options and recommendations for diverse audiences.
Administrative and project management skills:
• You can acquire knowledge of policy, procurement, decision-making processes to provide information and advice, support business case development, and prepare submissions to facilitate senior-level decision-making.
• You have knowledge of IT project management policies and procedures, including budgeting and financial administration to lead projects and ensure compliance.
Apply by:
Monday, August 17, 2015 11:59 pm EDT
Position details:
- 1 English Temporary, duration up to 12 months, 2 Carlton St, Toronto, Toronto Region
Compensation group:
Association of Management, Administrative and Professional Crown Employees of Ontario
Category:
Information Technology
Posted on:
Friday, July 31, 2015
Language requirements and assessment:
All external Ontario Public Service (OPS) job ads are posted in English and French. Check the "position(s) language" section at the top of each job ad for the language requirements. For all roles, candidates are assessed in English, the business language of the OPS. If the position is bilingual (English/French), you'll also need to pass a French-language proficiency test.
Exigences en matière de langue et évaluation:
Toutes les offres d'emploi externes de la fonction publique de l'Ontario (FPO) sont affichées en français et en anglais. Consultez la section « Langue du ou des postes » en haut de chaque offre d'emploi pour connaître les exigences linguistiques. Pour tous les postes, les candidats sont évalués en anglais, la langue d'affaires de la FPO. Si le poste est bilingue (anglais/français), vous devrez également passer un test de compétences linguistiques en français.
Strengthening Ontario, together