Data Analyst

Gather disparate data; analyze and normalize to ensure data integrity for analysis. Provide consistent, relevant and accurate data and analysis as well as guidance/knowledge of the data and definitions that are available. Constantly strive for process improvement looking to add value across the organization through insightful analytics.

Major Tasks, Responsibilities And Key Accountabilities

• Serves as a data expert across the entire organization.
• Gathers and compiles raw data; conducts research for industry trends and benchmarks; and normalizes data.
• Develops complex data models using disparate sources; transforms data into easily consumable sources that can be used to produce insightful and meaningful analytics.
• Analyzes, reports, makes comparisons to industry/company benchmarks, determines trends, and prepares cost analyses.
• Defines data definitions and documents data limitations.
• Prepares data models for analysis; create dashboards, reports, maps and ad hoc requests using tools such as Microsoft Excel, Alteryx, Tableau, Microsoft Power BI, SQL Server Management Studio, SAP BPC, Thoughtspot and Showcase Query. May make presentations.
• Provides recommendations based on findings and analysis. Provides input on policies and procedures. Constantly questions the status quo and searches for opportunities to improve processes.
• Participates in department and interdepartmental projects.
• Performs other duties as assigned.

Minimum Qualifications

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

Preferred Qualifications

• Expertise in working with spreadsheets, databases, strong understanding of financial concepts and data.
• 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.
• Advanced experience with Microsoft Office Suite
• Experience with Alteryx, SQL (SQL Server Management Studio), DB2, Tableau, Microsoft Power BI, SAP BPC, Thoughtspot and Showcase Query a plus.

About Core & Main

Based in St. Louis, Core & Main is a leading distributor of water, sewer, storm drain and fire protection products in the United States. Operating approximately 320 branches nationwide, the company combines local expertise with a national supply chain to provide contractors and municipalities innovative solutions for new construction and aging infrastructure. Core & Main’s 4,500 plus associates are committed to the safe distribution of water and fire protection to help communities thrive. Visit www.coreandmain.com to learn more.

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