Business Intelligence Analyst

JOIN OUR TEAM
Metro Supply Chain is a strategic supply chain solutions partner to some of the world’s fastest growing and most reputable organizations. For 50 years, it has excelled at tailoring integrated, data-driven solutions, fueled by advanced systems and technology, that fulfill complex and challenging distribution needs. Managing 19 million square feet operating out of more than 175 sites across North America and Europe with a team of 9,000, it is one of Canada’s largest privately owned supply chain solutions companies. Metro Supply Chain is a 2024 winner of the Canada’s Best Managed Companies program, recognized for its strategic expertise, culture of innovation and commitment to its people and local communities.
SUMMARY
Embracing and driving change is critical to our success. As such we are relentlessly focused on innovating at every level of our business, investing in new technologies and products, and attracting the best talent to drive the company forward.
RESPONSIBILITIES
- Produce insightful business intelligence related to the Supply Chain Distribution Centres, Transportation teams, and Time Critical businesses globally. Support the development of key processes to design and manage Supply Chain performance management reporting leveraging data analysis while ensuring linkage to the strategic planning process.
- Manage data and data mining as well as translating financial data. Provide analytical support through data collection and analysis to support business decision making. Use expertise in project management, financial modeling, analytics and insights identification to support strategy
- Drive the effective utilization of business intelligence tools and other commercial tools designed to improve operational effectiveness to drive growth across the organization
- Work proactively with key business partners to identify opportunities and to drive transformational business growth initiatives, which deliver customer and shareholder value and meet targets as agreed with company senior leadership.
- Creative, agile, and innovative, able to manage in an environment of change and ambiguity.
- Build, launch and manage launching initiatives/strategies producing results for our organization and customer.

EXPERIENCE
- 2+ years of relevant and demonstrable experience in the business intelligence and analytics field.
- Strong understanding in SQL programming language, SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)
- Strong understanding of cloud-based platforms (Azure, Snowflake, others) and data science tools (R, Python, Apache Spark, others)
- Proficient in ETL (extract, transform, load)
- Expert knowledge of data visualization tools - must have Microsoft PowerBI
- Advanced Microsoft Office skills (Access, Excel, PowerPoint and Outlook). Experience working with queries, VBA and macros. Advanced Excel / Modelling skills with the ability to manipulate and analyze large volumes of data. They will be able to identify key business drivers and provide incisive commentary.
- Experienced in database design, data architecture, data mining, and analytics
- Advanced Excel / Modelling skills with the ability to manipulate and analyze large volumes of data.

**EDUCATION**:

- University/College degree in Data Science/Analytics, Engineering, or related field

**Who you are**:

- A high performing and motivated individual who is:

- Creative, agile, and innovative, able to manage in an environment of change and ambiguity to help shape our evolving strategy through building, launching and managing initiatives/strategies producing results for our organization and customer.
- Effective communication style with a demonstrated ability to work with teams.
- A natural leader, leading by example and not afraid of questioning the norm and changing behaviours.
- Strategic thinker with strong execution skills
- Problem solvers with the ability to analyze and prioritize to meet business objectives
- A strong business acumen and thrives on bringing data and numbers to life with excellent analytical and visualization skills
- Project management mastery
- Humble intelligence and confidence
- Great attitude and demonstrated ability to roll-up sleeves and work with team members in a hands-on capacity
- Ability to have fun, work hard and make a difference

Why Join Us
- Work in an environment where safety is our first priority
- The opportunity to build a career with a growing company
- Medical, dental, and vision coverage for you and your family
- Life and disability insurance
- Wellness programs to support your family’s well-being
- A Retirement Savings Program with a company match
- Company team wear allowance
- Employee Appreciation Day
- Company sponsored social events
- Community volunteering

Should you require accommodation for a special ability or need during the recruitment process, please reach out to a member of our Human Resources Team.