Business Applications Analyst

Affiliated Distributors (AD); United States; Hybrid; USD 70,000 - 110,000; Full time

Benefits offered by this job

Hybrid schedule

Job summary

Affiliated Distributors (AD) is seeking a Business Applications Analyst to join our corporate IT team, based in Mississauga and supporting the US divisions, the LBMX platform, Solution Center, and EDI-related business processes. This role emphasizes technical fluency with relational databases, SQL, and BI/reporting tools.

You will connect to relational databases, write SQL queries, and build reports in Qlik to support GSD/PHCP operations and member-facing needs.

Qualifications

• Working knowledge of relational databases and SQL.
• Experience with Qlik or similar BI/reporting tools.
• Understanding of EDI transaction types and related business flows; mapping or development not required.

Responsibilities

• Serve as day-to-day point of contact for internal users, distributors, and suppliers on LBMX questions.
• Maintain trading partner information and cross-reference data within LBMX and related systems.
• Support Solution Center configuration and functionality for end users.
• Validate EDI transactions and understand the underlying types and flows.

Skills

Relational databases

SQL

Qlik

BI reporting

Communication

Education

Bachelor’s degree

Tools

LBMX platform

Solution Center

EDI systems

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.

Equal employment opportunity, including veterans and individuals with disabilities.