Market Research Analyst (Ref# PM0425)

Steel Corporation; Pittsburgh (Allegheny County); Remote; USD 60,000 - 100,000; Full time

Job summary

An established industry player is seeking a data analyst to provide critical insights and analytics tools that empower the B2B sales team. This role involves developing dashboards, managing commercial costing tools, and supporting contract negotiations through data analysis. The ideal candidate will leverage advanced Excel skills and visualization tools like Tableau and Periscope to drive performance management and profitability insights. If you're passionate about data and eager to make a significant impact in a dynamic environment, this opportunity is perfect for you. Telecommuting is permitted, allowing flexibility in your work location.

Qualifications

• 3+ years of data analysis experience using advanced Excel features.
• Experience designing dashboards for performance management.

Responsibilities

• Provide data insights and analytics reporting tools for the B2B sales team.
• Create tools for visibility and performance management tracking.

Skills

Data analysis using Microsoft Excel

Data visualization using Periscope

Designing dashboards using Tableau

Data compilation from varying sources

Cross-functional KPI Management

Education

Bachelor's degree in Business Administration

Bachelor's degree in Supply Chain Management

Bachelor's degree in Information Systems

Bachelor's degree in Information Technology Management

Tools

Microsoft Excel

Tableau

Power Pivot

Power Query

Job description

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
business-related decisions to accomplish their commercial sales. Deliver both
dynamic and static versions of the Pugh Matrix, an internal decision-making 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 Bachelor's 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 1-year experience in: Data visualization
using Periscope to understand customer profitability, identify revenue leakage, and create actionable solutions; and, Cross-functional KPI Management.

Travel Requirement: N/A