BI Data Analyst: Power BI, SQL & Crystal Reports

BRC Group; Toronto; On-site; CAD 70,000 - 95,000; Full time

Job summary

Tayco in Etobicoke is seeking a BI Specialist / Data Analyst who will turn data from manufacturing and business systems into actionable reporting. You will design, build, and maintain Power BI reports and data models, write and tune SQL, and maintain Crystal Reports used for operational reporting.

Working with two full-stack developers and a project coordinator, you will ensure data accuracy, publish dashboards, administer Windows Server reporting tasks, and contribute light front-end work to

Qualifications

• Must have post-secondary education in business intelligence, computer science, information systems, statistics, or a related field, or 3-5 years of industry experience
• Must have demonstrated proficiency with Power BI, including data modelling, DAX measures, Power Query, report design, and the management of publishing and scheduled 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 safe changes to existing web application pages and to embed reports into them
• Must be able to use Git and GitHub for version control, including branching, pull requests, and code review
• Must be able to use AI-assisted tools effectively and with judgement, including reviewing what is generated, knowing when to delegate, and remaining accountable for every query, measure, and figure delivered

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 ERP and in-house databases
• Develop and maintain Crystal Reports for operational and printed reporting and support the users who depend on them
• Translate requests from management into defined reporting requirements, definitions, and the level of detail required - and confirm those definitions before building
• Apply consistent visual design to reports and dashboards so that the audience can read them immediately
• Administer and maintain reporting infrastructure on Windows Server, including scheduled jobs, permissions, service accounts, file shares, and report distribution
• Contribute light front-end work to the in-house web applications alongside the development team, including HTML, CSS, and Bootstrap changes and embedding reports into application pages
• Prepare presentation and communication materials for management and senior management, including slide decks and status reporting
• Use Git and GitHub for version control of report definitions, SQL, and related code, following branching and review practices
• Verify reported figures against source systems and investigate discrepancies before they reach decision-makers
• Document data sources, report definitions, measures, and reporting processes, and keep that documentation current
• Provide training and support to report consumers throughout the organization
• Use AI-assisted tools with sound judgement, reviewing what is generated and selecting problems to delegate

Skills

Power BI

SQL

Crystal Reports

Git/GitHub

HTML/CSS/Bootstrap

Windows Server

Data modelling

DAX measures

AI-assisted tools

Education

Post-secondary education in BI/CS/IS or 3-5 years experience

Tools

Power BI

SQL

Crystal Reports

Windows Server

HTML

CSS

Bootstrap

Git/GitHub

Job description

Tayco in Etobicoke is seeking a BI Specialist / Data Analyst who will turn data from manufacturing and business systems into actionable reporting. You will design, build, and maintain Power BI reports and data models, write and tune SQL, and maintain Crystal Reports used for operational reporting.

Working with two full-stack developers and a project coordinator, you will ensure data accuracy, publish dashboards, administer Windows Server reporting tasks, and contribute light front-end work to