Bill Hansen
Senior Database Developer | Data Architect | ETL Specialist
I build data systems that drive institutional decisions, transforming complex, fragmented data into high-performance analytical engines for high-integrity environments. My foundation is SQL Server and ETL architecture, and my current focus is learning the next generation of data tools — building the data pipelines of the future. Lately that has included AI-powered applications like the AI Interview Agent on this site.
Interview my AI persona on my technical background and experience. You can also upload a job description for transparent analysis of my fit for the position.
Career Journey
The evolution of data — from on-premise SQL to modern analytics
AIDS Healthcare Foundation
Senior Database Developer, Data Warehouse BI Team
Own the SQL Server databases and pipelines behind the Pharmacy division's ordering, pricing, and reporting systems at the world's largest HIV/AIDS organization. Re-architected a legacy order-splitting pipeline into modular, configuration-driven components, designed a regression-testing framework that validates pipeline changes against production outcomes, and built the multi-account allocation logic behind federal 340B audit tracking.
DoubleLine Capital
Senior Database Developer
First dedicated database developer at a leading asset manager, joining at ~$10B AUM and building the database practice from the ground up as the firm grew to ~$100B+. Built a unified Security Master integrating real-time and nightly batch data from Bloomberg and BNY Mellon into one source of truth for traders and analysts, and rearchitected a fragile decade-old Bloomberg trade feed into a deterministic, order-independent pipeline — then reprocessed and validated 10 years of SEC-audited history against it.
Arrowstreet Capital
Senior Database Developer
Inherited underperforming financial data pipelines at a quantitative investment firm. Refactored T-SQL queries and indexing strategies, reducing execution times by 30% and eliminating a backlog of stock forecasting data requests.
Early Career
Iron Mountain, Boston Public Health Commission, Citizens Bank
Built the foundation: secure permitting systems for BSL-3 biolabs, led major data migrations for a Fortune 500 records company, and implemented BASEL II regulatory reporting pipelines for a top-20 US bank.
Technical Skills
Data Architecture
Designing systems that scale from gigabytes to terabytes
Pipeline Engineering
Building reliable data flows across disparate sources
Analytics & BI
Turning raw data into actionable business intelligence
Cloud & Infrastructure
Certified in Azure and AWS; using Docker, Railway, and GitHub Actions for personal projects
Security & Governance
Protecting data and ensuring regulatory compliance
Development Practices
Modern tooling and collaborative workflows