Katie Hayes | Data Consultant
Data Science, Analytics Engineering, and AI Agentic Systems
I lead the transformation of raw data into governed, well-architected datasets that drive business intelligence and strategic decision-making. Grounded in database design, automated pipelines, and delivery-focused project management, I specialize in building data systems teams can trust and scale. By enabling analytics, automation, and AI agent workflows—and translating technical complexity into clear insights and actionable narratives—I help organizations move from data ambiguity to confident, aligned decisions.
Looking for a consultant who speaks both KPIs and data documentation? Let's talk!
I hold a Master's of Science in Data Science from Texas Tech's Rawls College of Business.
In my spare time, I write about music and more.
Data Projects
I've worked on a variety of data science and engineering projects - here are a few highlights.
AI-Agent-Driven Recommendations for Bakery
I designed and prototyped a recommendations engine that utilizes a three-agent AI structure to ingest business metrics from a system like Square, and turn it into a readable daily brief with actionable business suggestions. I incorporated an Industry Profile dimension for flexibility and credibility with users.
ETL Pipeline for a Small Busines
I built a simple end-to-end pipeline for a made-up small cookie bakery. I generated source data, validated and modeled it, and created an ETL pipeline that loads into a MySQL data warehouse and feeds Tableau dashboards. The project focused on turning messy operational data into clear, business-ready insights for a small business setting.
Scraping Program for E-Commerce Data
I created a Python web scraper for my ISQS-6339 Business Intelligence class in my MS Data Science program. The script extracts detailed specs and collects data on multiple iPhone models from a university assignment webpage. Using requests and BeautifulSoup, it parses the site and child pages, then exports the data into a CSV for analysis. Read about it here!
MSDS
Master's of Science in Data Science
Texas Tech University - Rawls College of Business
GPA: 3.5
Graduated: May 2026
Certifications
SQL: A Practical Introduction for Querying Databases
Provider: IBM
Issued: May 2026
Certification ID: 1WVUZA01SRU9
Team Building and Leadership in Project Management
Provider: Microsoft
Issued: April 2026
Certification ID: RTXL4ZBR3I95
Project Management Fundamentals
Provider: Microsoft
Issued: February 2026
Certification ID: M2L4RJ211NJX
Analytics For Agencies
Provider: Kick Point Playbook
Issued: January 2025
Certification ID: M2L4RJ211NJX
Data Analytics Projects
In my previous Data Analyst role at JCT Growth, I lead reporting efforts for clients and provide ad hoc analysis for organizations ranging from a nationwide cancer nonprofit, to a fiber internet provider, to a lighting ecommerce site. Here are a few projects I worked on.
Data warehousing using Supermetrics and BigQuery
Set up cost-efficient, secure storage of clients' historical data in BigQuery
I led my team's efforts to implement a combination of Supermetrics Hub and BigQuery to transfer, query, and store our clients’ data. Read more about how we optimized our setup and why I think it's a good idea to pair Supermetrics and BigQuery for client data management.
Tableau visualization for key event analysis
Created an interactive packed bubble viz for exploring key event density by landing page
I used Google Analytics (GA4) data, accessed via BigQuery, to create a packed bubbles visualization. This visualization showcased key event counts per landing page on a website and included an interactive table that provided deeper insights.
Custom SEO "Visibility" Metric for Reporting
Helped develop and implement custom SQL-driven metric for client's SEO ranking report
I collaborated on the design and implementation of a custom SEO "visibility" metric using SQL. This metric was integrated into client reporting to provide a more nuanced view of search performance across pages and keywords.
Tools & Workflows
If you're serious enough to actually read this section... We should talk.
-
AI Agent Systems: Claude, MCPs, multi-agent workflows, RAG, dify
-
Data ETL: SQL, dbt, Python (Pandas, NumPy, Polars), Airbyte, Rudderstack, Segment
-
Modeling & Statistics: XGBoost, Random Forest, CNN, K-Means, PCA, SVM, scikit-learn, pytorch, Keras, tensorflow, R
-
Workflow Tooling & Engineering: Claude Code, Airflow, Zapier, Docker, Git, APIs/CAPIs, LangChain/LangGraph, bash
-
Business Intelligence & Analytics: Tableau, Power BI, Looker, Looker Studio, Amplitude, Optimizely, Mixpanel, Mode, Seaborn, Matplotlib, Plotly, ggplot2, Excel
-
Data Warehousing & Platforms: BigQuery, Snowflake, Databricks, Firebase, AWS Redshift, GCP
-
Business Systems & Data Sources: HubSpot, Salesforce, Shopify, Webflow, Toast, Stripe, GA4, GTM, Meta Ads, Wordpress
-
Collaboration & Project Management: JIRA, Azure DevOps, Airtable, Lucid, Trello, Notion, Miro, Figma
Testimonials
The reviews are pouring in!
