Financial Analyst

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

• Administers user access, roles, security settings, and dimension hierarchies across multiple environments.
• Administers, manages, optimizes, and maintains 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.