Apptad - Business Intelligence Specialist - Senior

Supports Clients wideranging 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 drilldown functionality routine scheduling and notification of report generation and effective implementation of opportunity and keytrend alerts.

Provides Clients with approach options and tools for managing businessrelated data in a manner that assists in quantitative analysis of progress and the relationship between operational actions and their effect on business objectives.

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 reusable 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

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 widerange 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 adhoc)

Proven troubleshooting and analytical experience

Experience in process decomposition/mapping and business process reengineering and complex data models using UML.

Experience in the use of development tools and business reengineering 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 wideranging 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 drilldown functionality routine scheduling and notification of report generation

and effective implementation of opportunity and keytrend alerts.

Provides Clients with approach options and tools for managing businessrelated 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 widerange 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 adhoc)

Proven troubleshooting and analytical experience

Experience in process decomposition/mapping and business process reengineering

and complex data models using UML.

Experience in the use of development tools and business reengineering 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

Knowledge Transfer

Transfer From Solution Development / Systems Testing/QA Specialist / Intermediate to Project Manager

When Knowledge Will Be Transferred:

• Knowledge transfer must be completed one week prior to the end of the project or one week prior to the consultant leaving the ministry.

What Knowledge Will Be Transferred:

• All deliverables including design/supporting/release/training documents must be checked into designated version control repositories (for example SharePoint). All final documents and working drafts related to project requirements or solution design must be stored on designated project repositories (for example SharePoint site HPQC TFS)
• Project manager and designated ministry staff must be regularly informed in writing (by email) of where documentation has been stored and must be provided a minimum of one walkthrough of all documentation as part of the final knowledge transfer activities.

How Knowledge Will Be Transferred:

• Knowledge will be transferred through 1 on 1 sessions emails document updates and document review with the team.

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 reusable 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 tokenbased 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 interdependent 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 multidimensional 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 nontechnical)
• 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