Pricing Analyst

Core-; St. Louis (MO); On-site; USD 60,000 - 90,000; Full time

Job summary

Core & Main in St. Louis seeks a data analyst to gather data from various sources, normalize it, and ensure quality for analysis. You will provide consistent data and guidance on definitions across projects.

Responsibilities include compiling datasets, performing trend analyses, preparing charts/graphs, and delivering cost analyses with recommendations. Requires 2–3 years in a related field and strong Excel/database/data-tool skills.

Qualifications

• BS/BA in a related discipline preferred; MS/MA in related field advantageous.
• 2–3 years of experience in a related area; certification in some areas may be required.
• Experience aggregating large volumes of operational/financial/customer data for analysis.
• Strong Excel, database and data-tools familiarity.

Responsibilities

• Gather and consolidate data from multiple sources for analysis.
• Normalize data and document data definitions and limitations.
• Analyze data, identify trends, prepare cost analyses and benchmarks.
• Prepare spreadsheets and create reports with charts, graphs, and mailing lists.
• Provide recommendations and input on policies; present findings to stakeholders.
• Collaborate on departmental projects and cross‑functional initiatives.

Skills

Data analysis

Data wrangling

Financial concepts

Research

Education

BS/BA in related discipline

MS/MA in related field

Tools

Excel

Word

Access

PowerPoint

Internet research

Job description

Based in St. Louis, Core & Main is a leader in advancing reliable infrastructure with local service, nationwide. As a specialty distributor with a focus on water, wastewater, storm drainage and fire protection products and related services, Core & Main provides solutions to municipalities, private water companies and professional contractors across municipal, non-residential and residential end markets, nationwide. With over 370 locations across the U.S., the company provides its customers local expertise backed by a national supply chain. Core & Main’s 5,700 associates are committed to helping their communities thrive with safe and reliable infrastructure. Visit coreandmain.com to learn more.Job SummaryGather 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.Major Tasks, Responsibilities and Key AccountabilitiesServes 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.Preferred QualificationsExpertise 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.Career Level DimensionsTypical Training/ExperienceTypically requires BS/BA in a related discipline.Generally, 2-3 years of experience in a related field; certification is required in some areas OR MS/MA and generally 1-2 years of experience in a related field.Certification is required in some areas.Problem ComplexityDemonstrates skill in data analysis techniques by resolving missing/incomplete information and inconsistencies/anomalies in more complex research/data.AutonomyWork review typically involves periodic review of output by a supervisor and/or direct "customers" of the process.Minimum QualificationsMust be a minimum of 18 years of age or olderMust pass pre-employment assessment(s) if applicableEnvironmental Job RequirementsLocated in a comfortable indoor area. Any unpleasant conditions would be infrequent and not objectionable.No travel required.Most of the time is spent sitting in a comfortable position and there is frequent opportunity to move about. On rare occasions there may be a need to move or lift light articles.This information indicates the general nature and level of work performed by associates in this role. It is not designed to contain a comprehensive inventory of all duties, responsibilities, and qualifications required of associates assigned to this role. This description supersedes any previous or undated descriptions for this role. Management retains the right to add or change the duties of the position at any time.Core & Main is an Equal Employment Opportunity employer. Employment at Core & Main is based solely on a person’s merit and qualifications directly related to professional competence. Core & Main does not discriminate against any employee or applicant on the basis of race, creed, color, religion, national origin, nationality, ancestry, age, disability, veteran status, pregnancy or related condition (including breastfeeding), affectional or sexual orientation, gender identity or expression, marital status, status with regard to public assistance, citizenship, or any other basis protected by law.None of the questions in this application are intended to elicit information regarding any protected characteristics, nor imply any limitation, illegal preferences or discrimination based upon non-job-related information or protected characteristics.For more information, please visit https://www.eeoc.gov