Brooksource

Compensation

Full Description

Senior BI Analyst – Supply Chain Analytics 3-Month Contract with Long-Term Extensions Remote (first week onsite in Atlanta, GA) We are seeking a Sr Supply Chain BI Analyst with deep expertise optimizing pre-existing SQL queries and Tableau dashboards that support critical supply chain reporting. The primary focus of this role is SQL and Tableau performance optimization – including reducing report runtimes, lowering Snowflake compute costs, and improving dashboard efficiency and usability. This role supports BI strategy, SAP Warehouse Management migration, and nationwide distribution center consolidation initiatives. Key Responsibilities • Optimize large, complex pre-existing SQL queries in Snowflake and SAP-supported environments to improve report performance and reduce compute costs. • Diagnose and improve SQL performance using join strategies, query structure improvements, clustering/indexing considerations, and targeted performance tuning. • Optimize existing Tableau dashboards for speed, scalability, and efficient data access – not rebuilding dashboards from scratch. • Partner with BI analysts to review existing reports, identify inefficiencies, and implement performance improvements. • Enhance and optimize existing supply chain and distribution center reporting (inventory, forecasting, throughput, cost, performance). • Measure, track, and communicate performance gains, including before-and-after runtimes and cost savings. • Translate business requirements into optimized, reliable reporting solutions by improving the efficiency of existing reports. • Validate data accuracy while ensuring consistent performance across reporting outputs. • Conduct SQL and dashboard code reviews to maintain quality, performance, and consistency across BI deliverables. Qualifications • 4+ years of BI or analytics experience, with a primary focus on optimizing pre-existing dashboards and reports rather than building new ones. • Expert‑level SQL optimization experience, including diagnosing query performance using join strategies, query structure changes, clustering or indexing, and performance tuning. • Advanced Tableau dashboard optimization experience, including improving the performance and scalability of existing dashboards (not just dashboard creation). • Hands-on experience working with supply chain data, especially inventory and procurement. • Experience supporting ERP, WMS, or supply chain system migrations (SAP preferred). • Snowflake SQL experience preferred but not required.