Financial Analyst

CORE & MAIN LP; Missouri; On-site; USD 65,000 - 90,000; Full time

Job summary

Core & Main, based in St. Louis, seeks a data analyst to gather and normalize data from multiple sources, ensuring accuracy for analysis and reporting. You will support trend analyses and benchmarks across municipal and industrial customers.

The role emphasizes data integrity, collaboration with departments, and readiness to create clear visualizations and ad hoc reports using Power BI and OneStream.

Qualifications

• BS/BA in related discipline.
• 0-2 years of related field experience.
• Certification may be required in some areas.

Responsibilities

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

Skills

Data analysis

Financial data

Spreadsheet proficiency

Power BI

OneStream

Education

BS/BA in related discipline

Tools

OneStream

Power BI

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 Summary

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.

Major Tasks, Responsibilities and Key Accountabilities

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

System Maintenance

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

Nature and Scope

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

Minimum Qualifications

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

Preferred Qualifications

• Expertise in working with spreadsheets, databases, strong understanding of financial concepts and data.
• OneStream 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.
• OneStream 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, 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 click here or visit https://www.eeoc.gov

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.