Business Intelligence Analyst

GLENTEL Inc.; Burnaby; Hybrid; CAD 65,000 - 70,000; Full time

Job summary

GLENTEL Inc., a leading organization recognized as one of Canada's Best Places to Work, is seeking a Business Intelligence Analyst. This critical role involves analyzing retail transaction data, building reports, and collaborating with teams to enhance data-driven decision-making. The successful candidate will have a strong background in SQL and experience with Power BI, contributing to data normalization and performance metric assessment in a dynamic work environment.

Benefits

Annual incentive plan

Award-winning culture

Work model flexibility

Qualifications

• 2-3 years experience conducting analysis of large amounts of data.
• 3-4 years experience in modeling and report/dashboard design.
• High proficiency in SQL and Excel.

Responsibilities

• Support building and maintaining company-wide reports and dashboards using BI tools.
• Assist with updating and migrating daily Sales POS transaction reports to PowerBI.
• Perform exploratory data analysis to identify patterns in complex data sets.

Skills

SQL

Microsoft Excel

Data analysis

Data modeling

Reporting

Education

Bachelor's degree in Business or Analytics related fields

Tools

Power BI

Fabric

Job description

Glentel Inc., a billion-dollar+ organization, supported by Bell and Rogers. Glentel partners with globally recognized brands like Costco, Apple, Samsung, and Google. Known for its brands WIRELESSWAVE, tbooth wireless, Costco's WIRELESS etc. & The Mobile Shop; Glentel delivers unparalleled performance in the retail industry. Proudly recognized as the 2022 and 2024 Best Place to Work by HR Director Magazine, Glentel offers a dynamic environment where you can grow your career with an award-winning organization.

Business Intelligence, (BI), Analyst plays a critical role in providing retail transactional analysis on sales, inventory management and efficiency metrics. The BI Analyst works closely with the senior leadership team to synthesize large volumes of data using a variety of programming tools.

Why work for us?

• Base Pay: $65,000 - $70,000 with annual incentive plan
• Work Model: Hybrid (in-office and remote flexibility)
• Award-Winning Culture: We pride ourselves on being recognized multiple times as one of the Best Places to Work in Canada
• Backed by Industry Giants: Glentel is supported by Bell and Rogers and partners with globally recognized brands like Costco, Apple, Samsung, and Google.

Responsibilities:

• Support building and maintaining company-wide reports, dashboards and scorecards using BI tools such as Microsoft Power BI and SQL that enable teams to make evidence-based decision-making and show company performance
• Assist with updating and migrating daily Sales POS transaction reports to PowerBI.
• Support business units working directly with all levels including senior staff to advise and provide solutions relating to data reporting and intelligence.
• Collaborate with teams to provide recommendations and options on establishing measures. With focus on both efficiency (automation), accuracy and efficacy.
• Provide ad-hoc data needs using SQL and ability to extract data from RQ for ad-hoc analysis and data requirements.
• Perform exploratory data analysis and data modelling to identify patterns and trends in complex data sets and simulate changes in performance metrics to assess ROIs for projects and financial impacts
• Effectively communicate with stakeholders providing them with regular updates on programs and new solutions.
• Data normalization, ETL and building data structures.
• All other duties as assigned.

Qualifications:

• Bachelor's degree in Business or other Analytics related fields and/or a combination of education and experience.
• 2-3 years experience conducting analysis of large amount of data.
• 3-4 years working modeling, report/dashboard design in powerBI or equivalent.
• Fabric experience a benefit.
• High proficiency in SQL, Microsoft Excel.
• Strong grasp of relational database design.