Data & Analytics Engineer  ·  Open to Work

Colin Burke
Data & Analytics Engineer

I design and run production data pipelines, from API ingestion to the boardroom. Currently building the financial data infrastructure for an LA nonprofit.

2 Certifications
4 Payment APIs Integrated
3+ Projects
10+ Tools & Skills
Colin Burke
CB
Scroll to explore

The Engineer Behind the Data

I've always been fascinated by information and the ways systems are interconnected, how small changes can ripple outward, and how the right insight at the right moment can shift the trajectory of an organization. That curiosity led me to study Business Administration at the University of California, Irvine, where I came to see data as the language that underpins how businesses operate.

Since then, I've focused on becoming fluent in that language, building the data infrastructure and pipelines that keep it flowing — from ETL processes to automated reporting systems — complemented by the storytelling and executive-level presentations that translate complex information into clear, actionable decisions. Along the way, I've developed strong skills in public speaking and visual communication, crafting presentations that are both analytical and compelling.

Today, I work at the intersection of data engineering and business intelligence, building systems that provide organizations with real-time visibility into their operations. I am currently designing and deploying an automated financial reporting pipeline for a mid-sized nonprofit in Los Angeles. This system integrates multiple payment platforms into a centralized database, supported by a live dashboard and budget alert engine delivered directly to board leadership.

My skill set allows me to solve complex data challenges end-to-end, from building the pipeline to communicating insights in the boardroom. I believe that organizations equipped with the right information are positioned to make the greatest impact.

Education B.A. Business Administration UC Irvine  ·  Finance & Information Systems
Location San Jose, California
Status Open to Opportunities

Tools & Expertise

A full-stack analytics skill set — from raw data to executive presentation.

Python SQL / PostgreSQL ETL Pipeline Design dbt Docker Spark / Databricks (Delta Lake) Git / GitHub CI/CD Tableau n8n (Automation) API Integration (REST/OAuth) Claude Code React Vercel Excel
Content Production
Figma Canva Descript Adobe Premiere Pro
Strategic Analysis

Porter's Five Forces, SWOT, Blue Ocean frameworks for competitive positioning

Data Modeling

Building financial and operational models that surface actionable insights

Client Management

Managing 40+ client relationships with data-driven tracking and goal-setting

Project Management

Coordinating events, deliverables, and cross-functional teams

Public Speaking & Presentations

Consultant-level presentations delivered to stakeholders and industry leaders

Business Development

Building partnerships, sponsorships, and growing client bases from scratch

AI Literacy

Applying LLMs and AI-assisted workflows to accelerate data engineering and analysis

Data Cleaning

Transforming messy, inconsistent datasets into reliable, analysis-ready sources

Engineering & Analytics Work

End-to-end systems spanning ingestion, transformation, validation, and insight delivery.

January 2026
AI / ML Computer Vision Python

AI Face Morphing Video Effect

Developed an AI-powered video effect that seamlessly transitions between individuals' facial features using facial landmark alignment. Created for a professional photographer and featured in an art exhibition at the Los Angeles Center of Photography.

Featured in LA Times
Cited as "polished and high-tech" — February 9, 2026
Sep – Dec 2023
Excel Financial Modeling Data Analysis

Forex Arbitrage Excel Model

Built and presented an Excel model to identify arbitrage opportunities in forex trading, utilizing data modeling and financial logic to demonstrate actionable profit maximization insights. Applied in an academic setting at UC Irvine.

Academic Project
UC Irvine  ·  Business Administration

Professional Background

Data Engineer & BI Consultant (Freelance)

Los Angeles Center of Photography
Mar 2025 – Present Remote
  • Engineered a three-workflow production ETL pipeline ingesting and normalizing transactions from four payment APIs (PayPal, Authorize.net, Event Espresso, Plaid) into a centralized PostgreSQL warehouse, eliminating 30+ minutes of daily manual processing
  • Built validation and reconciliation logic comparing API transaction data against accounting records, catching misclassified vendor payouts and duplicate fee entries across 8 months and ~$400K of revenue data
  • Designed and deployed a live BI dashboard surfacing real-time KPIs and budget-vs-actual performance, presented directly to the board
  • Maintain full production infrastructure: CI/CD via GitHub, cloud hosting, dbt transformation layer, automated alert engine
Python PostgreSQL dbt APIs React CI/CD

Founder & Personal Trainer

Burke Strength / Anteater Recreation Center
Jan 2019 – Jun 2025 California
  • Founded and grew a personal training business to serve 40+ clients through effective business development, client management, and marketing strategies
  • Designed personalized fitness plans using goal-setting frameworks and data tracking to improve client health outcomes and deliver measurable progress
  • Managed all business operations utilizing Excel and efficient operational systems; created and published content using scripting, filming, and editing with Adobe Premiere Pro
Excel Business Development Data Tracking Adobe Premiere Pro Client Management

External Outreach Coordinator

Manifest (Entrepreneurship Club)  ·  UC Irvine
Sep 2024 – Jun 2025 Irvine, CA
  • Developed a sponsorship package and VC database using Notion and Canva to enable strategic partnerships and expand funding avenues
  • Delivered strategic presentations applying Porter's Five Forces, SWOT, and Blue Ocean frameworks to evaluate competitive positioning for companies like Southwest and Apple
Strategic Analysis Presentations

Academic Foundation

University of California, Irvine

B.A. Business Administration

Finance & Information Systems
June 2025
Google

Data Analytics Professional Certificate

Professional Certificate
January 2026
NASM

Certified Personal Trainer

National Academy of Sports Medicine
January 2023

Let's Connect

I'm actively seeking data engineering and analytics engineering opportunities. Feel free to reach out any time.

Based in San Jose, CA  ·  Open to remote and in-person opportunities