Specialized IT Consultant – Power BI

Position: Specialized IT Consultant – Power BI

Location: Toronto, ON

Job ID#: RQ10391

Duration: 12Months

Role Overview

A Specialized IT Consultant is required to design, develop, and support Business Intelligence (BI) solutions using Microsoft Power BI and Cognos. The role involves translating business requirements into scalable, secure, and high-quality BI solutions, following applicable government I&IT standards and industry best practices.

The consultant will work closely with business stakeholders and technical teams throughout analysis, design, development, testing, and deployment phases.

Key Responsibilities

• Partner

with business clients to advise on I&IT solutions that meet business objectives and improve system efficiency

• Act

as a technical subject matter expert and advisor for BI deliverables

• Translate

business requirements into technical designs and solution architectures

• Design,

develop, test, deploy, and monitor BI systems and reports

• Define

software, hardware, and network requirements

• Analyze

I&IT requirements and provide independent technical recommendations

• Develop

implementation processes, procedures, work plans, and effort estimates

• Anticipate

and resolve technical issues to ensure high-quality, on-time delivery

• Support

release, deployment, and operational activities across environments

• Serve

as the primary liaison between technical teams (Dev, QA) and business stakeholders

• Ensure

solutions meet security, compliance, accessibility, and data privacy standards

• Participate

in change management and continuous improvement activities

Must‑Have Technical Experience

• 5+

years of experience as an I&IT Consultant

• Power

BI Service (Cloud): report design, development, deployment

• Power

BI Server (On‑Prem): report design and development

• Microsoft

SQL Server

• ETL

development (SSIS), daily job scheduling and monitoring

• Release

pipeline automation and deployment coordination

• Data

analysis and data management

General Technical Skills

• Systems

integration across new and existing platforms

• Technology

evaluation and recommendation aligned to business goals

• Scalable,

reliable, and secure solution design

• Collaboration

with business, development, and infrastructure teams

• Technical

support across development, testing, and release cycles

• Experience

with BI and data tools including Power BI, Cognos, Oracle, MS SQL, SSIS, Visual Studio, Git, and SQL-based reporting tools

Desirable Skills

• Information

Management principles, policies, and practices

• Business

and data requirements analysis and documentation

• Business

process modeling and analysis techniques

• Experience

with Agile and Waterfall SDLC methodologies

• Knowledge

of accessibility standards (AODA)

• Awareness

of emerging BI, analytics, and data technologies

• Experience

using CASE tools for requirements and scope documentation

Knowledge Transfer Requirements

• Knowledge

transfer to designated internal staff prior to contract end

• Completion

of all knowledge transfer activities at least two weeks before departure

• Storage

of all deliverables and documentation in approved version control repositories

• Regular

written communication on documentation status and locations

• Walk‑through

sessions and one‑on‑one knowledge transfer meetings

Experience & Skill Weighting

• Technical

Experience – 50%

• Core

Skills – 25%

• Project

Experience & Techniques – 10%

• Communication

Skills – 10%

• Public

Sector Experience – 5%

Public Sector Experience

• Experience

working in a public sector organization of comparable size or complexity

• Experience

designing solutions compliant with government I&IT standards is an asset

About Symbiotic Digital.

Symbiotic Digital provides the IT Experts you need that solve problems and get things done. See what the top 2% in their field can do for you. (Symbiotic Digital is a division of Symbiotic Group Inc.)

We serve customers in two ways, we provide:

1. Digital Experts: IT Consulting expertise. Bright Minds That Produce Proven Results

2. Recruitment: Find The Right People You Need

Serving IT & Business leaders, Symbiotic Digital provides a business system that enable us to provide the Expert Technical staff needed to solve challenging business and IT problems. IT leaders in the most reputable organizations in Canada have relied on Symbiotic Digital to help them staff difficult assignments with proven Experts uniquely evaluated by our proven QMS- Quality Management System Staff Development Model. We are a 100% Indigenous owned company.

Learn more online at https://www.symbioticgroup.com/home-sd/.

Please submit your most recent resume to: RecDep@symbioticgroup.com

View All Jobs online at: https://www.symbioticgroup.com/view-jobs/