Junior Business Intelligence Analyst

Salary: $60,000 - 70,000 per year

Requirements:

• Diploma or degree in Business Analytics, Data Science, Computer Science, Information Systems, Business, Finance, Supply Chain Management, or a related field.
• At least 2 years of relevant business analysis experience, including professional work, co-op placements, internships, or substantial project work.
• Working knowledge of SQL and full-stack development concepts, including front-end, back-end, and database technologies.
• Experience with a business intelligence, reporting, or data visualization platform; Infor Birst experience is an asset.
• Strong Excel skills and confidence working with data, validating information, and solving problems.
• Organized and methodical, with the flexibility to adapt when priorities change.
• Ability to explain technical information clearly to people without a data-focused background.
• Additional assets include experience with PostgreSQL, ETL, data warehousing, data modeling, Kimball methodology, OLAP, ERP systems, predictive modeling, accounting, finance, inventory, procurement, or operations.
• Bilingual English and French is preferred.

Responsibilities:

• Investigate business questions and translate them into clear reporting and data requirements.
• Build and maintain reports, dashboards, and analytical solutions using Infor Birst and other BI tools.
• Use SQL and database skills to investigate data, solve problems, and support our reporting environment.
• Apply front-end, back-end, and database knowledge to support data-driven applications, integrations, and reporting tools.
• Analyze business performance, trends, and KPIs to help explain what the data shows.
• Investigate data discrepancies, identify root causes, and help ensure information is accurate.
• Support data models, data warehouse structures, and the ongoing development of our Business Intelligence environment.
• Help colleagues resolve reporting and data questions and make our BI tools easier to understand and use.
• Maintain organized reporting requirements, methodologies, and documentation.
• Contribute ideas to cross-functional projects and help us improve how we use data.

Technologies:

• Business Intelligence
• Data Warehouse
• ETL
• ERP
• Excel
• Support
• PostgreSQL
• SQL

More:

Were hiring a Junior Business Analyst to join our Business Intelligence and IT teams at our Corporate Head Office in the Campbell Heights/South Surrey area. This early-career opportunity offers a chance to develop technical skills, learn how data supports our business, and contribute to practical solutions alongside colleagues across the organization. We offer a collaborative, fast-paced workplace where people work independently, share ideas, and support one another. Compensation is $60,000–$70,000 per year, with placement in the range based on skills and experience, as well as annual performance bonus opportunities. Benefits include medical, dental, vision, life and disability coverage, an employee assistance program, an RRSP match of up to 5%, paid time off and vacation progression, wellness programs, on-site parking, birthday and long-service awards, and company events. Corporate employees may work from home one day per week as operations permit; this discretionary arrangement may change based on business needs. Were committed to diversity and inclusion and can provide accommodations during the application process.

last updated 45 week of 2026