Responsibilities:

• Supports Client's 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
  

Experience and Skill Set Requirements:

Must Haves:

• Ability to create visual representations of data using tools like Tableau, Power BI, or similar platforms to create dashboards and reports that effectively communicate insights.
  
• Experience with low code platforms such as Microsoft Power Platform
  
• Experience developing and implementing business intelligence solutions such as Microsoft Power BI.
  
• 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 developing test cases and perform QA testing on business intelligence solutions.
  
• Effective in making presentations and conducting product/solution demonstrations
  

Skill Set Requirements:

8-10 Years in the Following:

Technical Knowledge:

• Experience with information technologies such as servers, storage, networks, operating systems, database technologies, security technologies (e.g., authentication), development tools and programming languages.
  
• Ability to create visual representations of data using tools like Tableau, Power BI, or similar platforms to create dashboards and reports that effectively communicate insights.
  
• Experience with low code platforms such as Microsoft Power Platform
  
• Experience developing and implementing business intelligence solutions such as Microsoft Power BI.
  
• Experience with SQL and No SQL database technologies.
  
• 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)
  
• Knowledge and understanding of Accessibility for Ontarians with Disability Act (AODA) and related regulations and standards
  

Analytical and Problem-Solving Skills:

• Familiar with industry best practices, policies, and strategies for deployment of business intelligence solutions.
  
• Experience assessing information and system needs of clients, and assist in the development of improved, cost-effective solutions.
  
• Experience designing and developing alternatives based on business/client needs and provide recommendations on solutions.
  
• Experience developing test cases and perform QA testing on business intelligence solutions.
  

Communication & Interpersonal Skills:

• Lead discussions on systems development options and technical processes to project teams.
  
• Excellent written and oral communication skills.
  
• Effective in making presentations and conducting product/solution demonstrations.
  
• Work independently, with minimal supervision, as well as in a team-oriented, collaborative environment.
  

Computer Skills:

• Proficiency using various office applications such as Word, Excel, PowerPoint, and Visio to develop documents and presentations.
  
• Experience using Microsoft Power Platform tools such as Power Automate and Power BI.
  
• Knowledge and experience using shared folders and working with collaborations tools such as Microsoft Teams and SharePoint.
  
• Experience using Software Development tools.