Business Intelligence Analyst

Spait Infotech

Canada

On-site

CAD 75,000 - 110,000

Full time

2 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Spait Infotech is seeking a proficient BI Analyst to turn business requirements into actionable insights. You will design and maintain Power BI dashboards, implement data models, and ensure data accuracy across multiple sources.

With strong SQL skills, experience in data warehousing and ETL, you will collaborate with stakeholders and IT teams to deliver timely, data-driven recommendations for management.

Qualifications

  • Translate business requirements into technical BI solutions.
  • Develop and maintain dashboards and reports.
  • Ensure data quality and accuracy across reports.
  • Collaborate with stakeholders and IT teams.
  • Optimize dashboard performance and data models.
  • Experience with large datasets and cloud BI (Azure/AWS).

Responsibilities

  • Gather and analyze business requirements from stakeholders.
  • Collect, extract, and analyze data from multiple sources.
  • Develop interactive dashboards and reports using Power BI or Tableau.
  • Write SQL queries to extract, filter, join, and manipulate data.
  • Create and maintain business performance reports.
  • Monitor KPIs and business metrics.
  • Transform raw data into meaningful business insights.
  • Develop data models and establish relationships between datasets.
  • Use Power Query for data extraction, transformation, and loading.
  • Create calculated columns and measures using DAX.
  • Automate recurring reports and business reporting processes.
  • Identify business trends, patterns, and performance gaps.
  • Collaborate with business teams, developers, and data engineers.
  • Present analytical findings and recommendations to management.
  • Maintain and optimize existing dashboards and reports.

Skills

Power BI
SQL
Excel
Python
Tableau
Data Modeling
ETL
DAX
Data Warehousing
SSRS

Tools

Power BI Service
Tableau Server
SSRS

Job description

  • Gather and analyze business requirements from stakeholders.
  • Collect, extract, and analyze data from multiple sources.
  • Develop interactive dashboards and reports using Power BI or Tableau.
  • Write SQL queries to extract, filter, join, and manipulate data.
  • Create and maintain business performance reports.
  • Monitor Key Performance Indicators (KPIs) and business metrics.
  • Perform data validation and ensure data accuracy and consistency.
  • Transform raw data into meaningful business insights.
  • Develop data models and establish relationships between datasets.
  • Use Power Query for data extraction, transformation, and loading.
  • Create calculated columns and measures using DAX.
  • Automate recurring reports and business reporting processes.
  • Identify business trends, patterns, and performance gaps.
  • Collaborate with business teams, developers, and data engineers.
  • Present analytical findings and recommendations to management.
  • Maintain and optimize existing dashboards and reports.
Technical Skills Required

- Power BI:

  • Dashboard and report development.
  • DAX functions and calculations.
  • Power Query and data transformation.
  • Data modeling and relationships.
  • Row-Level Security (RLS).
  • Power BI Service and workspace management.
  • Scheduled data refresh.

- SQL:

  • SELECT, WHERE, GROUP BY, ORDER BY.
  • INNER JOIN, LEFT JOIN, RIGHT JOIN.
  • Subqueries and Common Table Expressions (CTEs).
  • Aggregate functions.
  • CASE statements.
  • Window functions.
  • Views and stored procedures.

- Microsoft Excel:

  • VLOOKUP and XLOOKUP.
  • Pivot Tables and Pivot Charts.
  • IF and conditional formulas.
  • Data cleaning and formatting.
  • Advanced Excel reporting.

- Data Warehousing:

  • Basic knowledge of data warehouses.
  • Fact and dimension tables.
  • Star and Snowflake schemas.
  • ETL and ELT concepts.
  • Basic understanding of data pipelines.

- Python (Preferred):

  • Pandas and NumPy.
  • Data manipulation.
  • Basic data analysis and visualization.

- Other BI Tools:

  • Tableau.
  • Microsoft Power BI Service.
  • SSRS (SQL Server Reporting Services).
Business Intelligence Skills
  • Understanding business requirements and translating them into technical solutions.
  • Knowledge of business KPIs and performance metrics.
  • Ability to analyze business trends and patterns.
  • Ability to communicate business insights effectively.
Soft Skills
  • Strong analytical and problem-solving skills.
  • Excellent communication and presentation skills.
  • Attention to detail and data accuracy.
  • Critical thinking and logical reasoning.
  • Time management and multitasking abilities.
  • Ability to work independently and collaboratively.
Key Performance Indicators (KPIs)
  • Accuracy and reliability of BI reports.
  • Timely delivery of dashboards and reports.
  • Dashboard performance and optimization.
  • Data quality and consistency.
  • Effectiveness of business insights.
  • Accuracy of KPI tracking and monitoring.
Preferred Skills
  • Experience with large datasets.
  • Knowledge of cloud-based BI solutions such as Azure and AWS.
  • Understanding of Microsoft SQL Server.
  • Knowledge of ETL tools and data integration.
  • Familiarity with ERP and CRM systems.
  • Understanding of data governance and security.
  • Knowledge of business process analysis.
  • Business performance reports.
  • SQL queries and data extraction reports.
  • Automated reporting solutions.
  • Data models and business datasets.
  • Management and executive dashboards.
  • Business insights and analytical recommendations.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Analyst
Data Analyst

Spait Infotech • Canada

On-site
CAD 65,000 - 90,000
Power BI Developer
Power BI Developer

Precision Technologies • Mississauga

On-site
CAD 110,000 - 140,000
Senior BI Specialist - Power BI & Data Modeling Lead (Hybrid)
Senior BI Specialist - Power BI & Data Modeling Lead (Hybrid)

Rubicon Path • Toronto

Hybrid
CAD 80,000 - 110,000
RQ09097 - Business Intelligence Specialist - Senior
RQ09097 - Business Intelligence Specialist - Senior

Rubicon Path • Toronto

Hybrid
CAD 80,000 - 110,000
Business Intelligence Analyst, Power BI
Business Intelligence Analyst, Power BI

Acosta, Inc. • Mississauga

On-site
CAD 65,000 - 95,000
BI Reporting Specialist
BI Reporting Specialist

Vantix Systems Inc. • Edmonton, Calgary

On-site
CAD 85,000 - 120,000
Business Intelligence Analyst
Business Intelligence Analyst

Wandata Tech • Toronto

On-site
CAD 65,000 - 90,000
Data Reporting Analyst
Data Reporting Analyst

Compunnel Inc. • Southwestern Ontario

On-site
CAD 55,000 - 65,000
Intermediate BI Analyst (onsite)
Intermediate BI Analyst (onsite)

Vantix Systems Inc. • Edmonton

On-site
CAD 65,000 - 90,000
Senior Power BI Developer | PowerBI | BI Developer
Senior Power BI Developer | PowerBI | BI Developer

Resource Informatics Group, Inc • Pickering

Hybrid
CAD 80,000 - 110,000