Applications Development Lead

Dental Insurance ✓ Disability Insurance ✓ Health Insurance ✓ Life Insurance ✓ Weekdays ✓ 8hr ✓ Days
Business Intelligence Lead
Join 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. 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.
Employee Assistance Programs and Telemedicine Services
Retirement saving plans
Employee referral bonuses
Paid training and development
Paid time off (vacation, sick time and company-paid holidays)
Short- and Long-term disability coverage
Join us and help shape the future of construction, one delivery at a time.
The 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.
Champion and take full ownership of Business Intelligence initiatives, providing strategic leadership and direction
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 & Reporting
Develop 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.
Work in close partnership with BI counterparts across group companies to ensure alignment and knowledge sharing
Partner 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 & Governance
Oversee 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)
Bachelor'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.
~ Experience with Python or R for advanced analytics.
~ 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