Business Intelligence Lead

Business Intelligence LeadJoin Our Team at Convoy – Where Your Career Builds as Strong as Our Materials!Founded in 1972, Convoy is North America’s trusted distributor of top-tier construction materials. With over 40 locations in US and Canada, we’ve grown into a leader in the industry, but we never forget the core values that got us here: exceptional products, outstanding customer service, and a genuine commitment to helping our customers thrive.At Convoy, we don’t just offer jobs – we offer career-building opportunities. Here, you’ll be part of a dynamic, supportive, and fun environment where your voice matters, your growth is a priority, and success is something we all share.We’re looking for passionate individuals who want to make an impact, bring fresh ideas, and be part of a team that values integrity, hard work, and collaboration. Whether you’re just starting your career or looking for your next challenge, Convoy is the place to build something meaningful – for yourself, for our customers, and for your future.Why Convoy Supply?Growth Opportunities: We believe in developing our people and offering them the chance to advance.Teamwork at Its Best: Success isn’t just about individual effort – it’s about what we achieve together.Commitment to Safety: Your well-being is a top priority, every day.Comprehensive & Competitive Benefits: Robust benefits package designed to support you and your family’s health and well-being, and peace of mind, which also include:Employee Assistance Programs and Telemedicine ServicesRetirement saving plansEmployee referral bonusesPaid training and developmentPaid time off (vacation, sick time and company-paid holidays)Short- and Long-term disability coverage SummaryThe Business Intelligence (BI) Lead will be responsible for owning and driving the BI strategy across Convoy, ensuring data-driven decision-making supports operational excellence and business growth. This role combines strategic leadership with hands-on expertise in data visualization, reporting, and infrastructure. Partnering closely with General Managers, the Transformation team, and functional leaders across sales, operations, procurement, and finance, the BI Lead will design and deliver analytics solutions that improve sales performance, optimize supply chain efficiency, and reduce costs. The incumbent will oversee the development and governance of data pipelines, integration from ERP and Salesforce systems, and the creation of real-time Tableau dashboards, ensuring accuracy, scalability, and compliance with Canadian and U.S. data regulations. Acting as both a strategic advisor and technical expert, the BI Lead will champion data literacy, train leaders on BI tools, and foster cross-company collaboration to align BI initiatives with business goals. This role requires a balance of technical proficiency, strong communication, and the ability to lead independently in a fast-paced, distribution-focused environment.ResponsibilitiesLeadership & StrategyChampion and take full ownership of Business Intelligence initiatives, providing strategic leadership and directionDevelop analytics solutions tailored to distribution operations with key internal stakeholders.Collaborate with General Managers and Transformation team to define KPIs and reporting frameworks for sales, logistics, and inventory.Align BI strategy with operational and business goals.Data Visualization & ReportingDevelop and maintain Tableau dashboards for real-time monitoring of sales, supply chain metrics, and warehouse performance.Ensure data accuracy and consistency across all reporting layers.Provide actionable insights to improve sales optimization, operational efficiency and reduce costs.Operational CollaborationWork in close partnership with BI counterparts across group companies to ensure alignment and knowledge sharingPartner with sales, operations, procurement & purchasing, and finance teams to understand data needs.Support demand forecasting and capacity planning through data analysis.Train leadership and key functional staff on using Tableau dashboards effectively.Data Infrastructure & GovernanceOversee data integration from ERP, SalesForce, and other systems.Ensure compliance with Canadian and US data privacy and industry-specific regulations.Optimize ETL processes and data models for performance and scalability.Proficiency in SQL Server technologies (TSQL, SSIS, SSAS, SSRS, Data Mining)RequirementsBachelor’s degree in Data Analytics, Business Intelligence, Engineering, Information Systems, or related field.5+ years of BI experience, with preferably 2 years in manufacturing or distribution environments.Advanced Tableau/Power BI skills.Strong SQL and data modeling experience.Familiarity with ERP systems and SalesForce.Knowledge of Lean Manufacturing, Six Sigma, or supply chain optimization.Experience with Python or R for advanced analytics.Strong analytical and problem-solving mindset.Excellent communication and stakeholder management skills.Ability to lead cross-functional projects in a fast-paced environment.Exercise full autonomy in managing the BI function, including independently prioritizing tasks, setting schedules, and driving initiatives to completion