Business Applications Analyst

Position Summary:

We are looking for a Business Applications Analyst to join our corporate IT team, based out of our Mississauga, Ontario office, supporting the technical operations of the GSD (Gypsum Supply Division) and PHCP (Plumbing, Heating, Cooling, Piping) divisions in the United States, as well as the AD Canada Operations team. This role acts as a subject-matter resource for the operational tools that connect AD's internal teams, distributor members, and supplier partners, with particular focus on the LBMX platform, Solution Center, and EDI-related business processes. The role also carries meaningful technical responsibility for business reporting, including connecting to relational databases, writing SQL queries, and building reports in Qlik.

This is a business operations role that requires genuine technical fluency, particularly working knowledge of relational databases, SQL, and BI/reporting tools such as Qlik, along with a solid understanding of EDI transaction types and the business flows they support, such as procure to pay. EDI mapping and software development are not required. This individual will be an important point of contact for our distributor members and suppliers, helping ensure a high level of satisfaction with AD's systems, processes, and information, especially when immediate assistance is needed to resolve a business or reporting issue.

This role works closely with the GSD, PHCP, and AD Canada Operations teams. Collaboration with GSD and PHCP is primarily centered on the LBMX platform and its associated business processes, while collaboration with AD Canada Operations is centered on providing data access to support reporting and process automation.

Primary Responsibilities:

1. Serve as a day-to-day point of contact for internal users, member distributors, and suppliers on LBMX-related questions and issues.
2. Maintain trading partner information, customer locations, and cross-reference data within LBMX and related systems.
3. Support and troubleshoot Solution Center configuration and functionality for end users.
4. Validate EDI transactions and understand the underlying transaction types and business flows they support (e.g., procure to pay), coordinating with LBMX or internal technical teams when mapping changes are required.
5. Connect to relational databases and write SQL queries to extract, validate, and analyze operational and transactional data.
6. Build, maintain, and distribute business reports using Qlik and other BI/reporting tools to support PHCP and GSD operational and member-facing needs.
7. Investigate and resolve business-process issues raised by members, suppliers, or internal stakeholders, evaluating alternatives and determining appropriate solutions with staff and users.
8. Develop and maintain documentation related to LBMX, Solution Center, and reporting workflows, including user guides and process specifications.
9. Stay up-to-date on industry trends and best practices related to LBMX, EDI business processes, and reporting tools.
10. Identify opportunities for process and reporting improvement, working with vendors and members to enhance business workflows.
11. Other duties as assigned.