Position SummaryThe 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 datamodels 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, andstored procedures against the ERP and in-house application databases.Develop and maintain Crystal Reports for operational and printed reporting andsupport the users who depend on them.Translate requests from management into defined reporting requirements, thedefinitions, and the level of detail required - and confirm those definitions beforebuilding.Apply consistent visual design to reports and dashboards so that the intendedaudience can read them immediately, including layout, visual hierarchy, andappropriate selection of charts and tables.Administer and maintain reporting infrastructure on Windows Server, includingscheduled jobs, permissions, service accounts, file shares, and report distribution.Contribute light front-end work to the in-house web applications alongside thedevelopment team, including HTML, CSS, and Bootstrap changes and the embeddingof reports and dashboards into application pages.Prepare presentation and communication materials for management and seniormanagement, including slide decks, one-page summaries, and status reporting onthe project.Use Git and GitHub for version control of report definitions, SQL, and related code,following the team's branching and review practices.Verify reported figures against source systems and investigate and resolvediscrepancies before they reach a decision-maker.Document data sources, report definitions, measures, and reporting processes, andkeep that documentation current.Provide training and support to report to consumers throughout the organization.Use AI-assisted tools with sound judgement, reviewing what is generated, selectingwhich problems to delegate, and remaining accountable for every query, measure,and figure delivered.Perform various analysis and reporting tasks as required.Must have post‐secondary education in business intelligence, computer science,information systems, statistics, or a related field,



or 3-5 years of industry experiencein a business intelligence or data analysis role.Must have demonstrated proficiency with Power BI, including data modelling, DAXmeasures, Power Query, report design, and the management of publishing andscheduled refreshes.Must have strong SQL skills, including joins, aggregation, window functions, views,and query performance tuning against relational databases.Experience developing and maintaining Crystal Reports is required.Working knowledge of Windows Server administration as it relates to reporting:scheduled tasks, permissions, service accounts, file shares, and report distribution.Working knowledge of HTML, CSS, and Bootstrap, sufficient to make small and safechanges to existing web application pages and to embed reports into them.Must be able to use Git and GitHub for version control, including branching, pullrequests, and code review.Must be able to use AI-assisted tools effectively and with judgement, includingreviewing what is generated, knowing which problems to hand over, and being ableto explain any query or measure delivered.Knowledge of Tayco's reporting environment is an asset: Power BI, Crystal Reports,SQL against the ERP and in-house PostgreSQL databases, Django-based internalapplications, Windows Server, and Git and GitHub.Experience with SQL Server Reporting Services or Power BI Report Server, datawarehouse or star schema design, advanced Excel data modelling, Python or R foranalysis, Azure data services, or manufacturing and ERP data - production,inventory, purchasing, and sales - is considered an asset.Ability to apply sound visual design judgement to reporting, including layout, visualhierarchy, and selection of charts appropriate to the audience.Ability to gather reporting requirements from management, including clarifyingdefinitions and confirming intent before building.Ability to present findings clearly to a non-technical audience, both in writing andverbally.Ability to question a figure that does not look correct, and to trace it back throughthe reporting to its source.Ability to work effectively within a small cross-functional team of developers and aproject coordinator, and to coordinate reporting work with software development inprogressAbility to read and interpret written and oral instructions.Must possess excellent analytical and problem-solving skills.Must have good communication skills and a positive and proactive attitude.Required to have good organizational skills, excellent attention to detail, and be ableto prioritize workload.Ability to understand business requirements and translate them into technicalapplications.Ability to compute rates, ratios,



and percentages.Ability to apply common sense understanding to carry out instructions furnished inwritten and oral form.Ability to deal with problems involving several variables, in complex situations.Must have the capacity to make departmental decisions/recommendations that will improve the operating efficiency of the department.COMPETENCIESAdaptabilityAdapts and responds to changing conditions, priorities, technologies and requirements. Ability to comfortably collaborate in a variety of situations and with diverse individuals.CommunicationExpresses and transmits information consistently and clearly, using active listening skills to understand feedback and summarize information.Critical ThinkingAnalyzes and interprets data and information in order to develop conclusions. Able to identify current and future opportunities, challenges and risks.Networking and Relationship BuildingEffectively builds constructive, friendly, professional relationships and networks with key contacts inside and outside the organization. Maintains partnerships that can provide information, assistance and support.Planning and OrganizationCan set out goals and objectives and work plans to accomplish tasks.Problem-Solving Possessesthe ability to break a situation down into smaller pieces to identify key issues, figuring out cause and effect relationships in order to solve. Uses logic and analytical methods to come to realistic solution.InitiativeAbility to assess and take advantage of opportunities independently.WORKING CONDITIONSThe working conditions described are representative of those an employee must meet to successfully perform the essential functions of this job. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.Ability to regularly access and move throughout the production floor and other work areas as required by the role.Ability to attend and conduct presentations.Manual dexterity required to use desktop computer and peripherals.Overtime as required.Salary Range : $60,000 to $65,000 AnnuallyFlexible work arrangements (work from the home 1 day per week after training)Active Social Committee with wonderful company cultureActive Inclusion, Diversity, Engagement, and Accessibility Committee with monthly initiatives to promote inclusivityOpportunities for growth and developmentGreat team to work with!Due to a high volume of applications, only those candidates who are selected for interviews will be contacted.Tayco endeavors to fill positions with the best available candidates who have the appropriate combination of education, experience, skills and abilities to successfully perform the duties of the position. Tayco is committed to equity and values diversity. We welcome applications from qualified individuals of all genders and sexual orientations, persons with disabilities, Aboriginal persons and persons of a visible minority.At Tayco, we are embracing innovative technologies, and Artificial Intelligence (AI) may be used to pre-screen applicants to enhance our recruitment process. AI-driven tools help us streamline candidate sourcing, improve the quality of our hiring decisions, and ensure a more effective and personalized experience for both candidates and hiring teams.

📌 Data Analyst (Bi Specialist) - Contract (Toronto)
🏢 BRC Group - Tayco and BRC
📍 Toronto