Business Intelligence Specialist - Intermediate

LanceSoft Inc; Toronto; Hybrid; CAD 80,000 - 110,000; Full time

Job summary

A leading consulting firm is seeking a Business Intelligence Specialist to develop and implement BI solutions. The role requires advanced skills in data visualization, proficiency in SQL, and experience with Microsoft Power Platform. The successful candidate will work in a hybrid environment, leading discussions and improving client solutions through data-driven insights.

Qualifications

• 8-10 years of relevant experience in BI and data visualization.
• Proficiency in SQL and Microsoft Power Platform required.
• Experience in creating dashboards and reports with tools like Tableau or Power BI.

Responsibilities

• Develop business intelligence solutions and dashboards to communicate insights.
• Assess client information needs and provide cost-effective solutions.
• Prepare and deliver presentations on BI solutions.

Skills

Data Visualization

Problem-Solving

Communication

Microsoft Power Platform

SQL

No SQL

Tools

Tableau

Power BI

Microsoft Teams

Microsoft SharePoint

Microsoft Power Automate

Job description

Role: Business Intelligence Specialist - Intermediate
Location: 222 Jarvis St Toronto or 33 King St W Oshawa, ON, (Hybrid)
Duration: 12 Months Contract With 6 Month possible extension.

8-10 Years in the Following:
(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.
• 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

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