Looking for a job

Derek Kammerer

@derekkammerer

Business intelligence engineer at Cardinal Financial who migrated hundreds of legacy SQL transformations to Amazon Redshift.

United States

Message

At Cardinal Financial Company, Limited Partnership, I led the migration of hundreds of legacy SQL queries and stored procedures from MySQL to Amazon Redshift. I added data integrity checks against legacy results before release, helping catch issues before they reached finance and compliance users.

I also built AI-powered agents with Claude, Cursor, and ChatGPT to interpret legacy schemas and automate transformation work. Earlier at Cardinal Financial, I owned ETL pipelines integrating financial and operational data, and built dashboards for finance, operations, and leadership.

Experience

Work history, roles, and key accomplishments

Senior Business Intelligence Engineer

Cardinal Financial Company, Limited Partnership

Apr 2025 - Aug 2026 (1 year 4 months)

Built AI-powered agents using Claude, Cursor, and ChatGPT to automate SQL transformation work, enabling dozens of validated model migrations per day. Led the refactor and migration of hundreds of legacy queries into Amazon Redshift and designed data integrity checks against legacy results.

AI Agent Development Claude Cursor ChatGpt SQL Amazon Redshift Data Migration Data Integrity Looker Palantir Foundry QuickSight

Business Intelligence Engineer II

Cardinal Financial Company, Limited Partnership

Mar 2020 - Apr 2025 (5 years 1 month)

Owned ETL pipelines end to end, integrating financial and operational data from Fannie Mae, Freddie Mac, Wells Fargo, and Velocify into unified analytical tables. Built 30+ Looker and Looker Studio dashboards for finance, operations, and leadership.

ETL SQL MySQL BigQuery Looker Data Modeling Amazon Redshift Fannie Mae Freddie Mac Wells Fargo Velocify

Business Intelligence Operator

Cardinal Financial Company, Limited Partnership

Dec 2018 - Mar 2020 (1 year 3 months)

Supported enterprise ETL and reporting workflows, validated financial data, and built deep expertise in source data structures and lineage that later supported modernization efforts.

ETL Data Validation SQL Data Lineage

Technical Support Specialist

Hitachi Healthcare America, Informatics Division

Sep 2017 - Dec 2018 (1 year 3 months)

Delivered Tier 1 and Tier 2 customer support across Linux, PostgreSQL, and imaging software, troubleshooting issues and coordinating onboarding and cloud deployments.

Linux PostgreSQL Customer Support Troubleshooting cloud deployment