BI SQL Developer - SSRS/SSIS & Dashboards

Noranco; Vaughan; On-site; CAD 80,000 - 100,000; Full time

Job summary

A leading aerospace solutions provider in Vaughan is seeking an IT Developer to create and manage SQL reports and SSIS packages. Candidates must possess a strong understanding of SQL Server and T-SQL, along with experience in SSRS and SSIS deployment. Responsibilities include optimizing reports, collaborating on best practices, and developing web-based dashboards using .NET and VB. Competitive compensation and excellent benefits such as healthcare and employee perks are offered.

Benefits

Health Care

Dental

Life insurance

Travel insurance

Employee discounts on gym memberships

Competitive compensation

Qualifications

• Minimum of 2 years experience in SQL, SSIS, SSRS development.
• Strong understanding of SQL Server versions 2008 R2, 2012, and 2014.

Responsibilities

• Create complex SQL queries and stored procedures for reports.
• Develop SSRS reports to support business needs.
• Create SSIS packages to extract data.
• Optimize existing SQL queries and SSRS reports.
• Collaborate with the Systems Administrator on best practices.
• Maintain and develop dashboards using VB and .NET technology.

Skills

SQL Server

T-SQL

SSRS

SSIS

.NET

VB development

Web development

Analytical skills

Problem solving

Education

Post-Secondary Education in IT or related field

Job description

A leading aerospace solutions provider in Vaughan is seeking an IT Developer to create and manage SQL reports and SSIS packages. Candidates must possess a strong understanding of SQL Server and T-SQL, along with experience in SSRS and SSIS deployment. Responsibilities include optimizing reports, collaborating on best practices, and developing web-based dashboards using .NET and VB. Competitive compensation and excellent benefits such as healthcare and employee perks are offered.