Dane Wagenhoffer

Lake Stevens, WA | Phone number available upon request | danefrak@gmail.com

LinkedIn GitHub

Summary

I build data systems that support homeless services across Snohomish County. At Housing Hope, I administer Apricot case management software, supporting 49 users over two years, design custom SQL databases, and create visual dashboards for housing programs. In my concurrent role as Eligibility Coordinator, I oversee resident intake, complete eligibility assessments, and maintain compliance documentation. Holding both roles simultaneously ensures I understand user needs and maintain alignment with HMIS standards.

Technical Skills

Data Engineering

  • SQL & Database Design
  • Data Modeling & Warehousing
  • ETL & Data Migration
  • Database Administration (SQLite, MySQL)

Analytics & Visualization

  • Web Dashboards
  • Data Storytelling & KPI Design
  • Statistical Analysis & Forecasting

Python Development

  • Data Analysis: pandas, NumPy
  • Templating & Reporting: Jinja2
  • Forecasting: statsmodels, Prophet
  • Charting: Matplotlib, Seaborn

Automation

  • Web Scraping: Selenium, Playwright
  • GUI Automation: PyAutoGUI
  • Process Automation & Scripting
  • Data Quality Automation
  • Rule-Based Workflow Automation

Business Systems

  • Business Process Documentation & Training
  • Hardware/Software Troubleshooting
  • Technical Documentation
  • Process Improvement

Tools & Platforms

  • Version Control: Git, GitHub
  • VS Code
  • Linux/Windows Environments
  • Microsoft Office: Word, Excel, Access
  • Apricot (HMIS-comparable Case Management)
  • VoteBuilder (Field Organizing Platform)
clipboard clip

Professional Experience

Housing Hope – Everett, WA
March, 2023 – Present
Data Specialist
  • Design and manage local SQL databases to enhance data accuracy and accessibility.
  • Develop Python-based GUI interfaces and automation scripts to streamline data entry and improve workflow efficiency.
  • Create and maintain decision-ready HTML dashboards using Python/Jinja2, providing critical insights for grants and funding.
  • Administer and optimize Apricot (HMIS-comparable case management system), improving data quality and grant/compliance reporting for the agency's client services and outcomes tracking.
  • Provide technical support and training to 49 Apricot users across the organization, troubleshooting database issues, managing user access permissions, and monitoring data quality to ensure compliance with federal HUD and Washington State Department of Commerce reporting standards.
Eligibility Coordinator
  • Oversee the resident intake process, completing documentation and follow-ups throughout move-in.
  • Guide clients through eligibility assessments and transition procedures for a smooth experience.
  • Collaborate with team members to maintain accurate resident records and support program evaluation.
  • Incorporate client feedback into process improvements for enhanced service delivery.
  • Coordinate client referrals and housing transitions across multiple agencies including Cocoon House, VASH, and Family Recovery Court, managing documentation handoffs and ensuring data continuity throughout the coordinated entry process.
Washington State Democrats – Everett, WA
August 2022 – November 2022
Field Organizer
  • Organized campaign rallies attended by Governor Jay Inslee and U.S. Senator Patty Murray, managing venue logistics, press coordination, local party coordination, and volunteer mobilization, then leading subsequent GOTV canvassing efforts to maximize voter contact impact.
  • Coordinated volunteer recruitment and scheduling across multiple counties during a major election cycle, driving engagement through high-volume outreach including thousands of cold calls.
  • Used VoteBuilder, the Democratic Party's voter file and field organizing platform, to perform turf cutting, generate walk lists and phone banks, log canvassing results, and coordinate GOTV operations across multiple counties.
  • Supervised assistant field organizer with strategic territory assignment based on geographic efficiency and local knowledge, doubling ground coverage while maintaining daily data coordination and performance tracking.
Fully Loaded Electronics – Mill Creek, WA
April 2022 – July 2022
Customer Service Representative
  • Provided technical support for specialized electronics in hospitals and correctional facilities.
  • Upon sales handoff, I owned the process end to end: prepared the machines, ensured compliance, fulfilled requested configurations, and shipped the finished systems.
  • Addressed product issues efficiently, ensuring high levels of customer satisfaction during peak periods.
Buchanan Automation – Snohomish, WA
January 2022 – April 2022
Inside Sales Representative
  • Managed key client accounts, including Amazon, while offering technical sales support.
  • Collaborated with engineering teams to troubleshoot and resolve complex technical issues.
  • Fostered strong customer relationships, contributing to client retention and repeat business.
Stratagraph, Inc. – Remote
September 2020 – June 2021
Database Administration Intern
  • Led the transition from an Excel-based system to a robust SQL database, significantly improving data integrity.
  • Collaborated on migrating data to a cloud-based platform, enhancing scalability and flexibility.
  • Developed real-time heat map visualizations for dynamic business decision-making.
Z Sport Automotive – Everett, WA
February 2016 – May 2020
Senior IT Manager
  • Oversaw daily IT operations, including hardware repairs, software troubleshooting, and network maintenance.
  • Upgraded, maintained, and deployed new hardware as needed across workstations and infrastructure.
  • Planned and installed structured Ethernet cabling to hardwire the facility, resolving Wi‑Fi reliability issues and improving network performance.
  • Led web design and site maintenance, implementing SEO best practices to grow organic traffic.
  • Planned and executed online advertising campaigns (search and social), attributing spend to revenue and optimizing ROI.
  • Captured customer source during intake interviews and recorded it in the CRM to tie leads and sales back to marketing channels.
  • Filmed and edited live-action video ads for social and online campaigns.
  • Designed motion graphics and animations for a roadside Daktronics electronic sign to drive on-site promotions.
  • Managed digital content and maintained the company website to bolster online presence.
  • Coordinated installation of security systems to safeguard company assets.

Major Projects

Education

Eastern Washington University Logo

Bachelor of Science in Data Analytics
Eastern Washington University – Cheney, WA
June 2021