Dane Wagenhoffer

Lake Stevens, WA | Phone number available upon request | dane@danewagenhoffer.com

LinkedIn GitHub

Summary

I build Python applications, SQL databases, and automated reporting tools that help staff manage information and deliver services. At Housing Hope, I developed an internal case-management application used by 30+ staff and administer Apricot, providing training and support to 50+ users. My work in housing eligibility gives me firsthand knowledge of the staff workflows, resident needs, and compliance requirements these systems must support.

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
  • Built an internal case management application used by 30+ staff, bringing documentation, caseload reporting, deadline monitoring, and client service-hour tracking into one interface.
  • 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 over 50 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 an assistant field organizer with strategic territory assignments based on geography and local knowledge, doubling daily ground coverage by running canvasses at two locations while maintaining data coordination and performance tracking.
Fully Loaded Electronics – Mill Creek, WA
April 2022 – July 2022
Customer Service Representative
  • Configured Xbox, PlayStation, and Nintendo Switch consoles for hospitals and correctional facilities, preinstalling games, disabling network access through proprietary procedures, and applying parental controls where required.
  • Managed post-sale setup and fulfillment, checking each console's startup and operation before shipping it to the customer.
  • Supported customers when consoles or games stopped working or downloadable content was unavailable, arranging hardware returns for hands-on repair.
Buchanan Automation – Snohomish, WA
January 2022 – April 2022
Inside Sales Representative
  • Handled orders for valves and other industrial automation parts across six assigned customer accounts, including Amazon, using an AS/400 system to enter purchase orders and apply discounts.
  • Answered customer calls, routed specialized product questions to engineering, and coordinated order requests with outside sales and warehouse/shipping.
Stratagraph, Inc. – Remote
September 2020 – June 2021
Database Administration Intern
  • Worked with a team to move mud-drilling and location data from multiple Excel spreadsheets into a database, replacing a spreadsheet-based process that had become difficult to manage.
  • Helped move the database to Microsoft Azure, making the data available across sites.
Z Sport Automotive – Everett, WA
February 2016 – May 2020
Senior IT Manager
  • Supervised one IT staff member while managing day-to-day technology support, including computer repairs and upgrades, software troubleshooting, and network maintenance.
  • Planned and installed structured Ethernet cabling to resolve unreliable Wi-Fi connections and coordinated installation of the shop’s security systems.
  • Designed and maintained the company website and implemented SEO improvements, achieving first-page search placement for local terms including “Everett auto repair.”
  • Managed search and social advertising campaigns, using website traffic and customer-source information recorded in the CRM to evaluate marketing channels and refine targeting.
  • Filmed and edited video advertisements and created motion graphics for social campaigns and a roadside Daktronics electronic sign.

Major Projects

Side Projects & Open Source

Education

Eastern Washington University Logo

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