Job Site Address: 600 Grant Street Pittsburgh PA 15219 (HQ). FT Telecommuting from anywhere in the U.S. is permitted.
Job Duties: Provide data insights analytics reporting tools and technologies that
assist leadership on the B2B sales team in making informed operational and
businessrelated decisions to accomplish their commercial sales. Deliver both
dynamic and static versions of the Pugh Matrix an internal decisionmaking tool
involving the compilation of data from multiple sources. Create tools and processes for visibility and performance management tracking of Regional Sales Managers and customers. Manage and support the commercial costing and profitability tools. Support customer contract negotiations by providing analyses for new contracts and contracts that are being renegotiated. Assist in the development and creation of new commercial tools and dashboards. Update and maintain multiple daily/weekly/monthly reporting to different levels and responsibilities of commercial organization. Regularly update and track contracts by various metrics and KPIs. Support import trade cases by providing relevant commercial data. Telecommuting from anywhere in the U.S. is permitted.
Job Requirements: Position requires a Bachelors degree or foreign equivalent in
Business Administration Supply Chain Management Information Systems
Information Technology Management or closely related field of study and 3 years
of experience in the job offered or related data analysis/analytics occupation. Must
have 3 years of experience in: Data analysis using Microsoft Excel including Pivot
Tables Power Pivot advanced formulas (vlookup index/match sumifs etc.) and
conditional formatting; Data compilation from varying sources and data source
management using Power Pivot and/or Power Query. Must have 2 years of
experience in: Designing and developing commercial dashboards for performance
management using Tableau. Must have 1year experience in: Data visualization
using Periscope to understand customer profitability identify revenue leakage and create actionable solutions; and Crossfunctional KPI Management.
Travel Requirement: N/A
To apply: Send resume and cover letter to with Ref# PM0425 in re line.
Required Experience:
IC