Ross Carhart

About

Empowering Businesses with Advanced Data Solutions

Hi, I'm Ross Carhart — a data consultant based in Pittsburgh, PA with 10+ years of experience turning complex, messy data into clear business results. I've built customer data models for a major national retailer, grown a subscription business 200% through better measurement, and automated reporting that saved analysts thousands of hours.

My core toolkit is modern data warehousing (Snowflake, Databricks), analytics engineering (dbt, Python, SQL), and BI (Power BI, Tableau). Increasingly, I help businesses put AI to work — from LLM-assisted marketing optimization to fully automated data workflows that run themselves.

I take on consulting engagements of all sizes: one-off dashboard builds, data warehouse design, ongoing fractional analytics support, or AI automation projects. If your data feels like a bottleneck instead of an accelerator, let's talk.

Services

What I Can Do for You

Data Modeling & Warehousing

Design star schemas and warehouse layers in Snowflake or Databricks that scale with your business — a single source of truth your whole team can trust.

Analytics Engineering

Build and optimize dbt projects and data pipelines that turn raw data into clean, tested, documented models — reliably and automatically.

BI & Dashboards

Create Power BI and Tableau dashboards executives actually use — from KPI scorecards to self-serve analytics that eliminate ad-hoc report requests.

AI & Automation

Put LLMs to work on real business problems: automated marketing optimization, intelligent reporting, and workflows that run without human babysitting.

Customer & Marketing Analytics

CRM data models, NPS/voice-of-customer programs, campaign measurement, and A/B testing — understand your customers and market to them smarter.

Have a project in mind?

Tell me what you're trying to do and I'll tell you honestly whether I can help — and what it would take.

Get in touch

Career

Where I've Been

Data Analyst

SDC Nutrition

2015

Data Analyst

TruFoodMfg

2017

Senior Data Analyst

GNC

2021

Sr. Analytics Engineer

Doner Media

2023

Senior Data Strategist

Abercrombie & Fitch

2024

Present

Selected Work

Projects & Case Studies

Enterprise Customer Data Model

Abercrombie & Fitch

Architected the in-house CRM analytics layer in Snowflake: a star schema centered on transactions with customer, product, and location dimensions, plus a medallion-architecture NPS pipeline built on dynamic tables — all orchestrated by a native Snowflake task DAG feeding Decision Science and Power BI.

SnowflakeSQLData ModelingPower BI

Voice of Customer Analytics

Abercrombie & Fitch

Built a source-controlled Power BI semantic model (TMDL) linking CRM customer attributes to NPS and survey responses — promoter/detractor logic, CSAT, calculation groups for period comparisons, and slicing by customer value, channel, and store.

Power BIDAXTMDLNPS

AI-Optimized Lead Generation

pittsburghdivorces.com

End-to-end client acquisition platform for a law practice: serverless lead intake on Cloudflare (Pages, Functions, D1), spam and phone validation, Google Sheets CRM sync — plus a Claude-powered Google Ads optimizer that analyzes performance daily and applies human-approved changes automatically.

CloudflareServerlessClaude APIGoogle Ads

FeedMe — AI Recipe Platform

Self-hosted, 5 households

Forked and extended an open-source recipe manager (FastAPI, SQLAlchemy, Nuxt/Vue) into a multi-household platform: cross-group recipe sharing, natural-language shopping list entry, and AI meal planning and shopping optimization powered by the Claude API. Integrated with a Home Assistant kitchen dashboard.

PythonFastAPIVueClaude APIDocker

Homelab & Self-Hosted AI

github.com/rcarhart/homelab

Proxmox-based home infrastructure replacing cloud services with self-hosted alternatives — photo backup, document management, media, smart home — plus AI agents that run scheduled audits, monitor services, and handle disaster recovery. Infrastructure as a clear, documented source of truth.

ProxmoxDockerHome AssistantAI Agents

More on GitHub

Data engineering pipelines, dbt projects, personal analytics experiments, and more — from Fantasy Premier League models to household budget analysis.

Browse repositories

References

What People Say

Pete Lawson VP of Supply Chain SDC Nutrition

Ross stands out as one of the most industrious individuals I have encountered in my professional experience. His exceptional work ethic and dedication make him an invaluable asset to any team. Furthermore, his remarkable capacity for learning and adapting is unparalleled, setting him apart in dynamic work environments.

Nicole Peduto Director of Strategic Programs GNC

Ross has proven himself to be someone who is always thinking with a consumer first mindset. He is curious with a remarkable ability to comprehend complex business challenges and devise effective solutions. Ross has been instrumental in providing clear analytics to C-suite executives and has the ability to not only share the data, but to tell the story of the data to help inform business decisions. Ross was an instrumental member of our team, always willing to jump in and help with ad-hoc requests while maintaining his day to day. He played a significant role in the overall growth of GNC subscription business and was invaluable to our team.

Transforming Data into Actionable Insights

Empowering Businesses with Advanced Data Solutions

What I Can Do for You

Where I've Been

Projects & Case Studies

Enterprise Customer Data Model

Voice of Customer Analytics

AI-Optimized Lead Generation

FeedMe — AI Recipe Platform

Homelab & Self-Hosted AI

More on GitHub

Featured Data Visualizations

What People Say

Let's Talk About Your Data