Overview
NOTE: HYBRID work model, 2-days on-site in Montreal/week
Type: Full-time
Salary/Benefits: $80-95K, 10% annual bonus, RRSP, 3 weeks vacation, health benefits
SKILLS: 3-5+ years BI, SQL Queries, SSRS, Power BI, Dashboards, English, French, DAX, Python, Azure, Snowflake, Copilot, ChatGPT
Description:
We are seeking a proactive, customer‑focused Business Intelligence Analyst to deliver accurate, timely, and actionable reporting across the organization. This role plays a key part in supporting reporting operations, partnering with stakeholders, and modernizing analytics through Power BI, automation, and AI‑enabled insights.
- Manage the BI report portal inbox with proactive communication and clear expectation‑setting
- Deliver daily, weekly, monthly, and quarterly recurring reports with accuracy and consistency
- Prioritize and fulfill ad‑hoc data and reporting requests
- Maintain and enhance SSRS reports and support migration to Power BI dashboards
- Maintain distribution lists and scheduled delivery configurations
- Ensure timely handling of urgent requests, exceptions, and compliance‑driven reporting
- Partner with business stakeholders to gather, document, and clarify reporting requirements
- Translate business needs into reporting and dashboard solutions aligned with best practices
- Provide guidance on data definitions, metrics, and reporting processes in clear, business‑friendly terms
- Act as a trusted advisor by delivering high‑quality customer service and building strong working relationships
- Validate, troubleshoot, and ensure accuracy of data used in reports and dashboards
- Analyze trends, variances, and key drivers to support deeper business insights
- Perform root‑cause analysis to identify and resolve data issues
- Contribute to improvements in data quality, standards, and governance practices
- Leverage AI tools for summarization, insight extraction, and enhanced reporting workflows
- Support process automation using Python, Databricks, or cloud‑based workflows
- Help expand self‑service analytics capabilities and promote data literacy
- Identify opportunities to streamline and modernize reporting through automation and AI
Requirements:
- 3–5+ years of experience in Business Intelligence, Reporting, or Data Analytics
- Strong SQL skills with hands‑on experience using SSRS and Power BI
- Experience working with recurring and ad‑hoc reporting in a customer‑facing environment
- Ability to balance operational reporting responsibilities with project‑based work
- Strong communication skills with the ability to explain complex data concepts to non‑technical audiences
- Collaborative mindset with a continuous‑improvement and modernization focus
- Degree or equivalent and typically requires 4+ years of relevant experience.
- Experience migrating SSRS reports to Power BI Service
- Exposure to Databricks or similar cloud data platforms
- Experience with Python and/or R for analytics or automation
- Familiarity with ETL concepts, data warehousing, and cloud analytics architectures
- Experience with Power Apps and Power Automate for workflow enablement or light applications
- Background in data governance, metadata management, or data quality initiatives
- Familiarity with AI/ML concepts or AI‑assisted analytics workflows
NOTE: As part of our hiring process, we use AI‑based systems to support initial applicant screening.
