Asarel Castellanos
I design the data model, write the SQL and pipelines behind it, and test whether the results hold. My economics degree and software background cover each step. At Arrow, I did this for an equipment marketplace with 41,000+ models, and used an LLM to cut seller onboarding from days to under an hour.
Open to Data Analyst roles (business intelligence, product analytics, operations analytics), Data Engineer and Analytics Engineer roles, and Full-Stack Developer or Forward Deployed Engineer roles. Based in Los Angeles, open to remote work and to relocating.
Selected projects
All projects-
howlate.la
Collecting dataRecords every LA Metro bus and train position, about 25 million updates a day, and grades each stop against the timetable.
Python · DuckDB · Google Cloud
-
Engine 13
In developmentAn early-stage physics-ragdoll co-op game for PC, built with a small team, where firefighters try to save the town while a superhero and a villain wreck it around them.
Unity 6 · C# · URP
Experience
- Arrow Data engineer and analyst
Designed the catalog data model for 41,000+ equipment models, matched seller listings to it with an LLM at 92% accuracy, and built a crawler that collects 45,000+ listings a day from 200+ sites.
Feb 2026 to May 2026 - Cal Poly Orfalea College of Business Research assistant
Studied how tariffs reach local industries with Dr. Hamed Ghoddusi, built the R pipelines and event study behind the analysis, and presented the findings to Paso Robles winery owners.
Jun 2025 to Aug 2025 - Snap Software engineering intern
Wrote BigQuery SQL to find where media quality dropped in the Stories and Spotlight pipeline, and shipped a Vue and Go tool that cut time spent on tracing tickets by 80%.
Jun 2024 to Sep 2024 - Axios Software engineering intern
Moved the newsletter signup flow from Webflow to Next.js with accessible TypeScript components, and added a honeypot that flagged 3,000+ bots in its first week.
Jun 2023 to Aug 2023 - Snap Engineering Academy Scholar
Built the React Native starter template that the 2022, 2023, and 2024 cohorts used, saving instructors about a week of setup each time.
Jun 2022 to Aug 2022
Education
- Cal Poly San Luis Obispo BS Economics, Quantitative Analysis
Econometrics, time series forecasting, statistical computing in R, regression analysis, and design of experiments.
Jun 2023 to Dec 2025