Brandon Balcacer

Brandon Balcacer · Portfolio · 2026

Transforming Data,
Building Decisions

A New Jersey–based data analyst & builder shipping ETL pipelines, BI dashboards, and AI-assisted automations.

01About

Analyst, builder, and the occasional sprinter.

I work with data, ship pragmatic tools, and try to keep a little of everything else outside the screen.

I'm a data analyst and builder studying at Ramapo College of New Jersey. My work focuses on turning messy operational data — spreadsheets, tangled APIs, unstructured records — into clean ETL pipelines, BI dashboards, and AI-assisted automations that teams can actually run on.

At the MTA I'm engineering Python and SQL workflows that standardize 1,600+ operational records, building Power BI dashboards on top of them, and automating manual paperwork with Power Automate, Power Apps, and SharePoint.

Outside of work I'm a former NCAA track & field athlete at Ramapo (NJAC Honorable Mention All-Conference, 100m dash). I still run and lift almost daily, and I spend a lot of weekends trying new restaurants around NJ and NYC.

Brandon Balcacer — NJAC Honorable Mention All-Conference, 100m Dash.
Brandon at the MTA New York City Transit office during his Data Analytics Internship.
02Selected Work

Projects that turn data into decisions.

A small set of recent builds — production systems, AI-assisted pipelines, and analytics surfaces.

PythonAPIsClaude AIAutomation
PythonFlaskSQLitepandas
03Experience

Where I've shipped real work.

A mix of analytics, automation, and operations — bringing structure to messy data and messy systems.

  1. Jan 2026 — Present

    Data Analytics Intern

    MTA — Metropolitan Transportation Authority

    Engineered Python and SQL ETL workflows to clean and standardize 1,600+ operational records, and shipped Power BI dashboards tracking material usage, fulfillment rates, and project KPIs. Automated manual memorandum and paper tracking with Power Automate, Power Apps, and SharePoint, and applied generative AI to accelerate data cleaning and surface structured insights from raw operational data.

    PythonSQLPower BIGenerative AI
  2. 2022 — Present

    Team Member

    Target

    Covered Front-End Team Lead duties overseeing guest service, cashier management, and digital order fulfillment, diagnosing issues across 12+ POS and self-checkout systems. Picked and batched digital orders with 99% accuracy, trained new hires on fulfillment tech, and earned the Annual Performance Bonus for team contributions.

    OperationsLeadershipRetail Tech
04Toolkit

What I reach for.

The stack I use to move from question, to data, to decision.

Languages & Data

  • Python
  • pandas
  • openpyxl
  • SQL
  • DAX
  • PowerFx
  • JavaScript
  • HTML / CSS

Analytics & BI

  • Power BI
  • Tableau
  • Power Apps
  • Power Automate
  • SharePoint
  • ETL Pipelines
  • Statistical Analysis

Backend & Cloud

  • SQLite
  • Flask
  • REST APIs
  • Webhooks (HMAC)
  • AWS S3
  • CloudFront
  • IAM
  • Git

AI & Tooling

  • Generative AI
  • Prompt Engineering
  • Claude API
  • Workflow Automation
✻ Let's build something

Have a problem worth solving?

I'm open to internships, contract analytics work, and collaborations on AI-assisted tooling. The fastest way to reach me is email.

balcacerrule@gmail.com GitHub LinkedIn