Spencer Hoge

Experience

• 

  World Affairs Council of Jacksonville

  Aug 2014 - Dec 2014

  Intern

  • Worked with local business partners to secure ongoing support for the Council’s events.• Assisted the leadership team with planning, budgeting, and running the annual Admiral Jonathan T. Howe Academic World Quest competition for local high school students.• Analyzed and reported findings to leadership on the ongoing conflict in the Democratic Republic of the Congo. • Created, planned, and implemented an analytical assessment project (regarding the ongoing conflict in the DRC) for 100+ high school students to be completed at an annual kick-off event. Show less

• 

  University of North Florida

  Feb 2016 - Feb 2018

  Senior Library Services Assistant

  • Managed Library Social Media Accounts.• Created marketing and outreach content, as well as library graphic designs, to increase Social Media traffic and promote events.• Served on the Outreach Committee to create and implement Social Media and Marketing strategies with the purpose of increasing campus exposure to the full array of library services (including tutoring, IT help, research assistance, and one-on-one consultations).• Increased online traffic through user interaction and targeted content development.• Monitored Social Analytics to identify trends.• Planned, budgeted, and executed various outreach and marketing activities both independently and as part of a team.• Attended community and campus outreach events on behalf of the library.• Aided students, staff, and faculty with their research by conducting my own research, teaching various research methods, providing feedback, and offering specific, technical, statistics assistance. • Assisted with day-to-day operations of an academic library.• Served on the Faculty Hiring Committee which defined the criteria for vacant librarian positions, interviewed candidates, and presented our decision to the Dean. Show less

• 

  EY

  Feb 2018 - Sept 2021

  • Trend Identification: Utilize Structured Query Language (SQL) to aggregate data from 10 analysts and 6 quality assurance resources, clean data, and identify trends in a single report.• Leadership: Lead a team of 5 analysts on client's enterprise data transformation/governance project to implement data quality rules as part of a migration to a new data lake model.• Business Analysis: Review code to analyze logic and ensure it aligns with business requirements.• Data Analysis: Analyze data using SQL, present insights and issue recommendations to the client.• Data Quality: Gather business requirements and technical metadata to draft data quality rules.• Investigation and Issue Resolution: Investigate data, identify risks, and determine solutions.• Data Forecasting: Manage a daily tracker that reports project metrics for a team of 5 and forecasts team Key Performance Indicators (KPI's) based on historic performance.• Quality Assurance: Create and analyze data quality reports to identify data and/or code defects.• Data Engineering: Write data rules in Ab Initio to be applied during the ETL process.• Increased Latitude: Lead a team of staff members that creates macro-enabled, Excel dashboards that predict deliverable completion time, and measure analyst quality/expertise.• International Teaming: Train a team of offshore resources on new technologies and client processes. Show less • Transformed project data to a user-friendly format compiled from approximately 10,000 loans with 6 data elements per loan, upon customer request.• Designed data models used on 7 different client projects to report KPI's, display resource allocation, visualize engagement metrics, and project future staffing demand.• Analyzed transaction data using Tableau to determine various risk factors and write risk assessment memos to mitigate client risk exposure.• Collaborated with leadership to create effective and organized data management processes• Won internal "Innovation Challenge" by founding a technical assistance team to standardize company tools and support client needs.• Built and maintained a SharePoint website to house 10+ modular tools used to decrease project start-up time.• Reviewed loans, conducted business and transaction analysis, identified patterns to determine customer/client risk, identified process inefficiencies and suggested improvements.• Pulled daily report tracking progress towards completing 200 client deliverables across a 20 person team and identified aging deliverables to determine additional resourcing needs.• Trained client team on two different daily reports and successfully transition ownership and adoption to the client.• Answered client questions and provided operations support within a 24-hour SLA. Show less

  • Senior

    Sept 2020 - Sept 2021

  • Analyst

    Feb 2018 - Sept 2020
• 

  Clearsulting

  Sept 2021 - now

  • Solution Architect

    Jun 2023 - now

  • Senior Digital Analyst

    Sept 2021 - Jun 2023