BI Data Analyst
Core
Develop BI datasets, data models, and visualizations to build should-cost models, monitor raw material costs, and create executive dashboards for category reviews and margin analysis.
Role type
Senior IC BI Data Analyst (Procurement & Cost Modeling)
Builds
Production BI dashboards, data models, and cost analysis reports
Domain
Procurement, Supply Chain, and Cost Management
Deliverable
production ML models | dashboards & analysis
Required skills
Power BI, SQL, Python, R, Excel/VBA, Data Modeling, ERP systems, Cost Modeling, Variance Analysis, Data Visualization
Preferred skills
Microsoft Fabric, BI tool certification, Statistical platforms
Technologies
Power BI, SQL, Python, R, Excel, VBA, Microsoft Fabric, ERP
Responsibilities
Build should-cost models using commodity indices and labor costs; Monitor raw material and input costs; Maintain Procurement Gains Tracker; Create executive dashboards for category reviews; Design and maintain BI datasets and data models; Develop optimized data models for business units; Extract, transform, and model ERP transactional data; Design accessible self-service dashboards; Partner with IT to develop security standards for BI applications.
Seniority
Mid-Senior, hands-on IC
