Database Developer & Data Engineer

Bill Hansen

27+ Years in Data. Building What's Next.

Senior SQL Server Database Professional specializing in enterprise data integration, ETL workflows, and the transition to modern data engineering. Currently building data warehouse and BI solutions at AIDS Healthcare Foundation.

27+
Years in Data
6
Certifications
10+
SQL Server Versions
$90B+
AUM Supported

Career Journey

From SQL Server foundations to modern data engineering

1997 – 2008

Early Career

Iron Mountain, Boston Public Health Commission, Citizens Bank

Built foundations in database engineering, data migrations, and BASEL II reporting pipelines. Developed secure permitting systems for BSL-3 labs.

2009 – 2010

Arrowstreet Capital

Senior Database Developer

Optimized database performance for a global investment management firm. Reduced query execution times by 30% through refactored T-SQL and indexing strategies.

2011 – 2021

DoubleLine Capital

Senior Database Developer

First dedicated database developer at a $90B+ asset management firm. Built unified Security Master Dataset, rearchitected Bloomberg Gateway trade feed, and integrated multi-source data into a centralized warehouse.

2023 – Present

AIDS Healthcare Foundation

Senior Database Developer, Data Warehouse BI Team

Leading database development and BI reporting for the Pharmacy division. Improving data quality, streamlining EDI integrations, and advocating for enterprise data governance.

Technical Skills

Technologies and tools I work with daily

Databases

MS SQL Server 2000-2019SnowflakeData Warehousing

Development

T-SQLC#SSISSSRSETL/ELTStored Procedures

Cloud & DevOps

AzureAWSDockerGitHub Actions

SQL Server Tooling

SSMSWindow FunctionsCTEsExtended EventsSQL AgentDatabase Mail

Source Control

GitHubTeam Foundation ServerGit

Applications

JIRAServiceNowSentryOneRedgateVisual StudioDomo