Katie (Wojciechowski) Hayes | Data Consultant
Data Infrastructure, Analytics Engineering, and Business Intelligence
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-enabled 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'm currently working on a Master's of Science in Data Science at Texas Tech's Rawls College of Business. I'm a part-time student and will earn my degree in May 2026.
In my spare time, I write about music and more.
Data Projects
Whether in my graduate classes or in my free time, 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!
Data
Scientist
Master's of Science in Data Science
Texas Tech University - Rawls College of Business
Degree in progress - see program details
Current GPA: 3.5
Expected graduation: May 2026
(In Training)
Courses completed:
-
Statistics for Data Science
-
Scripting Languages
-
Time Series Analysis
-
Multivariate Analysis
-
Big Data Strategy
-
Big Data Security
-
Database Concepts
-
Data Technology Environments
-
Business Intelligence
-
Machine Learning
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.
-
Data Modeling & Transformation: SQL (BigQuery, PostgreSQL, Redshift), dbt, Python (Pandas, NumPy), R
-
Workflow Orchestration & Engineering: Airflow, Zapier, Docker, Git, APIs, bash
-
Business Intelligence & Visualization: Tableau, Power BI, Looker, Looker Studio, Mode, Seaborn, Matplotlib, Plotly, ggplot2, Jupyter Notebooks, Google Colab
-
Data Warehousing & Platforms: Snowflake, Databricks, Firebase, Mixpanel, Google Cloud
-
Business Systems & Data Sources: HubSpot, Salesforce, Shopify, Toast, Stripe, GA4, GTM, Segment, Mixpanel, Wordpress
-
Collaboration & Project Management: JIRA, Azure DevOps, Airtable, Lucid, Trello, Notion, Miro, Figma
Testimonials
The reviews are pouring in!
