Business Applications Analyst

Affiliated Distributors, Inc.; Mississauga; On-site; CAD 65,000 - 90,000; Full time

Job summary

Affiliated Distributors, Inc. is seeking a Business Applications Analyst to join our Mississauga office. You will support LBMX‑based operations, maintain partner data, and build BI reports using Qlik to drive operational insight for the GSD, PHCP, and AD Canada teams.

The role requires fluency in SQL, relational databases, and BI tools with a customer‑centred approach. Hybrid work is available, with a schedule of three days in the office and two days remote.

Qualifications

• Proficient in relational databases and SQL for reporting.
• Experience with Qlik or similar BI tools for building reports.
• Strong communication skills and ability to translate technical concepts for non‑technical users.

Responsibilities

• Serve as a primary contact for LBMX‑related questions from internal users, distributors, and suppliers.
• Maintain partner data and cross‑reference information in LBMX and related systems.
• Configure and troubleshoot Solution Center for end users and ensure data accuracy.
• Validate EDI transactions from a business perspective and coordinate with technical teams when needed.
• Develop and distribute business reports using Qlik and other BI tools to support operations.

Skills

Relational databases

SQL

Communication skills

Analytical thinking

Problem solving

Education

Bachelor's degree in business or information systems

Tools

Qlik

Microsoft Excel

Microsoft Office

Job description

Description

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.

Requirements

1. Ability to understand the company's general business functions and have a conceptual understanding of each division’s/department’s activities.
2. Working knowledge of relational databases and SQL, sufficient to write queries and connect to data sources for reporting.
3. Experience with Qlik or a similar BI/reporting tool, including building and maintaining business reports.
4. Solid understanding of EDI transaction types and the business flows they support (e.g., procure to pay), and the ability to validate transactions from a business perspective; EDI mapping or development expertise is not required.
5. Comfort working directly with business users and external customers/partners in a support or consultative capacity.
6. Excellent listening, verbal, and written communication skills. Ability to convey technical concepts in a way that is easy for non‑technical people to understand.
7. Strong learning, problem‑solving, and analytical skills.
8. Consistently demonstrates a high level of integrity and professionalism.
9. Ability to manage multiple priorities and meet deadlines.
10. Intermediate‑level Microsoft Office capabilities.

Nice to Have:

1. Direct experience with the LBMX platform, including Solution Center configuration and support.
2. Exposure to the PHCP, HVAC, or general distribution/industrial supply sector, including experience with an ERP system in a distribution, wholesale, or buying‑group environment.
3. Comfort using enterprise AI tools to support report‑building, data analysis, and process discovery. AD provides these tools as a value‑add, but they complement, rather than substitute for, the business, LBMX, and EDI experience described above.

Qualifications:

1. Bachelor’s degree in business, information systems, or a related field. Relevant work experience may substitute for formal education.
2. 2-4 years of experience in a business analyst, business operations, application support, or customer support/success role involving data reporting.

Additional Comments:

1. Travel: Minimal; 1 to 3 times per year.
2. Hours: 8:00a - 5:00p M-F; hybrid schedule, 3 days in the office, 2 days remote.

AD is proud to be an equal employment opportunity employer.?Qualified candidates are considered for employment without regard to race, religion, gender, gender identity, sexual orientation, national origin, age, military or veteran status, disability, or any other characteristic protected by applicable law. At AD, we support a collaborative and inclusive environment. We value open participation from individuals with different ideas, experiences, and perspectives which we believe make AD a better place to work.