Data Analyst II
About The Position
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; 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.
Nice To Haves
- Advanced expertise in Power BI (data modeling, DAX, Power Query, report design)
- Strong understanding of Power BI security and governance in enterprise environments
- Experience in aggregating large volumes of financial data for analysis
- Experience consolidating data across multiple ERPs
- Certification on database/analysis tools
- Advanced experience with Microsoft Office Suite (Power Query, Power Automate, Excel, Power Point)
- Experience with Alteryx, SQL (SQL Server Management Studio), OneStream a plus.
Responsibilities
- Serves as a data expert across the entire organization
- Demonstrated ability to translate ambiguous business questions into effective analytical solutions
- Gathers and compiles raw data; conducts research for industry trends and benchmarks; and normalizes data
- Documents data standards, recommendations, limitations and future state roadmap
- Prepares data models for analysis; create dashboards, reports, maps and ad hoc requests
- Provides recommendations based on findings and analysis. May aid in creation of Power Point presentations.
- 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
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Education Level
No Education Listed
