Karoline

Senior Data Analyst

The Purple Carrot•  August 2023 - Present

Own analytics for operations, growing the department's business intelligence, as well as data and analytics capabilities ● Refined and redefined key business rules, remodeled the entire operations portion of the larger data model, created brand new models to better support more meaningful visualizations ● Conduct quantitative and qualitative analysis to identify root causes, improve business processes, and foster data-driven decision-making to shape strategy ● Develop project-specific data management plans covering query-building, reporting, data transfer, and overall workflow processes ● Create and maintain SQL queries and Python scripts to automate workflow processes (e.g. inventory movement Python/Flask script that cut a 6 hour process down to 15 min)

Data Analyst

The Purple Carrot•  June 2022 - August 2023

Collaborated to establish an analytics engineering operation by adding dbt to our transformational layer, speeding up our BI tool up to 10x ● Performed data transformations with dbt and enhanced query performance within Looker in order to improve data accuracy and introduce new customer engagement metrics with large-scale data sets ● Used Python to conduct deep dive analytics and told complex stories through dynamic visualizations; discovered early indicators for VIP customers to identify them earlier in their relationship with the company ● Delivered high-quality, actionable insights to enhance business strategy

Associate

New York State Education Department•  June 2018 - June 2022

York State Education Department – Albany, NY | 2018-2022 ● Overhauled the entire data model for the Office of Higher Education (SQL) ● Identified data issues, gaps, and improvement opportunities through data maturity assessments and lineage analyses ● Built and iterated on reports with Power BI, developed a SQL query to accurately track proposals time in process ● Streamlined the entire proposal workflow system, automated all email communications through the database with VBA, and eliminated paper from the entire process ● Managed the access, configuration, and functionality of core business systems

Director

Union College•  August 2013 - June 2018

Set standards and processes for analysis and reporting; developed a data strategy ● Utilized KPIs to strategize and execute solutions to meet student needs supported in data ● Communicated complex data into simpler formats for internal and external stakeholders ● Supervised professional staf

Director

Southern Vermont College•  June 2010 - July 2013

Established first-ever KPIs for the department resulting in a 50% increase in student activity participation and 15% increase in enrollment in leadership training programs ● Prepared and presented reports, insights, and recommendations to senior management and stakeholders ● Spearheaded complete overhaul of administrative objectives, establishing data governance and data management policies and procedures ● Defined, monitored, and addressed progress of KPIs ● Managed and mentored professional staff

St. Lawrence University

Psychology, BS•  August 2003 - May 2006

Research heavy psychology program focusing on research design, statistics, and methods.