Data Analyst – BI Specialist, Contract

Jobtailor; Toronto; On-site; CAD 70,000 - 110,000; Full time

Job summary

Jobtailor in Toronto is hiring a Business Intelligence/Reporting Specialist to design and maintain Power BI reports and data models. You will write SQL queries against ERP databases, develop Crystal Reports, and embed dashboards in web pages using HTML/CSS/Bootstrap.

The role requires strong SQL and Power BI skills, Windows Server administration, and experience with Git/GitHub. You will collaborate with cross-functional teams and present findings to non-technical stakeholders.

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 in a BI or data analysis role
• Must have demonstrated proficiency with Power BI, including data modelling, DAX measures, Power Query, report design, and publishing/scheduled refreshes
• Must have strong SQL skills, including joins, aggregation, window functions, views, and performance tuning
• Experience developing and maintaining Crystal Reports is required
• Working knowledge of Windows Server administration for reporting (scheduled tasks, permissions, file shares, etc.)
• Working knowledge of HTML, CSS, and Bootstrap for small web changes and report embedding
• Must use Git/GitHub for version control (branching, PRs, code review)
• Must be able to use AI-assisted tools effectively and with judgement
• Ability to translate business requirements into technical solutions and present findings clearly
• Ability to investigate discrepancies and verify figures against source systems

Responsibilities

• Design, build, and maintain Power BI reports, dashboards, datasets, and data models
• Write, review, and tune SQL queries against ERP and in-house databases
• Develop and maintain Crystal Reports and support report users
• Translate management requests into reporting requirements and confirm definitions
• Apply consistent visual design to reports and dashboards
• Administer reporting infrastructure on Windows Server (scheduled jobs, permissions, file shares)
• Embed reports into application pages with HTML/CSS/Bootstrap
• Prepare status reports and presentations for management
• Use Git and GitHub for version control of definitions and code
• Verify reported figures against source systems and investigate discrepancies
• Document data sources, report definitions, measures, and processes
• Provide training and support to report consumers
• Use AI-assisted tools responsibly and with judgement
• Perform analysis and reporting tasks in cross-functional team
• Collaborate with Tayco's Etobicoke facility team

Skills

Power BI

SQL

Crystal Reports

HTML/CSS/Bootstrap

Git/GitHub

AI-assisted tools

Data visualization

Communication

Problem-solving

Education

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

Tools

Windows Server

AI-Assisted Tools

Git

GitHub

Job description

Responsibilities

• Design, build, and maintain Power BI reports, dashboards, datasets, and data models
• Write, review, and tune SQL queries, views, and stored procedures against ERP and in-house application databases
• Develop and maintain Crystal Reports and support report users
• Translate management requests into defined reporting requirements and confirm definitions before building
• Apply consistent visual design to reports and dashboards
• Administer reporting infrastructure on Windows Server, including scheduled jobs, permissions, service accounts, file shares, and report distribution
• Contribute light HTML, CSS, and Bootstrap front-end work and embed reports and dashboards into application pages
• Prepare presentation materials, one-page summaries, and project status reports for management and senior management
• Use Git and GitHub for version control of report definitions, SQL, and related code
• Verify reported figures against source systems and investigate discrepancies
• Document data sources, report definitions, measures, and reporting processes
• Provide training and support to report consumers throughout the organization
• Use AI-assisted tools responsibly and remain accountable for delivered queries, measures, and figures
• Perform analysis and reporting tasks as required
• Work alongside full stack developers and a project coordinator at Tayco's Etobicoke facility

Requirements

• Must have post-secondary education in business intelligence, computer science, information systems, statistics, or a related field, or 3-5 years of industry experience in a business intelligence or data analysis role
• Must have demonstrated proficiency with Power BI, including data modelling, DAX measures, Power Query, report design, and 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 for reporting, including scheduled tasks, permissions, service accounts, file shares, and report distribution
• Working knowledge of HTML, CSS, and Bootstrap for small changes to existing web application pages and report embedding
• 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
• Ability to apply sound visual design judgement to reporting
• Ability to gather reporting requirements from management and confirm intent before building
• Ability to present findings clearly to non-technical audiences
• Ability to investigate questionable figures and trace them to source systemsAbility to work effectively within a small cross‑functional team
• Excellent analytical and problem‑solving skills
• Good communication, organizational, prioritization, and attention‑to‑detail skills
• Ability to understand business requirements and translate them into technical applications
• Ability to compute rates, ratios, and percentages
• Ability to deal with complex situations involving several variables
• Must have capacity to make departmental decisions/recommendations improving operating efficiency

Core Competencies

Proficient in Power BI report design, data modeling, and SQL query optimization, with a strong ability to translate business requirements into technical solutions. Experienced in Windows Server administration and capable of delivering clear presentations to non-technical stakeholders.

Tools & Technologies

• Windows Server
• AI-Assisted Tools
• Git
• GitHub