Market Research Analyst

Twyford Law Office; Pittsburgh (Allegheny County); Remote; USD 60,000 - 85,000; Full time

Job summary

A leading company in the steel industry is seeking a full-time Market Research Analyst to deliver data insights and develop analytics tools that support the commercial sales team. The role allows for telecommuting within the U.S., requiring analytical skills, a strong background in data management, and experience in dashboard design. Candidates must hold a relevant Bachelor's degree and have professional experience in data analysis and visualization.

Qualifications

• 3 years experience in data analysis/analytics occupation.
• 2 years experience designing dashboards for performance management.
• 1 year experience in data visualization techniques.

Responsibilities

• Provide data insights to support B2B sales decisions.
• Create tools for sales performance management.
• Update and maintain reporting across commercial organization.

Skills

Data analysis using Microsoft Excel

Data visualization using Periscope

Designing and developing dashboards using Tableau

Education

Bachelor's degree or foreign equivalent in Business Administration

Supply Chain Management

Information Systems

Information Technology Management

Tools

Tableau

Power Pivot

Power Query

Microsoft Excel

Job description

United States Steel Corp. seeks FT Market Research Analyst. Job title: Market Research Analyst (Ref# PM0425)

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

To apply: Send resume and cover letter to [e-mail] with Ref# PM0425 in re line.