Nicholas Swanger

Data & AI Engineer

Building AI systems on production data infrastructure.

About

Data & AI Engineer based in Charlotte. Currently BI Developer II at Coca-Cola Consolidated — the title says BI, but the work is data engineering with AI applications, most recently a conversational agent layered on an ML-driven territory optimizer. Outside work, I'm building a recipe-generation SaaS (RAG + Anthropic API) and a native workout tracker. Eagle Scout, Gilman Scholar, and University Innovation Fellow at Stanford somewhere earlier.

Projects

AI / MLIn Development

Recipe SaaS

AI-powered recipe generator using RAG, vector embeddings, and Claude. FastAPI backend with Postgres + pgvector, Voyage AI embeddings, and Anthropic API integration.

PythonFastAPIAnthropic APIpgvectorDocker
AI / MLIn Development

Workout Tracker

Native mobile workout tracker built with React Native and Expo. SQLite for local persistence. On-device AI for personalized training recommendations is the next planned milestone.

React NativeExpoTypeScriptSQLite

Career

BI Developer II, Data Products & Analytics

Sep 2024 – Present

Coca-Cola Consolidated Inc.Charlotte, NC

  • Designing an ML-powered territory optimization system using k-means seeding and constraint-based rebalancing, with active development toward a conversational agent enabling the sales team to query territory data and surface customer insights interactively.
  • Architected a modular Python authentication library for Microsoft Graph API leveraging Azure app registrations and secure credential management via Key Vault, enabling automated email ETL and Active Directory management across enterprise workflows.
  • Led Snowflake platform cost optimization implementing usage monitoring, query tuning, and warehouse right-sizing, reducing compute costs by 40% and delivering $100K in annual savings.

Business Systems Analyst

Jan 2023 – Sep 2024

TransTech EnergyCharlotte, NC

  • Designed and implemented Power BI service architecture including workspace strategy, app deployment model, and access governance, establishing a scalable analytics platform across multiple business units.
  • Owned full project lifecycle for analytics solutions — requirements gathering, data modeling, report building, UAT, and documentation — leveraging ERP, CRM, CPM, and project management data sources.

Education

BBA: Finance · Summa Cum LaudeDec 2023

University of North Florida

Certificate: International BusinessJul 2021

Universidad de Alicante, Spain

Skills

AI & ML

LLM applicationsAgentic workflowsRAG pipelinesML optimizationGitHub CopilotClaude Code

Data Platforms

SnowflakeMicrosoft Fabric / Foundry

Dev Practices

Modular architectureGitCI/CDDevOps pipelines

BI & Reporting

TableauPower BISigmaStreamlit

Get in touch

Open to AI engineering roles, project collaborations, and interesting conversations.