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.
Building the AI Interview Agent
A closer look at the design decisions behind the app. · Read more →
Career Journey
The evolution of data — from on-premise SQL to modern analytics
AIDS Healthcare Foundation
Senior Database Developer, Data Warehouse BI Team
Leading database development and BI reporting for the Pharmacy division of the world's largest HIV/AIDS organization. Increased report accuracy 15% through stakeholder-driven data quality fixes, engineered EDI 850 purchase order automation for 340B drug ordering, and played a key role in migrating to a new pharmacy management system.
DoubleLine Capital
Senior Database Developer
First dedicated database developer at a $90B+ asset manager. Built a unified Security Master Dataset integrating 20 real-time data sources into one source of truth for traders and analysts. Rearchitected the Bloomberg Gateway trade feed to resolve years of data inconsistencies, then reprocessed and validated 10 years of historical data.
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