Dane Wagenhoffer

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

LinkedIn GitHub

Summary

Data Specialist with a Bachelor of Science in Data Analytics from Eastern Washington University. Over 7 years of hands-on experience in IT operations, database administration, and analytics. Skilled in SQL and Python scripting for automation, custom interfaces, and data analysis, with a focus on delivering decision-ready HTML dashboards using Python/Jinja2. Proven track record of streamlining workflows and generating actionable insights in both small business and nonprofit settings.

Technical Skills

Data Engineering

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

Analytics & Visualization

  • HTML Dashboards (Python/Jinja2)
  • Data Storytelling & KPI Design
  • Statistical Analysis & Forecasting
  • Charting: Matplotlib, Seaborn

Python Development

  • Data Analysis: pandas, NumPy
  • Templating & Reporting: Jinja2
  • Forecasting: statsmodels, Prophet
  • Automation & Pipelines

Automation

  • Web Scraping: Selenium, Playwright
  • GUI Automation: PyAutoGUI
  • Process Automation & Scripting
  • API Integration

Business Systems

  • CRM Administration (Apricot)
  • Campaign Tools (Votebuilder)
  • Documentation & Training
  • Hardware/Software Troubleshooting

Development Tools

  • Version Control: Git, GitHub
  • Linux/Windows Environments
  • Technical Documentation
  • Process Improvement
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 the Apricot CRM system to boost data processing and reporting.
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.
Washington State Democrats – Everett, WA
August 2022 – November 2022
Field Organizer
  • Organized high-impact events with hundreds of volunteers and prepared major rallies tied to local canvassing efforts for Governor Jay Inslee and Senator Patty Murray.
  • Coordinated volunteer recruitment and scheduling across multiple counties during a major election cycle.
  • Leveraged Votebuilder for voter targeting, outreach, and campaign data tracking.
  • Drove volunteer engagement through high-volume outreach, including thousands of cold calls.
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

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