Ross Carhart

Summary

Senior Data Strategist and Analytics Engineer with 10+ years of experience in data modeling, BI development, and ETL automation. Proven record of delivering multi-million dollar cost savings, optimizing data pipelines, and leading analytics teams to drive measurable business impact. Skilled at translating complex data into actionable insights across retail, media, and consumer industries — available for consulting engagements at rosscarhart.com.

Experience

Senior Data Strategist Oct 2024 – Present

Abercrombie & Fitch • Remote

Architected a comprehensive customer data model enabling marketing, decision sciences, and product teams to build KPIs, analyze campaigns, and optimize audience targeting.
Trained and mentored analysts in SQL, BI tools, and data modeling, elevating team efficiency and data literacy.
Design, develop, and maintain customer-facing and internal reporting solutions using Power BI and enterprise data platforms.
Design, build, and maintain data pipelines to ingest, transform, and load data from source systems to implement staging, analytical, and semantic layer architectures.
Build and manage curated datasets and semantic data models that support scalable reporting and self-service analytics.

Senior Analytics Engineer Apr 2023 – Oct 2024

Doner Media • Remote

Implemented a dbt project to streamline data transformation processes, increasing scalability and governance.
Automated marketing campaign data extraction using open-source platforms, reducing data acquisition costs.
Delivered client-facing Tableau and Power BI dashboards for UPS, McDonald's, CableOne, and Owens Corning, improving business insights and client satisfaction.
Optimized pipelines through code refactoring, reducing runtimes by 30%.

Senior Data Analyst Sept 2021 – Apr 2023

GNC • Pittsburgh, PA

Grew subscription business 200% by designing new KPIs to better market and measure subscription customers.
Automated reporting in Tableau and Power BI, eliminating repetitive ad-hoc requests and saving analyst time.
Built automated discontinued-product tracking to deplete inventory and reduce out-of-stock notices.
Detected and fixed bugs in inventory algorithms and marketing campaigns, improving fulfillment by 10% and reducing customer spam.
Designed A/B tests to measure marketing effectiveness and developed pipelines to monitor competitors' social, SEO, and retail data.
Managed and mentored analysts and interns.

Data Analyst Nov 2017 – Sept 2021

TruFoodMfg • Pittsburgh, PA

Created BI dashboards for executives and plant managers, enabling data-driven decision-making in factory operations.
Developed and tracked KPIs that reduced downtime by 25% and lowered operating costs by 10%.
Managed Tableau Server and ensured robust reporting through rigorous data quality processes.
Established a Quality Metric for a corporate bonus program, incentivizing employees to prioritize quality.

Data Analyst 2015 – 2017

SDC Nutrition • Pittsburgh, PA

Summary

Experience

Skills

Data & Cloud

Languages

BI & Analytics

Tools & DevOps

Expertise

Education