Pricing Analyst II at Core & Main in Saint Louis, MO 63146

Job description

• Gather disparate data from various data sources, analyzes and normalizes the data to ensure quality of data for analysis. Responsible for providing consistent, relevant and accurate data as well as guidance/knowledge of the data and definitions that are available for analysis.

Responsibilities

• Serves as a resource to assigned client in area of expertise.
• Gathers and compiles raw data; conducts research for industry trends and benchmarks; and normalizes data to be incorporated into a centralized data format.
• Analyzes, reports, makes comparisons to industry/company benchmarks, determines trends, and prepares cost analyses.
• Defines data definitions and documents data limitations.
• Prepares spreadsheets for data analysis; prepare reports with charts and graphs, mailing lists, maps and ad hoc requests. May make presentations.
• Provides recommendations based on findings and analysis; provides input on policies and procedures.
• Participates in department and interdepartmental projects.
• Performs other duties as assigned.

Requirements

• Typical Training/Experience
• Typically requires BS/BA in a related discipline.
• Generally, 3-5 years of experience in a related field; certification is required in some areas OR MS/MA and generally 2-4 years of experience in a related field.
• Certification is required in some areas.
• Problem Complexity
• Demonstrates skill in data analysis techniques by resolving missing/incomplete information and inconsistencies/anomalies in more complex research/data.
• Autonomy
• Nature of work requires increasing independence; receives guidance only on unusual, complex problems or issues.
• Work review typically involves periodic review of output by a supervisor and/or direct "customers" of the process.
• Leadership
• May provide general guidance/direction to or train junior level support personnel or professional personnel.
• Expertise in working with spreadsheets, databases, strong understanding of financial concepts and data.
• Experience in aggregating large volumes of operational/ financial/customer data for analysis.
• Experience with data analysis in large distribution businesses.
• Certification on database/analysis tools.
• Knowledge of Excel, Work, Access, Power Point, Internet research.

Skills

Required

• Data analysis
• Spreadsheets
• Databases
• Financial concepts
• Data normalization
• Report preparation

Preferred

• Certification on database/analysis tools