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

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.