Business Intelligence Specialist

Global Technical Talent; Vaughan; On-site; CAD 85,000 - 100,000; Full time

Job summary

A staffing firm is seeking a Business Intelligence Specialist in Vaughan, ON to design, build, and optimize enterprise data and reporting solutions using Microsoft technologies. The ideal candidate has extensive SQL Server and Power BI experience, handling complex data to support business decisions. A bachelor’s degree in a related field and at least 5 years of relevant experience are required. The role offers direct placement with a competitive salary of C$85,000 to C$100,000 per year.

Qualifications

• 5+ years in BI, data engineering, or database development with Microsoft technologies.
• Proven experience in SQL Server design, development, and administration.
• Advanced Power BI proficiency and strong knowledge of ETL processes.

Responsibilities

• Design and manage Microsoft SQL Server database solutions.
• Develop and optimize Power BI dashboards and reports.
• Translate business requirements into BI solutions.

Skills

Microsoft SQL Server

Power BI development

ETL and data pipeline development

Strong problem-solving

Education

Bachelor’s degree in Computer Science or related field

Tools

Power BI

Azure Data Services

Job description

Overview

Primary Job Title: Business Intelligence Specialist

Alternate/Related Job Titles: BI Developer, Power BI Specialist, Data Analytics Specialist, Business Intelligence Analyst, SQL BI Engineer

Location: Woodbridge, ON

Onsite Flexibility: Onsite (Direct Placement)

Job Details

• Position Type: Direct Placement
• Start: October 1, 2025
• Pay Rate: C$85,000 – C$100,000/year

Job Summary

We are seeking a Business Intelligence Specialist to design, build, and optimize enterprise data and reporting solutions using Microsoft technologies. This role requires deep SQL Server expertise and advanced Power BI development skills to turn complex data into clear, actionable insights that support business decision-making.

Key Responsibilities

• Design and manage Microsoft SQL Server database solutions, ensuring performance, security, and scalability.
• Develop and optimize Power BI dashboards, reports, and visualizations.
• Translate business requirements into BI solutions in collaboration with stakeholders.
• Design and implement ETL processes and enterprise-level data pipelines.
• Maintain data governance, integrity, and security across BI environments.
• Troubleshoot and enhance existing BI solutions for usability and efficiency.
• Stay current on Microsoft BI technologies and recommend process or tool improvements.

Required Experience

• 5+ years in BI, data engineering, or database development with Microsoft technologies
• Proven experience in SQL Server design, development, and administration
• Advanced Power BI proficiency (datasets, DAX, data modeling, dashboards)
• Strong knowledge of ETL processes, data warehousing, and performance tuning
• Bachelor’s degree in Computer Science, Data Analytics, or related field (or equivalent work experience)

Nice-to-Have Experience

• Power Automate and Power Apps for workflow and app development
• Azure Data Services (Data Factory, Synapse, Data Lake)
• Data governance frameworks and security best practices
• Exposure to data science concepts (predictive analytics, ML with Python, R, or Azure ML)

Required Skills

• Microsoft SQL Server (database design, optimization, administration)
• Power BI development (DAX, modeling, dashboards)
• ETL and data pipeline development
• Strong problem-solving and attention to detail

Preferred Skills

• Azure data ecosystem familiarity
• Data governance/security knowledge
• Power Platform integration (Automate, Apps)

Additional Skills

• Predictive analytics and statistical modeling familiarity
• Machine learning exposure (Python, R, Azure ML)

About GTT

GTT is a minority-owned staffing firm and a subsidiary of Chenega Corporation, a Native American-owned company in Alaska. As a Native American-owned, economically disadvantaged corporation, we highly value diverse and inclusive workplaces. Our clients are Fortune 500 banking, insurance, financial services, and technology companies, along with some of the nation’s largest life sciences, biotech, utility, and retail companies across the US and Canada. We look forward to helping you land your next great career opportunity!

Job Number: 25-26089

#LI-Onsite #gttca #LI-GTT