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
The IT Developer is responsible for developing reports to provide easy access data to Operations and Finance leaders in order to assist in the analysis of the business.
Reporting Relationships:
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 requirement 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
Noranco offers a very safe, modern and forward thinking environment and a highly competitive compensation package including:
- Full-time, permanent employment
- An excellent Benefits package (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
- Compensation is competitive and based on skill and ability
We would like to thank all candidates who apply, but only those selected for an interview will be contacted.
