JH.

Data warehouse & BI developer · Omaha, Nebraska

James Hawkinsturns data into decisions.

I’m a senior computer science student at the University of Nebraska–Lincoln and a data warehouse developer intern at the Nebraska Department of Transportation, where I document enterprise databases and build the reports state teams run on. On my own time I build data pipelines, most recently an always-on scanner for prediction markets. I graduate in May 2027 and I’m looking for full-time data and BI roles. I’m based in Omaha and always willing to relocate for the right job.

See projects GitHub LinkedIn
dbo.james_hawkins1 row
James Hawkins in a dark blazer and white shirt, smiling outdoors in front of pine trees photo · varbinary(max)
PKnamevarcharJames Hawkins
rolevarcharDW Developer Intern
employervarcharNebraska DOT
schoolvarcharUNL · CS ’27
gpadecimal(4,3)3.921
schemas_documentedint244
reports_builtint100+
seekingvarcharFull-time roles
relocatebit1
244schemas documented in ER/Studio
100+BI reports built for NDOT
8NDOT districts supported
222unit tests on my scanner project

Experience

Two years inside a state agency’s data

Both roles at the Nebraska Department of Transportation, first on the network and support side, now in the data warehouse.

Data Warehouse IT Applications Developer Intern Current

Nebraska Department of Transportation

May 2025 – Present
  • Documented 3 statewide enterprise database structures and data models in ER/Studio, covering 244 schemas so the Data Warehouse team could organize and understand its servers.
  • Built and optimized 100+ business intelligence reports for business groups across NDOT with Microsoft Report Builder and SQL Server Reporting Services (SSRS), improving understanding and resource allocation.
  • Wrote T-SQL queries, views, and stored procedures that supply reporting datasets for Report Builder reports and Power BI dashboards.
  • Managed SSRS report storage and permission groups to control which business users can access each report.
  • Created process flow diagrams of how data moves through the state’s Workday systems, making data lineage visible to technical and business teams.
  • Analyzed large datasets in Excel to find trends and validate data across sources.
  • Used Git and Azure DevOps for version control and change tracking within an Agile sprint process.
T-SQLSSRSReport BuilderPower BIER/StudioAzure DevOpsExcel

Unified Communication Technology Intern

Nebraska Department of Transportation

Apr 2024 – May 2025
  • Supported network services and end users across all 8 NDOT districts, mapping networks in Visio.
  • Resolved 50+ statewide technology incidents and service requests through the Service Portal ticketing system.
  • Improved data quality in the Lucity Asset Management System by adding, updating, and reorganizing NDOT asset records.
VisioLucityService Portal

Projects

Things I’ve built outside the day job

Personal projectOct 2026 – PresentPython · SQLite · Linux

Kalshi–Polymarket Arbitrage Server

Kalshi and Polymarket US often list the same real-world question, like which party wins the House, at slightly different prices. This server watches both exchanges around the clock, works out which contracts truly settle on the same outcome, and flags price gaps that would still be profitable after fees and order-book depth. It is read-only by design: it records, analyzes, and paper-trades, and never places a real order.

1 · Ingest REST catalog WebSocket books FIX market data
2 · Match Up to 3,000 markets Settlement-rule review
3 · Validate Fees & depth Data freshness Contract terms
4 · Output SQLite snapshots Paper trades · 8 strategies

Live, always-on pipeline

Ingests order-book data from both exchanges through REST, WebSocket, and FIX feeds, runs as a hardened Linux service, and logs snapshots to SQLite so any moment can be replayed.

Validation before any signal

An opportunity only counts if contract rules match, the data is fresh, and the book is deep enough after conservative fee math. A paper simulator tests 8 strategies without risking money.

Built with AI as a force multiplier. I used Claude and ChatGPT to plan the architecture, write and debug code, and scale a solo idea into about 7,300 lines of Python backed by 222 unit tests. Every piece of AI-generated code was reviewed and tested before it ran on the server.

Python 3.11SQLiteWebSocketFIX protocolsystemdClaude CodeChatGPT
Senior design · 5-person Agile teamAug 2026 – PresentUnity · C# · Meta Quest

Nebraska Trucking Association VR Game

A virtual reality game on Meta Quest where players work through hands-on truck maintenance: changing a tire, fixing the coolant system, and replacing a headlight. I joined an existing codebase and focused on making the physical interactions feel right.

  • physics
    Two-handed tire carryingA heavy-tire physics material so the tire handles with real weight and needs both hands.
  • input
    Entering the cabPlayers get in and out of the truck by grabbing the door handles.
  • bounds
    Play-area boundariesBarriers that push players back into bounds across all 4 scenes.
  • state
    Tool respawnTools dropped in the coolant scene return when they hit the floor.
UnityC#XR Interaction ToolkitMeta QuestGit

Skills

Toolkit

Green-outlined tools are ones I use every week at NDOT.

Data & BI reporting

SQL Server (SSMS)T-SQLSSRSPower BIReport BuilderExcel

Modeling & documentation lineage

ER/StudioVisioProcess flowsRelational designData warehousing

Languages & tools build

PythonC#HTML/CSSJavaScript (React)GitAzure DevOpsUnityLucity

AI tools assist

Claude CodeChatGPTGitHub CopilotMicrosoft Copilot StudioPrompt engineering

Education

University of Nebraska–Lincoln

Degree
Computer Science, minor in Entrepreneurship
Program
University Honors Program
Graduates
May 2027
GPA
3.921

Relevant coursework

  • CSCE 310Data Structures & Algorithms
  • CSCE 423Design & Analysis of Algorithms
  • CSCE 361Software Engineering
  • STAT 380Statistics & Applications
  • CSCE 443Cybersecurity: Big Data & CloudIN PROGRESS

Honors & leadership

  • Regents Scholarship recipient
  • College of Engineering Dean’s List, every semester from Fall 2023 to Spring 2026
  • Kappa Sigma Fraternity, Alpha-Psi Chapter: Vice President and Lead Academic Chair
  • Kappa Sigma Outstanding Brother Award
  • Completed the Global Career Accelerator web development track

Network

Where we might cross paths

If you’re a Creighton Prep alum, a fellow Husker, or a Kappa Sigma, I’d especially like to hear from you.

High school

Creighton Preparatory School

Omaha, Nebraska · Graduate

University

University of Nebraska–Lincoln

Computer Science · Class of 2027

Fraternity

Kappa Sigma, Alpha-Psi Chapter

Vice President · Lead Academic Chair

Contact

Hiring a data or BI developer? Let’s talk.

I’m looking for full-time roles starting after I graduate in May 2027. I’m based in Omaha, Nebraska, and I’m always willing to move for work. Email is the fastest way to reach me.

GitHub LinkedIn