Senior BI Solutions Designer (Hybrid: Power BI & Cognos)

Rubicon Path; Toronto; Hybrid; CAD 100,000 - 130,000; Full time

Job summary

A leading technology consulting firm is looking for a Senior Solutions Designer to develop Business Intelligence solutions. The position requires strong experience in Power BI and MS SQL Server, along with knowledge in ETL processes. Candidates should have at least 10 years of experience in relevant roles. This hybrid position involves working onsite 3 days a week and allows remote work for the other 2 days.

Qualifications

• Experience with Power BI for report development and dashboards.
• Solid knowledge of MS SQL Server including T-SQL.
• Experience in data extraction, transformation, and loading (ETL).

Responsibilities

• Develop BI solutions using Power BI and Cognos.
• Work with technology teams to translate business needs.
• Define software and hardware requirements for projects.

Skills

Power BI

MS SQL Server

SSIS

Data Migration & Transformation

Cognos Development

Oracle

.NET Framework

Visual Studio

Java

Cloud Services

Education

10+ years of experience as a Solution Designer & Developer

Tools

Cognos

Informatica ETL

Attunity

GIT

Job description

A leading technology consulting firm is looking for a Senior Solutions Designer to develop Business Intelligence solutions. The position requires strong experience in Power BI and MS SQL Server, along with knowledge in ETL processes. Candidates should have at least 10 years of experience in relevant roles. This hybrid position involves working onsite 3 days a week and allows remote work for the other 2 days.