Business Intelligence Analyst

Compensation Base salary: $70,000 – $90,000 Reason for Opening Existing Vacancy – Yes Job Summary The Business Intelligence Analyst reports to the Financial Planning and Analysis Manager and supports data analysis and reporting initiatives by aggregating data from multiple sources and developing insights to support business decision-making. This role focuses on building and maintaining reports, dashboards, and data solutions to enhance visibility into operational performance, sales, profitability, and customer behaviour. Duties & Responsibilities Support reporting and analytics initiatives in collaboration with FP&A and cross-functional teams Assist in identifying and documenting existing reporting processes and contribute to standardization and simplification efforts Develop an understanding of the business to support the definition and tracking of key performance indicators (KPIs) Build, maintain, and enhance reports and dashboards using tools such as Power BI, IBM Cognos Analytics, and SAP Support the automation of recurring reporting processes where possible Assist in the development and maintenance of data marts and ETL processes Monitor data quality and escalate issues to ensure accuracy and consistency Maintain databases and reporting environments Gather and translate business requirements into reporting and analytical solutions Collaborate with stakeholders to deliver insights that support business decisions Provide user support and training on reporting tools as needed Respond to ad hoc reporting and analysis requests Perform other related duties as assigned Qualifications & Educational Requirements Post-secondary degree in Computer Science, Analytics, or a related field 3–5 years of experience in a Business Intelligence, Data Analyst, or similar role Experience in CPG or manufacturing environments considered an asset Experience with Power BI, including DAX Experience developing reports and dashboards Proficiency in Microsoft Office tools Technical Expertise: Working knowledge of: Relational database design and data warehouse concepts SQL, including writing and modifying queries SSIS and SSAS fundamentals Exposure to data modeling and ETL processes Understanding of database structures and performance considerations Business & Analytical Skills: Strong analytical and problem-solving skills Effective communication skills with the ability to work with both technical and non-technical stakeholders Experience gathering and documenting business requirements Preferred: Experience with SAP Experience with Dynamics 365 CRM Experience with Microsoft Azure Understanding of financial principles and metrics Experience working with financial data, forecasting tools, or reporting Total Rewards Core Total Rewards Fully funded Group Benefits (medical, dental, vision, life insurance, dependent life, AD&D, short term disability, & long-term disability) Group RRSP with 100% Employer Match up to 4% Freedom to Choose, Consult +, and Telus Pharmacy Group Employee Assistance Program Workplace Wellness Program Support of professional memberships/certifications Additional Rewards Educational Reimbursement Program Employee Charitable Donation Program (monetary and product donations) Employee Service & Recognition Awards Referral Bonus Program Summer Fridays Employee Engagement Committee initiatives Smart casual dress atmosphere A unique opportunity to be a key player in a growing global organization An innovative fast-paced culture focused on people