Must-haves: Demonstrated experience in developing using Cognos version 11 Demonstrated experience with developing Cognos Cubes and in Cognos Query Studio Nice to Have: Public Sector experience Assignment Type:This position is currently listed as “Onsite” due to COVID-19 related WFH direction. Once OPS staff are required to return to the office, the resource under this request will be required to work onsite as well. Responsibilities: Design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities. Required to translate technical systems specifications into working, tested applications. This includes developing detailed programming specifications, writing and/or generating code, compiling data-driven programs, maintaining, and conducting unit tests. Resolves and troubleshoots technical problems which arise during the use and operation of software packages, including technical assistance in implementation, conversion and migrations. Key deliverables and services to be performed by the BI Programmer/Developer include, but are not limited to, the following: Participate in the analysis, design, development and testing on the new requirements; work closely with the subject matter experts, managers, and staff of the ministries on issues and business needs; Participate in requirement gathering BI solution; Participate in project design and code walkthroughs; Participate in the SIT testing and support the System Acceptance and User Acceptance Testing; Propose and develop proof of concept solutions for extending the use of BI applications within DDSB. Participate in discussions with Infrastructure Technology Services (ITS), Corporate Security Branch (CSB), Centre of Excellence for Accessibility and Information Privacy and Achieves (IPA) Office to ensure the application remains compliant with all applicable GO-ITS standards; Participate in discussions with the business analyst and business architect regarding any changes required to business and/or system requirements; Support the analysis of existing business processes, design and recommend process improvements to effectively harness the benefits of using the application(s); Provide input and complete architectural/development artifacts as required; Liaise with IT specialists and unit leads and work closely with support team members and relevant stakeholders; Contribute in developing realistic work breakdown structure and preparing overall project schedule; Perform day-to-day tracking, reporting and facilitating resolution of issues and risks for all project activities; Ensure defined Change Management Process is followed for any change from agreed scope, schedule, or quality; Provide input in creation of change requests; Work collaboratively with other groups to ensure optimal integration as required; Perform knowledge transfer to the Ministry staff. Participate in the analysis, design, development, and unit testing of all the projects ETL components i.e. Mappings, Workflows, Data Mart; Reports, Cubes, and Dashboards; Develop Cubes, Reports, and Dashboards using Cognos, SSAS and SSRS; Develop, test, and deploy full code package for the solution in Visual Source Safe (VSS) and Team Foundation Server (TFS); Work closely with the subject matter experts, managers, and staff of the ministries on issues and business needs; Propose and develop proof of concept solutions for extending the use of Microsoft BI technologies within DDSB. Benefits General Skills: Experience in programming and analysis; specialized software package support at the specified experience level Ability to collaborate with IT Professionals throughout the Software Development Life Cycle Experience in structured methodologies for the development, design, implementation and maintenance of applications Experience in design, code, test, debug and document applications Experience in the use of object and/or third generation language development tools Experience in one or more programming languages Experience in application design, latest design patters, deployment and troubleshooting Experience with relational and hierarchical database technologies Experience in the use of information retrieval packages using query languages Experience with one or more communications protocols Experience in structured methodologies for the design, development, implementation and maintenance of applications Experience eliciting and documenting information from diverse business area stakeholders and subject matter experts Excellent analytical, problem-solving and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills A team player with a track record for meeting deadlines Full Stack Skills: Proficient with both front end and back end development, including any associated areas such as database design/management and DevOps Knowledge and experience with design and implementation of the overall web architecture Experience with implementation of approved user interface, design and deployment of database Knowledge and experience ensuring the entire stack is designed and built for speed and scalability Knowledge and experience with the design and construction of REST API services Knowledge and experience integrating front-end UI with the constructed API Knowledge and experience in design and implementation of continuous integration and deployment Desirable Skills: Knowledge and experience with programming Internet-ready applications Knowledge and experience in rapid application development (RAD) methodologies Knowledge and understanding of Information Management principles, concepts, policies and practices Experience with middleware and gateways Experience reviewing, analyzing, and modifying product installation scripts including encoding, testing, debugging Ability to provide post-implementation support and resolve any post-implementation technical issues Experience conducting design walkthrough sessions with project team Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards Ability to provide user and system documentation as required The BI Programmer/Developer must have a minimum of 5+ years of the following skills and experience: Demonstrated experience in performing gap fit analysis and impact analysis; Strong working experience in an environment where Cognos (version 11), Informatica and Oracle are used together Proven design and development experience as a Cognos BI Programmer/Developer Proven experience in debugging BI defects and errors as they relate to queries, Framework Manager, Reports, Cubes or Dashboards Experience in developing the Application Code package using MS Visual Source Safe or Team Foundation Server. Demonstrated advanced skills using Oracle Data Integrator and Informatica; Analyse the new development needs and design, develop and unit test all the projects Cognos components; i.e. Framework Manager, reports, cubes, and dashboards; Demonstrated development experience in an environment where SQL Server, Oracle, SSIS, SSAS, SSRS, Power BI and SharePoint are used together; Demonstrated development experience with SQL Server 2012, 2016, Oracle 10.x and 11.x databases Demonstrated experience with designing and developing using the Microsoft suite of BI tools (SQL Server, SSIS, SSAS, SSRS, Power BI) together Experience implementing star schema multi-dimensional models; Experience in database management and administration; Experience enhancing performance of SQL Queries; Analyse the new development needs and design, develop and unit test all the projectsCognos components Experience in documenting business processes, business requirements, and system requirements; Experience working with both the business users and IT development teams to ensure business requirements are properly reflected in the system design and technical specifications; Demonstrated experience in the analysis and planning for the modernization of large, complex multi-platform, multi-tier information technology systems; Experience supporting business users working on projects or programs involving multiple highly inter-dependent applications and/or data sources; Experience working on projects within a multi-client/partner environment; Excellent analytical, problem-solving, and decision-making skills; verbal and written communication skills; interpersonal and negotiation skills; Demonstrable experience with quality assurance, and change management tools; Demonstrable skills and experience with documenting deliverables outlined in Deliverables section; Demonstrated experience performing system testing, unit testing, and user acceptance testing; Knowledge of aggregate reporting; A team player with the ability to coordinate multiple projects with competing priorities and strict deadlines; Experience with TRAs, PIAs, and Security Systems within the OPS; Knowledge and experience with OPS corporate gating and enterprise architecture checkpoints processes; Good communication skills, both written and oral. Experience within the MEDU is an asset; and Knowledge and experience in working in accordance with policies and procedures of the Ontario Public Service.