IT Developer

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

Job Description

Posted Friday, November 18, 2016 at 5:00 AM

Noranco is a world class, integrated manufacturer and solutions provider to the international commercial and military aerospace sectors. We provide added value to our customers through a wide range of sophisticated capabilities including high precision machining and sheet metal fabrication, processing, assembly, testing and supply chain management

Reporting Relationship

The IT Developer reports directly to the IT Manager, Noranco Canada.

Primary Duties & Responsibilities

• Create complex SQL queries and stored procedures for new SSRS based reports.
• Develop professional SSRS reports to support business needs using Microsoft SQL Server and/or Crystal Reports.
• Create SSIS packages to extract and deliver data to end users.
• Optimize existing SQL queries and SSRS reports.
• Collaborate with Systems Administrator to enforce best practices for SQL environment.
• Create and/or maintain data warehouse.
• Maintain dashboards created by vendors and/or develop new dashboards based on VB and .NET technology.
• Work with management team to gather business requirements and develop solution.
• Analyze and troubleshoot complex queries, views or stored procedures.
• Convert Access queries and/or Crystal Reports to SSRS reports.
• Able to take on development projects as business requires.
• All other duties as assigned.

Required Skills

• Strong understanding of SQL Server 2008 R2, 2012 and 2014.
• Strong background with T‑SQL queries, functions, triggers, views and stored procedures.
• Familiar with SSRS and SSIS deployment and management.
• Excellent analytical and problem solving skills.
• .NET and VB development.
• Experience with web development, specifically web‑based dashboard development, would be preferred.

Required Experience

2+ years of SQL, SSIS, SSRS development.

Level of Education

Post‑Secondary Education in IT or related field.

Benefits

• Health Care, Dental, Life insurance, Health Care Spending Account, Travel insurance, Long‑term Disability insurance, and more.
• Company match Retirement Savings Program.
• Employee Perks such as discounts on gym memberships, CAA memberships, car insurance, Costco memberships, hotels, theme parks, movie passes & more.
• Competitive compensation based on skill and ability.

We would like to thank all candidates who apply, but only those selected for an interview will be contacted.