Data Analyst (BI Specialist) - Contract

Position Summary

The BI Specialist / Data Analyst is responsible for turning the data produced by Tayco's manufacturing and business systems into reporting that management and senior management can act on. This position designs, builds, and maintains Power BI reports and data models, writes and tunes the SQL beneath them, and maintains the Crystal Reports used for operational and printed reporting. Working alongside two full stack developers - one on the front end used by the shop floor, one on the back end and administrative side - and a project coordinator, this position complements in-house web and software development with the business intelligence layer that sits above it, and provides reporting, communication, and design support to the project as a whole. This position is based at Tayco's Etobicoke facility.

Posting notice: This posting is for 1 existing vacancy for a 12-month contract position.

Your Responsibilities:

• Design, build, and maintain Power BI reports, dashboards, datasets, and data
• models for management and senior management, including scheduled refreshes,
• gateway configuration, and workspace access.
• Write, review, and tune the SQL beneath all reporting, including queries, views, and
• stored procedures against the ERP and in-house application databases.
• Develop and maintain Crystal Reports for operational and pri