Data Pipelines | AI Automation | Digital Marketing Analytics

EVERYTHING IS DATA

Data analyst and BI developer specializing in the intersection of marketing analytics, data infrastructure, and applied AI. I build end-to-end systems — automated pipelines, BI dashboards, and research-driven analysis — that turn fragmented data into decision-ready insights for executive stakeholders.

01 — About

A bit about me.

Patrick Lutz headshot

Data analyst and BI developer specializing in the intersection of marketing analytics, data infrastructure, and applied AI. I build end-to-end systems — automated pipelines, BI dashboards, and research-driven analysis — that turn fragmented data into decision-ready insights for executive stakeholders.

Currently, I'm engineering an automated ELT pipeline at PlayCore that loads HubSpot CRM data from ~40 brands into Snowflake, plus a Power BI web app tracking ~120 software integrations across the portfolio. My background spans academic research, GIS analysis for municipal planning, and marketing operations for local businesses.

I'm pursuing an M.S. in Data Analytics at the University of Tennessee-Chattanooga (Expected 2027) and hold a B.S. in Economics and a SAS Statistical Programming Certificate from Florida State University.

I'm focused on leveraging AI tools, analytics software, and cross-functional collaboration to automate data workflows, enhance reporting, and translate complex business problems into scalable solutions that drive revenue goals and long-term growth.

02 — Experience

Where I've worked.

Digital Marketing Analyst

PlayCore

2026 – Present

Engineered an automated ELT pipeline that cleans, standardizes, and loads HubSpot CRM data from ~40 PlayCore brands into Snowflake, enabling cross-brand forecasting for executive stakeholders. Built a Power BI web app tracking ~120 software integrations across the corporate portfolio and documented a Snowflake Cortex AI SOP to accelerate brand onboarding.

SnowflakePower BIHubSpotCortex AI

Graduate Research Analyst

UTC Rollins College of Business

2025 – 2026

Developed a Python web-scraping pipeline collecting HTML from 260+ Tennessee municipal websites for NLP and machine-learning analysis. Published a text-mining study linking municipal language use to entrepreneurial economic activity, built an interactive GIS web app mapping walkable park access in Chattanooga, and compiled global databases supporting faculty research.

PythonWeb ScrapingGISMachine Learning

Team Lead & Digital Marketing Specialist

Public House Bar & Restaurant

2021 – 2025

Revitalized the restaurant newsletter, producing 24 monthly issues over two years and doubling subscribers and open rates within the first 12 months. Launched a customer preference survey to 15,000+ email clients, achieving a 50% response rate and producing 12+ reports reviewed by upper management.

Email MarketingSurvey ResearchReporting

03 — Toolkit

Tools I reach for.

Python

Web scraping · pandas · NLP pipelines

SQL & Snowflake

ELT pipelines · CRM unification · modeling

Power BI

DAX · KPI scorecards · web app dashboards

SAS

Statistical programming · academic specialization

ArcGIS & Tableau

Interactive maps · 8+ published dashboards

AI & Automation

Claude · OpenAI · Copilot · agentic AI workflows

04 — Selected work

Recent projects.

A sample of the case studies I've shipped during coursework, internships, and side research.

Chattanooga Park Access Map

Interactive ArcGIS web app analyzing walkable park access across Chattanooga, joining park locations with census-tract demographics to surface equity gaps.

ArcGISGISCensus Data

SQL Job Market Analysis

PostgreSQL + Tableau deep dive into the U.S. data analyst job market — top hiring industries, highest-paying roles, in-demand skills, and the best cities and states for data jobs. Full write-up with queries and visualizations.

SQLPostgreSQLTableau

Fortune 500 Excel Analysis

Excel deep dive into Fortune 500 data (2015–2023) — top industries with female CEOs in the South, top-ranked companies by revenue, and the industries showing the most consistent multi-year growth. Built with pivot tables, XLOOKUP, and conditional formatting.

ExcelPivot TablesData Cleaning

Python Movies Correlation

Jupyter notebook exploring what drives box-office gross — cleaning the Kaggle movies dataset, then using pandas, seaborn, and a Pearson correlation matrix to test budget, votes, rating, and genre against gross earnings.

Pythonpandasseaborn

Community Health Status Analysis

SAS analysis of health professional shortages using the 2009 CHSI report — data preparation, logistic regression, diagnostics, backward model selection, and original ROC comparison code. A walkthrough of my source code and findings.

SASLogistic RegressionPublic Health

Nashville Housing Data Cleaning

SQL Server cleaning workflow for Nashville housing records — backfilling property addresses, splitting street, city, and state fields, standardizing vacancy labels, and identifying duplicate sales with a CTE and ROW_NUMBER. Original queries with a step-by-step walkthrough.

SQL ServerData CleaningCTEs

Get In Touch

I'm currently exploring opportunities in AI automation, marketing analytics, and data infrastructure — and I'm always open to connecting with like-minded professionals. If you have a role, project, or collaboration in mind, I'd love to hear from you!

© 2026 Patrick Lutz. Crafted with care.

Built with curiosity and a lot of SQL.