Brokerage Strategy Specialist (Data Analyst)
St. Louis
• Create SQL queries to analyze large volumes of data using Excel 2013 (Pivot Tables, Power Query, Macros, Advanced Formulas) and Tableau to identify business opportunities and efficiencies through statistical analysis• Drive an analytical project from start to finish by gathering requirements, analyzing data, and summarizing findings into PowerPoint tailored to a wide audience, including upper management• Use abstract thinking and root cause analysis to interpret data and tell the story behind the numbers • Perform Deep Dive projects to provide insight on areas of concern and fulfill Ad Hoc Requests for internal and external partners• Generate monthly reports to track KPIs and MAPS (Major Action Programs)