Sarah Mannheim Email & Phone Number

Chicago, Il, Us

- Supporting large-scale data migration from Tableau Prep to DBT- Utilizing DBT to design client specific ETL pipelines of cross-platform data, pairing advertising performance, eCommerce, and web analytics- Managing help desk queue for 65+ clients, building, troubleshooting, and enhancing DBT models and Tableau dashboards- Overseeing a team of 5 BI Developers, providing guidance and supervision with help desk tickets

- Developing and standardizing naming taxonomy for use across multiple clients and on all channels, allowing smooth integration of high granularity cross-platform data in Tableau Prep or custom SQL- Creating templates in Tableau Desktop for Forecasting, Pacing, and Projection Dashboards, and building new and optimizing existing Tableau Prep flows for use with dashboards

- Building roadmaps, supporting implementation, and producing recommendations for creative and media optimizations based on A/B testing, Forecasting, Halo Analysis, and Cohort Analysis methodologies- Producing and maintaining Tableau dashboards highlighting KPIs across Display, Search, Shopping, Social, Amazon, App, and Affiliate advertising campaigns- Reviewing, analyzing, and presenting qualitative and quantitative analysis to internal and external stakeholders, delivering clear, concise, and actionable insights- Leading analytics engagement for multiple clients, managing internal and external communication, and providing mentorship to other analysts

Chicago, Illinois

- Stewarding the purchase of digital ad impressions for 15+ campaigns, totaling over $2.6M in a two-year period, creating and maintaining performance dashboards in Tableau- Producing AI generated maps of client and competitor display ads, isolating visual clusters and whitespace of creative in the category, influencing future strategy- Creating and maintaining interactive dashboards in Tableau for 3 mobile applications, displaying real-time app performance and media metrics, leading to biweekly app and media optimizations- Supporting client transition to dynamic creative optimization technology, developing naming taxonomy capturing performance for 20+ variables within each creative- Training and providing support to internal and external users on proprietary research and analytics tools and methodologies- Generating ad-hoc reports through custom queries on multiple databases in a PostgreSQL environment

Chicago, Illinois

Ardent is a software and analytics company that helps marketers predict and analyze consumer demand. Now part of global creative powerhouse Leo Burnett.- Aggregating consumer search trends, influencing media buying strategy and improving click through performance for video and display advertising- Restructuring reporting for multiple clients by transitioning to interactive dashboards in PowerBI, limiting ad-hoc requests and improving transparency into real-time performance metrics- Analyzing website and ad performance, reporting on consumer trends and steering development of future creative towards consumer demand

Chicago, Illinois

- Analyzed 15+ years of historical data for strengths, weaknesses, and trends in facilities maintenance work orders, visualized market trends, strategically recruited contractors for weak markets, and forecasted future business needs- Built and maintained interactive dashboards in PowerBI analyzing business metrics of subcontractors and clients, generated recurring and ad-hoc reports- Researched and forecasted revenue for potential clients, prepared $10M+ in RFPs for new clients, interpreted and cleaned historical client data for import into database- Integrated Google Fusion Maps into company database, overlaying client needs with subcontractor coverage areas, improving profit margin by $2M annually through increased efficiency in dispatching

Chicago, Illinois

- Project manager for $7M nationwide HVAC preventative maintenance program, in tandem with $9M capital HVAC unit replacement program for large retail client- Implemented company-wide credit card usage procedure decreasing financial risk, improving visibility of expenditures, and reducing unregulated charges by over 65%- Managed subcontractor relationships to increase retention, coordinated the first annual subcontractor summit,and participated in subcontractor roadshows around the country

Chicago, Illinois

- Project manager for $1M equipment replacement program for 1,2000+ users at JUF and sister organizations across Chicago- Coordinated the purchase, deployment, and inventory tracking of all computer and telecommunication equipment and services company-wide- Came under budget by $100k after creating efficient purchasing and invoicing methods, reevaluating user needs, and securing competitive pricing- Maintained budgets, tracked spending, and reduced cost for multiple departments- Evaluated and restructured efficient workflows, designed purchasing and asset tracking software that consolidated redundant work processes

Boston, Ma

- Assumed leadership role during the opening of a new restaurant location- Developed and implemented a streamlined inventory tracking, food ordering/receiving, and invoice processing strategy- Managed finances, inventory, and payroll for restaurant- Controlled invoicing in MenuLink and prepared payments for vendors- Oversaw new hire training, employee scheduling, and employee payroll

Chicago, Il

- Assisted in the grand opening of a new restaurant and hotel- Implemented ChefTec system to centralize inventory counts, product pricing, invoice details, and recipe specifics, to track food costs and increase profit margins- Efficiently tracked all incoming and outgoing packages- Supervised ordering, receiving, and inspection of all incoming deliveries for the hotel and restaurant

Chicago, Il

- Reworked existing inventory system to more effectively order, receive, sort, and shelve products- Inputted invoices and maintained accurate inventory counts