Financial Analyst

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  to learn more.

Gather disparate data from various data sources; analyze and normalize to ensure data integrity for analysis. Provide consistent, relevant and accurate data as well as guidance/knowledge of the data and definitions that are available for analysis.

• 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.

• Administer user access, roles, security settings, and dimension hierarchies across multiple environments.
• Administer, manage, optimize, and maintain corporate performance management (CPM) and reporting platforms.
• Bridge finance and IT by building business rules, configuring data integrations, maintaining metadata, and supporting month-end close and budgeting processes.

• Demonstrates skill in data analysis techniques by resolving missing/incomplete information, inconsistencies/anomalies in more complex research/data.
• Nature of work requires increasing independence; receives guidance only on unusual complex problems or issues.
• Work review typically involves periodic review of output by supervisor and/or direct "customers" of the process.
• May provide general guidance/direction to or train junior level support personnel or professional personnel.

• Must be a minimum of 18 years of age or older.
• Must pass pre-employment assessment(s) if applicable.
• Typically requires BS/BA in related discipline.
• Generally, 0-2 years of experience in related field.
• Certification is required in some areas OR MS/MA and generally 0-2 years of experience in related field.
• Certification is required in some areas.

• Expertise in working with spreadsheets, databases, strong understanding of financial concepts and data.
• One Stream and PBI experience preferred.
• Experience in aggregating large volumes of financial data for analysis.
• Experience with data analysis in large distribution businesses.
• Certification on database/analysis tools.
• Experience in acquiring data within large multi-system enterprise environments.
• One Stream and Power BI experience.

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,…