Spencer Cole work email
- Valid
- Valid
- Valid
- Valid
Spencer Cole personal email
Spencer Cole phone numbers
Data is not an end in itself but a means to an end. Data should cast ripples. It should be mined and refined and fit carefully into the world to change the world for the better.As a Senior Data Analyst with 10+ years of experience, I not only thrive on, but have a proven track record for creating real, tangible, actionable insights from giant data sets and making that information accessible to anyone, from a lay audience to a Fortune 200 CEO. With my philosophy out of the way, I can get into my skillset (outside of my amazing transitions).As an accomplished and results-driven Senior Data Analyst with over 10 years of experience in data analysis, business intelligence, and process automation, I am skilled in leading projects from ideation to execution, with a deep understanding of data quality, statistical analysis, and report automation. I take pride in fostering clear communication by bridging technical jargon and business language.Demonstrated ability to translate complex technical concepts for non-technical stakeholders and vice versa, ensuring clear communication and collaboration between technical teams and business leaders to drive informed decision-making across all organizational levels.Expert in developing and optimizing SQL queries, reports, and dashboards, as well as automating complex data pipelines using SQL, Python, and Power BI.My ability to work with cross-functional teams to define key metrics and KPIs has driven business performance and improved decision-making, delivering data-driven insights, and supporting strategic initiatives that led to multi-million-dollar revenue growth.Insert snappy outro here that makes recruiters feel like they can jump right into a conversation in a fun and approachable way! Feel free to reach out on InMail or you can find my email listed under Contact Info!
-
Senior Data AnalystCircana Mar 2021 - PresentChicago, Illinois, United States• Scripted hundreds of custom SQL data ad hoc requests from clients, leadership, and account management teams• Created, productionalized, and supported custom data feeds supporting >$500k in direct yearly revenue using SQL, email automations, and Python• Automated into production dozens of custom SQL scripts to support local reporting and tools• Compiled older excel documents while increased their flexibility and efficiency by adding additional variables and connecting them directly to server held data• Developed and maintained SQL queries, reports, templates, and dashboards to provide actionable insights to senior leadership, account mangers, SMEs, and procurement specialists• Collaborated with cross-functional teams to define 3 key metrics, 5 KPIs, and reporting requirements to drive business performance improvements and then wrote the core SQL to put them into practice • Analyzed large datasets from Petco to identify customer trends and decision-making behaviors, influencing product placement and shelf space optimization• Collaborated with Petco leadership and subject matter experts (SMEs) to conduct a deep dive into dog food data, leading to strategic insights•Leveraged Dog Food analysis to secure additional contracts for multiple product categories, including Dog Toys, Dog Accessories, Cat Food, Cat Toys, Cat Accessories, and other pet product lines -
Data AnalystAimia Inc Jan 2018 - Mar 2021Minneapolis, Minnesota• Wrote original back end data templates with Velocity, variable SQL, PySpark, and Python• Integrated John Hopkins Covid-19 data with existing data feeds and built contextual reports• Coded underlying scripts for alpha and beta test applications, then proposed associated efficiency edits• Translated 150+ pages of SQL code from Kognitio to Snowflake• Generated custom in-store coupon banks for 15M members based on 3.5B historical purchases• Wrote the SQL code to create, measure, and control for over a dozen coupon campaigns for different categories and merchants• Transformed raw data and custom data feeds into meaningful visualizations and reports using SQL, Excel, and Power BI• Performed data cleaning and validation using SQL, ensuring data accuracy and consistency for reliable analysis for the data lake and OLAP cubes• Conducted A/B testing and statistical analysis on datasets to make marketing decisions, improve campaigns, and assess marketing efficiency• Taught Excel, SQL, Power BI to junior team members and simplified basics to account managers -
Business And Data Analyst (North America)C.H. Robinson Jun 2016 - Jan 2018Minneapolis, Minnesota• Constructed the SQL logic, process and report for compliance for the North American automation goals of 2020• Built the bid management process for NA Drop Trailer using macro enabled templates, Sharepoint data lists, and SQL• Automated the historical reports for NA Truckload large bid process with VBA macros that generate dynamic SQL• Designed a user-friendly report for Audit to track red flags in the financial system• Taught and trained new hires on SQL and the system structure -
Business AnalystC.H. Robinson Mar 2015 - Jun 2016Greater Los Angeles Area• Created Access databases to process corporate server-side data (T-SQL) on a branch-specific level • Developed two in-depth Excel classes to teach beginning to advanced skills • Completed Excel tools to automate processes, including accounting invoices and sending past due notifications • Produced automatic quoting tools to process and parse complex, multi-part rate sheets, including accessorials • Devised new regional customer based reports and reworked existing reports for a better user experience• Used statistical analysis to create customer specific zone, state, and lane pricing
-
Operations And Logistics Analyst (Internship)Giving Children Hope Nov 2014 - Mar 2015Greater Los Angeles Area• Created auto-sorting system to track expiration dates in real time, using Excel VBA• Worked on implementation and integration of the above system• Designed performance graphics and summary metrics for the system• Improved process flow and inventory control metrics -
Student Worker Manager, Long Term Storage Manager, And Special Projects ManagerWashington University In St. Louis Aug 2012 - May 2014St Louis, Missouri, United States• Promoted within one month of starting the job• Held three concurrent management roles, two of which were created for me• Designed and implemented an organization system for Student Union Storage• Co-created training materials and developed "How-To" documents for incoming student workers and treasurers -
Treasurer Of Various OrganizationsWashington University In St. Louis Jan 2010 - May 2014Washington University In St Louis• Filmboard (Jan 2010 - May 2014)• Active Minds (Jan 20110 - May 2014)• Belegarth Medieval Combat Society (Jan 2010 - May 2014)• Anime Exploration Team (Dec 2011 - May 2014)
-
Research/Efficiency InternThe Stern Group, Inc Jun 2012 - Aug 2012Washington, Dc• Created an in-depth market analysis on the effects of a trial outcome for Intel• Researched and presented investment opportunities, competitors, and Chinese market entry for a green energy startup• Minimized overhead costs by migrating data and optimizing cloud, phone and e-mail services
Spencer Cole Skills
Spencer Cole Education Details
-
Operations And Supply Chain Management
Frequently Asked Questions about Spencer Cole
What company does Spencer Cole work for?
Spencer Cole works for Circana
What is Spencer Cole's role at the current company?
Spencer Cole's current role is Senior Data Analyst.
What is Spencer Cole's email address?
Spencer Cole's email address is sp****@****mia.com
What is Spencer Cole's direct phone number?
Spencer Cole's direct phone number is +131495*****
What schools did Spencer Cole attend?
Spencer Cole attended Washington University In St. Louis - Olin Business School, Washington University In St. Louis.
What skills is Spencer Cole known for?
Spencer Cole has skills like Microsoft Excel, Public Speaking, Microsoft Office, Powerpoint, Budgets, Financial Analysis, Microsoft Word, Start Ups, Leadership, Operations Management, Management, Film.
Not the Spencer Cole you were looking for?
-
1zolldata.com -
-
3wastemedic.com, radiationbusiness.com, regalplastic.com1 +161549XXXXX
-
1mcdaniel.edu
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial