Business Intelligence Specialist in Toronto

About the job

Responsibilities

• 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 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.
• 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.
• 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.

8-10 Years in the Following:

• Requirement 1 (35%) 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.

• Requirement 2 (20%) 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.

• Requirement 3 (20%) 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.

• Requirement 4 (25%) 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.

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.