BI Analyst (Multiple Openings)

Tundra Technical Solutions; Toronto; On-site; CAD 55,104 - 61,992; Full time

Job summary

A leading data and consulting firm in Toronto is looking for an operational data SME. In this role, you'll develop reports and dashboards using Power BI and Excel, analyze large datasets, and collaborate with various departments. Candidates should have 3-5 years of SQL experience and knowledge of data visualization tools. This position offers a competitive hourly rate and is a 12-month contract.

Qualifications

• 3-5 years of experience with relational databases via SQL and NoSQL.
• Ability to write high performance SQL queries.
• Knowledge of Data Lakehouse setup on Databricks is a strong asset.

Responsibilities

• Develop reports, dashboards, and self-serve data products.
• Collaborate with departments to understand reporting needs.
• Generate analytical insights for large-scale programs.

Skills

PBIX

DAX

SQL

Data visualization

Problem-solving

Collaboration

Education

Degree in Computer Science, Data Science, or Business

Tools

Power BI

Excel

Python

Job description

Overview

Tundra Technical Solutions provided pay range. This range is provided by Tundra Technical Solutions. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

CA$40.00/hr - CA$45.00/hr

Direct message the job poster from Tundra Technical Solutions

Please note, this is an opportunity for an extendable, 12 month contract.

Job Summary

In this role, the successful candidate will serve as an operational data subject matter expert (SME) within the organization in topics ranging from PSP, Pharmacy, finance and visualization and data presentation best practices. This role specializes in collecting, organizing and analyzing data from various resources and translating it into compelling reports and presentations for internal and external clients.

Role and Responsibilities

• Develop reports, dashboards and self-serve data products using Power BI and Excel.
• Evaluate source data and build views required for high performing reporting and analytics.
• Practical knowledge of programming software and languages used for report building and data analysis. PBIX, RDL, DAX, and SQL are mandatory. Knowledge and experience with Python is helpful.
• Collaborate regularly with various cross functional departments and stakeholders to understand their business reporting needs and requirements
• Generate analytical insights that drive the performance of a large-scale programs
• Support the team with mining data, data insights, data availability through producing reports and dashboards
• Assist in identifying opportunities in the business and works to produce impactful analysis
• Examine reporting relationships to increase end-user productivity, availability, and accuracy
• Working with the technical team to establish protocols to extract data in a standardized process from a variety of data sources
• Analyzing large amounts of data to provide concise, targeted reports for internal and external clients
• Able to work independently and with team to gather requirements and provide process recommendation to stakeholders
• Identify areas of opportunity to make a difference through the use of data

Qualifications

• Preferred qualifications and education requirements: Degree in Computer Science, Data Science or Business is an asset.
• 3-5 years of working experience navigating relational databases via SQL and NoSQL architectures
• Strong knowledge of PBIX and DAX is required
• Ability to write high performance SQL queries, including concepts like subqueries, common table expressions, and window functions
• Ability to work in a fast-paced environment and manage multiple projects through effective prioritization
• Strong problem-solving skills and demonstrated ability to be highly creative in formulating solutions
• Knowledge of data visualization and building dashboards in Power BI is a strong asset
• Knowledge of Data Lakehouse setup on Databricks is a strong asset

Details

• Seniority level: Associate
• Employment type: Contract
• Job function: Analyst
• Industries: Business Consulting and Services

Referrals increase your chances of interviewing at Tundra Technical Solutions by 2x.

Get notified about new Business Intelligence Analyst jobs in Toronto, Ontario, Canada.

Other related roles: Data Analyst, Business Process Reengineering; Business Analyst-Azure data/ datawarehouse; Business Analyst, Client Data Technology - Toronto, ON; Business Sytem Analyst - Basel, US Regulatory Reporting Big Data, Data Lake; Technical Business Analyst (Python and Tableau development); Toronto, Ontario, Canada CA$55.00-CA$65.00 2 hours ago; Business Analyst (Data Conversion & Reconciliation) - Consultant; Business Systems Analyst (Data Analyst) (contract); Senior Business Analyst - Insurance (Fully Remote); Business Analyst (Intermediate) 8733-0611