Data Analyst, BI Specialist

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

Job summary

Jobtailor is seeking a Business Intelligence Analyst to design, develop, and maintain Power BI solutions for our Toronto-area operations. You will transform management requests into concrete reporting needs, validate data against source systems, and deliver dashboards with strong visual design.

You will tune SQL queries, manage Crystal Reports, and administer Windows Server reporting infrastructure while collaborating with a small cross-functional team.

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 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, sufficient for small changes to existing web application pages and embedding reports.
• 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.

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 into web applications.
• Prepare presentation materials, summaries, and project status reports for management.
• Use Git and GitHub for version control and review practices.
• Verify reported figures against source systems and resolve discrepancies.
• Document data sources, report definitions, measures, and reporting processes.
• Provide training and support to report consumers.
• Use AI-assisted tools responsibly while reviewing and remaining accountable for delivered queries, measures, and figures.
• Perform analysis and reporting tasks as required.
• Work alongside full stack developers and a project coordinator to support the business intelligence layer of in-house applications.

Skills

Power BI proficiency

SQL optimization

Crystal Reports development

Data modeling

DAX measures

Data analysis

Communication

Problem-solving

Education

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

Tools

Windows Server

Git

GitHub

HTML

CSS

Bootstrap

Power Query

Job description

• 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 into web applications.
• Prepare presentation materials, summaries, and project status reports for management.
• Use Git and GitHub for version control and review practices.
• Verify reported figures against source systems and resolve discrepancies.
• Document data sources, report definitions, measures, and reporting processes.
• Provide training and support to report consumers.
• Use AI-assisted tools responsibly while reviewing and remaining accountable for delivered queries, measures, and figures.
• Perform analysis and reporting tasks as required.
• Work alongside full stack developers and a project coordinator to support the business intelligence layer of in-house applications.

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, sufficient for small changes to existing web application pages and embedding reports.
• 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.
• Ability to present findings clearly to non-technical audiences.
• Ability to investigate questionable figures and trace them to source systems.
• Ability to work effectively within a small cross‑functional team.
• Excellent analytical, problem‑solving, 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 handle complex situations involving several variables.
• Must have capacity to make departmental decisions/recommendations improving operating efficiency.
• Some travel may be required.
• Ability to attend and conduct presentations.
• Overtime as required.

Core Competencies

Demonstrates expertise in Power BI report design, SQL query optimization, and data modeling, while effectively translating business requirements into actionable reporting solutions. Proficient in Windows Server administration and capable of collaborating within cross‑functional teams to enhance business intelligence applications.

Highest-signal resume keywords

• Power BI Proficiency
• SQL Query Optimization
• Crystal Reports Development
• Windows Server Administration
• Git and GitHub Version Control

ATS Optimization Keywords

Hard Skills

• Power BI
• SQL
• Crystal Reports
• DAX Measures
• Data Modeling
• Power Query
• HTML
• CSS
• Bootstrap
• Data Analysis

Soft Skills

• Analytical Skills
• Problem‑Solving
• Communication
• Organizational Skills
• Attention to Detail

Industry Keywords

• Business Intelligence
• Data Analysis
• Reporting Infrastructure
• Data Visualization
• Cross‑Functional Team Collaboration

Tools & Technologies

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