17 Nov
|
Important Company of the Sector
|
Mississauga
17 Nov
Important Company of the Sector
Mississauga
Business Intelligence Analyst
ABOUT THE ROLE
Our company is looking for a resourceful, self-starting Business Intelligence Analyst who is passionate about data and proactively identifies opportunities to solve business challenges. You will own all ERP and business intelligence matters, working with stakeholders to understand business objectives, build valuable reporting, and provide ad hoc data extracts across the business. Your analysis will surface meaningful insights and help shape the direction of the organization.
KEY RESPONSIBILITIES
· Design, build, test, and deploy reports and business analytics for daily use by internal stakeholders.
· Develop and maintain high-level dashboards for senior management.
· Own sales reporting and analysis for key accounts, such as Walmart.
· Improve or automate existing inefficient reporting.
· Consolidate fragmented data to make it more accessible and usable for decision-makers.
· Perform data audits to ensure accuracy and integrity.
· Analyze business processes and data workflows, identifying improvements that align with organizational goals.
· Build a scalable BI setting that supports current and future business growth.
· Monitor and optimize ERP system performance, and assist with Sage 300 improvements and process automation.
· Provide analysis support, training, technical assistance, and knowledge sharing for all reports and dashboards.
· Complete other related tasks as assigned by the Director of Finance.
QUALIFICATIONS
Required
· Strong Excel skills, including formulas and functions (e.g., XLOOKUP, SUMIFS, FILTER, INDEX/MATCH, LET, IFERROR, SUMPRODUCT, dynamic arrays) and data-cleaning techniques.
· Advanced experience with PivotTables and PivotCharts for analyzing large datasets, including slicers, calculated fields, and dynamic reporting structures.
· Experience using Power Query to transform and automate data workflows.
· Experience automating recurring reports using Power Query, macros, and VBA, with a focus on reducing manual work.
· Experience or interest in improving reporting efficiency, including by leveraging AI tools.
· Working knowledge of SQL for data extraction and querying.
· Ability to analyze sales performance, gross margins, customer profitability, budgets, forecasts, and period-over-period variances.
· Ability to analyze large datasets, identify trends and variances, and reconcile data from multiple sources.
· Ability to validate data accuracy, identify missing or duplicate records, and build checks that ensure report reliability.
· Experience creating interactive Excel reports, KPI summaries, management reports, and dashboards using charts, slicers, conditional formatting, and data validation.
· Proficiency in Microsoft 365 applications, including Excel, Power Automate, and SharePoint.
· Experience reporting from retail vendor portals, such as Walmart Retail Link.
· Excellent communication and interpersonal skills,
with the ability to collaborate effectively with stakeholders.
· Strong listening skills and openness to feedback from users.
· Strong attention to detail and accuracy.
Preferred
· Experience in the CPG (Consumer Packaged Goods) industry, particularly in sales or commercial analytics.
· Hands-on experience building dashboards and user-friendly reports in Power BI, including DAX.
· Advanced SQL skills, including views, stored procedures, and triggers.
· Experience with large-scale data management, data warehousing, and relational databases.
· Knowledge of a data analysis programming language, such as Python or R.
· Experience with EDI platforms, such as SPS Commerce.
· Knowledge of Sage 300.
· Passion for data and creativity in report design that gets others excited about insights.
Candidates may be asked to complete a short Excel test (PivotTable and Power Query).
EDUCATION AND EXPERIENCE
· Post-secondary education in computer science, business intelligence, business administration, or a related field.
· Minimum of 4 years of experience in data analysis, business analysis, or sales or financial reporting.
· Minimum of 2 years of experience working with ERP systems (e.g., Sage, Oracle, Microsoft Dynamics, SAP). Knowledge of Sage 300 is a strong asset.
Hours
Monday to Friday, 8:00 AM to 4:00 PM
Workplace
Hybrid: 4 days in office, 1 day remote (after successful completion of the probationary period)
Pay: $68,000.00-$80,000.00 per year
Benefits:
- Casual dress
- Company events
- On-site parking
- Paid time off
- RRSP match
Work Location: In person
📌 Business Analyst (Mississauga)
🏢 Important Company of the Sector
📍 Mississauga