Nicholas Swanger

Data & AI Engineer

Building AI systems on production data infrastructure.

About

My natural curiosity brought me to software development after my formal education ended. A finance major turned self-taught developer, I started leveraging AI as an efficiency multiplier long before I had a true understanding of it. When AI advancements started to encroach on traditional BI work, I had a choice: move toward the business side or lean into the technology. I leaned in.

What surprised me the most was the creative unlock. It shifted my focus from asking “how do I write this” to thinking about “what could this be,” opening up space to explore problems I genuinely care about. This also let me apply an interest in psychology I didn't expect to find useful here: change always causes friction and resistance, and designing something that will actually be adopted is a different problem than figuring out whether it programmatically works.

Eagle ScoutGilman Scholar

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

  • Architecting a territory optimization system combining H3 geospatial clustering and constraint-based rebalancing, designed to support an agentic intervention layer where an LLM will propose configuration changes for human approval before a deterministic engine replays them, keeping every routing change reproducible and auditable.
  • Deployed a FastAPI/HTMX/FastMCP container app to Snowflake Container Services, exposing every business operation as both a REST endpoint and an MCP tool from a shared service layer, backed by a self-hosted geospatial microservice for basemap tiles and geocoding that replaced an external map vendor and was architected as reusable infrastructure for future apps.
  • Built a modular Python authentication library for Microsoft Graph using Azure app registrations and Key Vault for credential management, enabling automated email ETL, Outlook/Teams messaging, and Active Directory group management for the BI team.
  • Led Snowflake cost optimization initiative spanning usage monitoring, query optimization, and warehouse sizing, reducing team compute costs 40% and saving $100K annually.

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 and secure analytics platform across multiple business units.
  • Owned full project lifecycle for analytics solutions including requirements gathering, data modeling, report building, UAT, and documentation, leveraging data from ERP, CRM, CPM, and project management systems.

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.