Senior Analyst - Business Intelligence

Wesco; Pittsburgh (Allegheny County); On-site; USD 82,000 - 110,000; Full time

Job summary

Wesco in Pittsburgh, PA seeks a Senior Analyst - Business Intelligence to drive end-to-end reporting and analytics solutions. You will bridge business needs with BI development, lead BRDs, define KPIs, validate data quality, and guide UAT to ensure solutions meet objectives.

You will own reporting lifecycle from intake to deployment, build mockups, and collaborate with Enterprise Applications, Data Engineers, and BI Developers to deliver measurable business value.

Qualifications

• Collect and analyze data pertaining to the SBU, including national and local market size, customer behavior, competitive advantages, and overall SBU business performance.
• Execute regular and ad-hoc reports, dashboards, scorecards, and presentations to support business leaders and key stakeholders.
• Build detailed presentations including data analysis reports, visualizations, charts, graphs, industry evaluations, and performance metrics using Power BI and other reporting tools.
• Lead discovery sessions and requirements gathering workshops with business stakeholders to develop comprehensive BRDs.
• Develop a deep understanding of the business processes supported by reports and dashboards and ensure reporting solutions align with business objectives.

Responsibilities

• Own the reporting lifecycle from business intake through production deployment.
• Create initial report and dashboard mockups, wireframes, and visual representations for stakeholder alignment.
• Identify, document, and validate Data Integrity and Data Quality rules during requirements and development.
• Review reporting workfiles and dashboards before UAT to validate data and logic.
• Coordinate and facilitate User Acceptance Testing activities with business stakeholders.

Skills

Data analytics

Executive reporting

KPI development

Requirements gathering

Data quality

Stakeholder collaboration

Education

Bachelor's degree

Master's degree preferred

Tools

Power BI

Power Apps

Power Automate

Excel

Access

Job description

As the Senior Analyst - Business Intelligence (Business Analyst), you will be responsible for driving the end-to-end delivery of reporting and analytics solutions that support strategic and operational business objectives. You will serve as the primary liaison between business stakeholders, Enterprise Applications teams, and BI development teams to ensure reporting solutions are effectively designed, developed, tested, and deployed. In addition to providing regular and ad-hoc reporting and analytical support, you will lead business requirements gathering, process analysis, dashboard strategy, KPI development, data quality validation, and user acceptance testing activities. You will own the reporting lifecycle from business intake through production deployment while ensuring solutions meet business expectations, adhere to enterprise standards, and deliver measurable business value.

Responsibilities

• Collect and analyze data pertaining to the SBU, including national and local market size, customer behavior, competitive advantages, and overall SBU business performance.
• Execute regular and ad-hoc reports, dashboards, scorecards, and presentations to support business leaders and key stakeholders.
• Build detailed presentations including data analysis reports, visualizations, charts, graphs, industry evaluations, and performance metrics using Power BI and other reporting tools.
• Lead discovery sessions and requirements gathering workshops with business stakeholders to develop comprehensive Business Requirement Documents (BRDs).
• Develop a deep understanding of the business processes supported by reports and dashboards and ensure reporting solutions align with business objectives.
• Create, document, maintain, and continuously enhance BRDs, functional specifications, process flows, user stories, business rules, KPI definitions, and reporting requirements.
• Serve as the primary liaison between business stakeholders, Enterprise Applications teams, Data Engineers, and BI Developers throughout the reporting lifecycle.
• Own the end-to-end delivery of reporting and analytics solutions from business intake through deployment and adoption.
• Create initial report and dashboard mockups, wireframes, and visual representations to facilitate stakeholder alignment and solution design.
• Identify, document, and validate Data Integrity (DI) and Data Quality (DQ) rules during requirements gathering, solution design, and report development activities.
• Identify source systems, data dependencies, and end-to-end data flows required to support reporting and analytics solutions.
• Review reporting workfiles and dashboards before User Acceptance Testing (UAT) to validate user experience, dataset completeness, business logic, calculations, and reporting accuracy.
• Conduct detailed reviews with development teams to ensure all BRD requirements have been satisfied prior to Quality Assurance and User Acceptance Testing.
• Develop UAT strategies, test plans, test scenarios, and detailed UAT scripts in collaboration with business stakeholders during the BRD creation process.
• Coordinate and facilitate User Acceptance Testing activities, manage testing results, track defects, and obtain business sign-off before deployment.
• Identify key performance indicators (KPIs), business metrics, and measurement methodologies that improve visibility, accountability, and operational decision-making.
• Promote and champion adoption of new reports, dashboards, KPIs, and analytics capabilities across the organization.
• Conduct research and data mining to identify emerging market opportunities, reporting enhancements, and business intelligence solutions that drive business value.
• Proactively analyze existing reports and dashboards to identify opportunities for optimization, standardization, automation, consolidation, and continuous improvement.
• Identify reporting synergies across current and future initiatives and recommend solutions that maximize business value while reducing duplication.

Qualifications

• Bachelors Degree required; Masters Degree preferred
• 5+ years of data analytics experience
• 3+ years of creating executive level reports
• 3+ years of establishing KPI’s and building processes to manage them
• 3+ years of implementing process improvements and change management
• 3+ years of experience in a large complex company with multiple ERP’s
• Strong working knowledge of Microsoft Office products including Excel and Access
• Intermediate working knowledge of Power BI, Power Apps. Power Automate
• Advanced knowledge in creating executive level dashboards, reports, including graphs and charts
• Strong detail orientation and ability to work in a fast-paced environment
• Ability to multi-task and manage multiple concurrent projects and deliverables
• Ability to analyze and interpret complex data
• Strong process and data mapping skills preferred
• Experience with data validation on large datasets preferred
• Experience in supply chain, distribution and/or logistics functions strongly preferred
• Ability to travel 0% - 25%

Compensation Details

$81,753 - $110,366 Annually This amount is what we reasonably believe we will pay for the position; however, offer amounts may vary based on factors such as geographic location, relevant education, experience, qualifications, skills, shift, or any collective bargaining agreements. For eligible positions, compensation may include participation in a bonus or sales incentive plan,subject to the terms and conditions of the applicable plan documents. For certain sales roles, Wesco also offers a commission structure that provides additional compensation based on sales results, as defined by the applicable commission plan. In addition, Wesco offers a benefits program for eligible employees, which may include paid time off, medical, dental, and vision coverage, and retirement savings plans. Additional details about benefits are available here.

About The Team

At Wesco, we build, connect, power and protect the world. As a leading provider of business-to-business distribution, logistics services and supply chain solutions, we create a world that you can depend on. Our Company’s greatest asset is our people. Wesco is committed to fostering a workplace where every individual is respected, valued, and empowered to succeed. We promote a culture that is grounded in teamwork and respect. With a workforce of over 20,000 people worldwide, we embrace the unique perspectives each person brings. Through comprehensive benefits and active community engagement, we create an environment where every team member has the opportunity to thrive. Learn more about Working at Wesco here.

Founded in 1922 and headquartered in Pittsburgh, Wesco is a publicly traded (NYSE: WCC) FORTUNE 500® company.

Wesco International, Inc., including its subsidiaries and affiliates (“Wesco”) provides equal employment opportunities to all employees and applicants for employment. Employment decisions are made without regard to race, religion, color, national or ethnic origin, sex, sexual orientation, gender identity or expression, age, disability, or other characteristics protected by law. US applicants only, we are an Equal Opportunity Employer.

Los Angeles Unincorporated County Candidates Only: Qualified applicants with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance and the California Fair Chance Act.

This posting is for a current, active vacancy intended for immediate hire.