Business Intelligence Specialist

Overview

Design, develop, and maintain Microsoft BI solutions and data analytics.

Key Responsibilities

• etl development
• powerbi dashboards
• sql architecture
• bi technologies
• stakeholder collaboration
• data governance

Tasks

-Design and implement ETL processes and data pipelines to support enterprise reporting needs. -Develop, maintain, and optimize Power BI dashboards, paginated reports, and visualizations to deliver actionable insights. -Architect, design, and manage Microsoft SQL Server and related database solutions, ensuring performance, security, and scalability. -Stay current with Microsoft BI technologies and recommend improvements to processes, tools, and architectures. -Collaborate with business stakeholders to gather requirements, design BI solutions, and translate data into clear business intelligence outputs. -Troubleshoot and optimize existing BI solutions for performance and usability. -Ensure data integrity, governance, and security across reporting solutions.

Requirements

• power bi
• sql server
• power automate
• power apps
• bachelor's
• 5+ years

What You Bring

We are seeking a Business Intelligence Specialist with deep expertise in Microsoft technologies to design, build, and optimize our data-driven reporting and analytics environment. This individual will play a key role in transforming business requirements into meaningful insights through robust data models, reports, and dashboards. To be eligible to apply for this position, you must be legally entitled to work in Canada. We do not accept international applicants without a valid work permit. -Demonstrated ability to translate complex business requirements into BI solutions. -Experience with Power Automate for workflow automation (preferred). -Bachelor’s degree in Computer Science, Information Systems, Data Analytics, or related field (or equivalent work experience). -5+ years of experience working in BI, data engineering, or database development with Microsoft technologies. -Advanced proficiency in Power BI (datasets, DAX, data modeling, dashboards, and reporting). -Experience with Power Apps for building low-code business applications (preferred). -Proven experience in Microsoft SQL Server database design, development, and administration. -Knowledge of data governance frameworks and security best practices (preferred). -Familiarity with Azure Data Services (Data Factory, Synapse, Data Lake) (preferred). -Exposure to data science concepts such as predictive analytics, statistical modeling, or machine learning using Python, R, or Azure Machine Learning (preferred). -Strong knowledge of ETL concepts, data warehousing, and performance tuning. -Excellent problem-solving skills and attention to detail.

People Also Searched For

Benefits

-Dynamic, informal and collaborative work environment -A unique opportunity to build, grow and leave your impact on a multi-billion-dollar industry -Primarily an office work environment -Competitive salary and group benefits package starting from day 1 -Ongoing learning & development opportunities to help build the career you want -Group RRSP program with 100% employer match -Employee discounts

About Steelcon Group Of Companies

-Projects span from small-scale builds to transit infrastructure, retail complexes, healthcare, mixed‑use offices and hospitality landmarks. -Their in‑house teams handle engineering, drafting, detailing, fabrication and erection—delivering full‑cycle steel solutions. -They’re known for their proprietary ‘SIN beam’ technology: corrugated‑web beams that offer higher load capacity with less weight. -Facilities are certified by the American Institute of Steel Construction, underlining technical excellence. -Strategic facility locations from Ontario to Georgia allow coast‑to‑coast coverage across North America.

Sector Specialisms