Companies in this catalog do not charge applicants. Never send money to apply.
Supports Clients wide-ranging business information requirements, implementing and supporting business intelligence software solutions
Develops and supports customized query applications which analyze key business data
Develops and supports guided analysis and drill-down functionality, routine scheduling and notification of report generation, and effective implementation of opportunity and key-trend alerts.
Provides Clients with approach options and tools for managing business-related data in a manner that assists in quantitative analysis of progress and the relationship between operational actions and their effect on business objectives.
General Skills:
Experience with analyzing data in source systems to identify data cleanliness issues (e.g. missing values, duplicate meanings, and invalid data) Experience with developing feedback processes to fix corrupt data in the source systems
Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide-range of data repositories (relational and multi- dimensional data stores)
Experience with developing, implementing and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts
Experience with developing monitoring and error notification processes to ensure data is updated as designed
Experience with developing automation extraction, cleansing and load scripts
Experience generating research models and reports (scheduled and ad-hoc)
Proven troubleshooting and analytical experience
Experience in process decomposition/mapping and business process re-engineering and complex data models using UML.
Experience in the use of development tools and business re-engineering software
Experience in developing enterprise architecture deliverables (e.g. business, logical, and physical models) based on Enterprise Application Processes and Modeling methodology and guidelines
Desirable Skills:
Knowledge and experience in developing data analysis applications Knowledge and understanding of Information Management principles, concepts, policies and practices Ability to provide expert advice in developing and integrating process and information models to enable identifying and eliminating redundant business processes Experience with developing monitoring and error notification processes to ensure data is updated as designed Hands on experience working with stakeholders to develop and document interface specifications design between Business Intelligence solutions and external applications Extensive experience with conceptual, logical and physical data modelling tools like Power Designer, and Visio.
Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards Supports Clients wide-ranging business information requirements, implementing and supporting business intelligence software solutions. Develops and supports customized query applications which analyze key business data. Also develops and supports guided analysis and drill-down functionality, routine scheduling and notification of report generation, and effective implementation of opportunity and key-trend alerts.
Provides Clients with approach options and tools for managing business-related data in a manner that assists in quantitative analysis of progress and the relationship between operational actions and their effect on business objectives.
Experience with analyzing data in source systems to identify data cleanliness issues (e.g. missing values, duplicate meanings, and invalid data) Experience with developing feedback processes to fix corrupt data in the source systems
Experience with developing data extraction, transformation, and load programs (daily and initial load) functionality on a wide-range of data repositories (relational and multidimensional data stores)
Experience with developing, implementing and maintaining schedule/dependency logic for Extract Transform Load (ETL) scripts
Experience with developing monitoring and error notification processes to ensure data is updated as designed
Experience with developing automation extraction, cleansing and load scripts
Experience generating research models and reports (scheduled and ad-hoc)
Proven troubleshooting and analytical experience
Experience in process decomposition/mapping and business process re-engineering and complex data models using UML.
Experience in the use of development tools and business re-engineering software
Experience in developing enterprise architecture deliverables (e.g. business, logical, and physical models) based on Enterprise Application Processes and Modeling methodology and guidelines
Desirable Skills
Knowledge and experience in developing data analysis applications Knowledge and understanding of Information Management principles, concepts, policies and practices Ability to provide expert advice in developing and integrating process and information models to enable identifying and eliminating redundant business processes.
Experience with developing monitoring and error notification processes to ensure data is updated as designed Hands on experience working with stakeholders to develop and document interface specifications design between Business Intelligence solutions and external applications Extensive experience with conceptual, logical and physical data modelling tools like Power Designer, and Visio.
Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards Skills Experience and Skill Set Requirements
Technical Skills - 35%
Demonstrates experience with designing and developing using the Microsoft suite of BI tools (SQL Server, SSIS, Azure Data Factory, SSAS, SSRS, Power BI)
Demonstrates design and development experience as a BI Programmer/ Developer
Developing cubes, reports and dashboards using SSAS and SSRS and Power BI
Demonstrates experience with documenting code changes
Demonstrates experience developing and using re-usable components to assist with BI processes, and providing detailed documentation for the tools that are developed Demonstrates experience with developing, debugging and enhancing the performance of complex SQL queries
Demonstrates experience working with SQL Server (2016 or later) / Azure SQL Database, Oracle (11 x and higher)
Demonstrates experience with enhancing the performance of SQL Queries
Demonstrates experience developing for WCAG AA compliance in web and reporting applications
Demonstrates experience working Azure Active Directory, Auth0 or other single sign on token-based authentication solutions
Demonstrates experience designing and developing solutions on Microsoft Azure or other cloud infrastructure and services
Core Skills - 35%
Demonstrates experience working with aggregate reporting
Demonstrates experience in analyzing and planning for the modernization of large, complex, multiplatform, multi- tier information technology systems
Demonstrates experience supporting business users working on projects or programs involving multiple highly inter-dependent applications and/or data sources
Demonstrates experience developing application code package using TFS (Team Foundation Server) and/or Azure DevOps
Demonstrates experience implementing star schema multi-dimensional models and documenting detailed design models
Project, Technique experience and General Skills - 20%
Demonstrates experience working in an Agile and Waterfall environment
Demonstrates experience with Software Development Life Cycle (SDLC)
Demonstrates experience with performing testing: Unit, SIT, SAT, UAT
Demonstrates experience working collaboratively with other team members and/or groups to ensure optimal solution integration
Demonstrates experience with documenting, consulting and presenting for a diverse audience of stakeholders (both technical and non-technical)
Demonstrates experience with the Software Development Life Cycle (SDLC)
Demonstrates experience with performing testing and unit testing, and conducting SIT, SAT and UAT Testing
Demonstrates experience leading business users to the successful completion of an assignment of this nature, magnitude, and complexity
Demonstrates experience problem solving and decision making
Demonstrates experience communicating clearly in both written and verbal formats
Demonstrates experience working in an agile and waterfall environment
Demonstrates experience working collaboratively with client organizations
Demonstrates experience working with multiple teams representing various areas in delivering the project
Demonstrates experience coordinating multiple projects with competing priorities
Public Sector Experience - 10%
Demonstrates experience working within the OPS, particularly within the education ministries would be an asset
Demonstrates experience developing applications that comply with GO- ITS standards would be an asset
Must Haves:
Demonstrates experience with designing and developing using the Microsoft suite of BI tools (SQL Server, SSIS, Azure Data Factory, SSAS, SSRS, Power BI)
Demonstrates design and development experience as a BI Programmer/ Developer
Demonstrates experience developing and using re-usable components to assist with BI processes, and providing detailed documentation for the tools that are developed Demonstrates experience with developing, debugging and enhancing the performance of complex SQL queries
Demonstrates experience designing and developing solutions on Microsoft Azure or other cloud infrastructure and services