Senior Financial Analyst

Core & Main; St. Louis (MO); On-site; USD 70,000 - 100,000; Full time

Job summary

Core & Main, based in St. Louis, seeks a data analyst to gather disparate data from multiple sources, normalize datasets, and ensure data integrity for analysis.

You will provide consistent, well-defined data and definitions for analysis, support dashboards, and work with stakeholders to translate data into actionable insights.

Strong MS Excel and database knowledge, attention to detail, and the ability to handle multiple projects are required for success in this role.

Qualifications

• Bachelor's degree in related discipline with experience in data analysis or finance
• Advanced MS Excel skills are required
• Strong attention to detail and data accuracy
• Knowledge of relational databases and data concepts
• Ability to manage multiple projects simultaneously
• Strong problem solving and deductive reasoning

Responsibilities

• Gathers and compiles raw data; researches industry trends and benchmarks; normalizes data for centralized formats
• Analyzes data, prepares reports with charts and cost analyses
• Defines data definitions and documents limitations
• Prepares spreadsheets and reports; may assist in meetings with presentations
• Provides recommendations and input on policies and procedures

Skills

Attention to detail

Project management

Verbal & written communication

Problem solving

Education

BS/BA in Accounting or Finance related field

MS/MA with 3-5 years experience acceptable

Tools

MS Excel

MS PowerPoint

Relational databases

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.
• Prepare spreadsheets for data analysis; prepare reports with charts and graphs, mailing lists, maps and ad hoc requests. May accompany Manager to meetings to assist with 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.

Nature and Scope

• Identifies key barriers/core problems and applies problem solving skills in order to deal creatively with complex situations. Troubleshoots and resolves complex problems. Makes decisions under conditions of uncertainty, sometimes with incomplete information, that produce effective end results.
• Independently performs assignments with instruction limited to results expected. Determines and develops approach to solutions. Receives technical guidance only on unusual or complex problems or issues.
• May oversee the completion of projects and assignments, including planning, assigning, monitoring and reviewing progress and accuracy of work, evaluating results, etc. Contributes to employees professional development but does not have hiring or firing authority.

Work Environment

• Most of the time is spent sitting in a comfortable position and there is frequent opportunity to move about.
• Located in a comfortable indoor area. Any unpleasant conditions would be infrequent and not objectionable.
• No travel required.

Minimum Qualifications

• Must be a minimum of 18 years of age or older
• Must pass pre-employment assessment(s) if applicable

Education And Experience

• Typically requires BS/BA in related discipline. Generally 5-8 years of experience in related field; certification is required in some areas OR MS/MA and generally 3-5 years of experience in related field. Certification is required in some areas.

Preferred Qualifications

• Bachelor's Degree in Accounting and/or Finance with 3+ years experience
• Strong working knowledge of MS Excel (advanced level)
• Strong attention to detail
• Working knowledge of relational database concepts
• Ability to manage multiple projects simultaneously
• Sound deductive reasoning and problem solving skills
• Excellent written and verbal communication skills
• Presentation skills (MS Powerpoint)

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