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.

- 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.

- 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.

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.

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.

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.

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.

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.

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.

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.

Chicago, IL

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