Senior Data Analyst

Core & Main•Saint Louis, MO

11h•Onsite

About The Position

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.

Requirements

Expertise in working with spreadsheets, databases, strong understanding of financial concepts and data.
Experience in aggregating large volumes of data for analysis.
Experience with data analysis in large distribution businesses.
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, Thoughtspot and Showcase Query.
Microsoft Stack (Fabric, Advanced Power BI - DAX, Power Query, Report Design, Excel, Power Automate), ERP consolidation experience, SQL (SSMS), database management, experience working with stakeholders to gather requirements and develop solutions collaboratively, experience and comfortability training end-uses

Nice To Haves

Certification on database/analysis tools such as Alteryx and Power BI.

Responsibilities

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.