Trever Ehrfurth

About Me

Hi, I'm Trever, a multifaceted engineer with a diverse skill set. My technical proficiency spans a wide range of disciplines and technology with data, networking, servers, and security at its core. I am an avid proponent for open source and self-hosting, building communities and services with complete transparency and owning your data matters. Outside of my professional pursuits, I enjoy many hobbies, including motorcycling/dirt biking, snowboarding, videography, volleyball, paintball, hiking with my dogs, and traveling.

What I Do

Data Engineer

As a data engineer for nearly a decade, I have expertise in crafting tailored cloud solutions leveraging platforms like AWS, Azure, Snowflake, Matillion ETL/DPC, and Informatica. My roles have encompassed being a system administrator for AWS/Azure instances, integrating source data from API's to ERP's and everything in between, designing ERD's and architecting EDW/ODS's, developing sophisticated and streamlined ELT/ETL process, and managing multiple clients.

Systems Engineer

I oversee diverse computer systems and infrastructure on a daily basis, ensuring uninterrupted service, peak performance, routine maintenance and updates, and robust security measures. Proactively seeking continuous enhancements, I remain focused on automating processes, integrating cutting edge tools, and staying ahead of the latest industry standards and technologies.

DevOps

I manage multiple sophisticated on-prem datacenters utilizing industry-best practices and focused on security. I maintain and automate highly available enterprise-level virtualization for a multitude of services. While at Pandata Group, I have built and maintained a documentation/wiki service, uptime monitoring service, password management service and a time entry service.

SecOps

Security is something I am passionate about. I manage a SIEM (Security Information and Event Management) system with threat detection, monitoring, and active response rules across all environments as well as an extensive security stack that monitors all logs across all devices and services for malicious activity. I gained valuable insights while working at Verosint, a cybersecurity startup specializing in open-source intelligence and fraud detection.

Companies & Cilents

Resume

Education

2022
St. Norbert College

Masters of Business Administration

2017
University of Wisconsin: Green Bay

Computer Science & German

Focus on database and information security.

Experience

2023 - Current
Pandata Group

Data Engineer Consultant

Dynamic and results-oriented Data Engineer Consultant with a proven track record of delivering innovative solutions and driving the success of diverse projects. Adept at leading DevOps and Systems Engineering initiatives, I excel in architecting cutting-edge systems dedicated to collecting, transforming, and loading data across various platforms such as Snowflake, AWS, Azure, Matillion, and DBT. My commitment to continued professional development is evident in my proactive role in expanding expertise, knowledge, and skills.

2022 - 2023
Verosint

Software/Data Engineer

As a Software Engineer/Data Engineer at Verosint, a cybersecurity startup, I played a pivotal role in enhancing Golang repositories and configuring data solutions for reporting. Proficient in creating comprehensive reports and establishing monitoring and metrics systems in Datadog, I optimized codebase performance and enhanced overall system reliability. Additionally, I conducted research and implemented cost-effective ETL tools for use with Neo4j and AWS.

2019 - 2022
Navitus

Data Engineer

In my role as an ETL/Data Engineer at Navitus, I developed modular Informatica mappings and automated load processes, overseeing the transformation and loading of 90% of company data. My responsibilities included designing and leading processes for encrypting and decrypting PHI and PII, managing workload allocation between Kanban teams, and creating innovative processes for extracting CMS exports.

2016 - 2019
Thrivent

Data Engineer

Throughout my tenure as an ETL/Data Engineer at Thrivent Financial, I utilized Informatica and Bash scripting to engineer end-to-end data solutions. I formulated SOPs, mentored interns/contractors, and oversaw quarterly disaster recovery scenarios, ensuring resilience and efficacy of data and backup systems.

2013 - Current
Teradim Tech

Owner

As the Owner of Teradim Technologies, a small technology business, I orchestrated end-to-end operations, spearheading enterprise-level security installations and demonstrating proficiency in diagnosing and resolving server and system issues. Managing a team of 1-5 employees, I maintained a client-centric approach, delivering tailored technology solutions and staying abreast of industry trends.

Data Skills

Snowflake

95%

Informatica

85%

Automation and Pipelines

95%

Architecture and Modeling

75%

Systems Skills

Containerization

80%

Compute and Storage

85%

Linux

90%

Networking

85%

Azure

75%

AWS

70%

Coding Skills

SQL

90%

Linux/Bash

90%

Python

50%

Go

30%

HTML/CSS

60%

C++

35%

Knowledges

  • AWS
  • Azure
  • Snowflake
  • Infromatica
  • Matillion
  • DBT
  • Postman
  • SSO/SCIM
  • Docker
  • Portainer
  • Kubernetes
  • Terraform
  • Ansible
  • GitHub
  • GitLab
  • TrueNas
  • Proxmox
  • Networking
  • Ubiquiti
  • NGINX
  • Wazuh (SIEM)
  • Agile

Certificates

Informatica

Master Data Management
2018

Portfolio

Youtube Homelab Feature

Featured Homelab

YouTube Videos
Homelab Setup

Homelab Setup

Homelab
Brooke & Tyler Riehl

Brooke & Tyler Riehl

Wedding Videos
Cody & Julie

Cody & Julie

Wedding Videos
Clayton & Sarah

Clayton & Sarah

Wedding Videos
Austin & Kelsey

Austin & Kelsey

Wedding Videos
Bella & Timmy

Bella & Timmy

Wedding Videos
Randy & Anna

Randy & Anna

Wedding Videos
Sam & Lindsey

Sam & Lindsey

Wedding Videos
Matt & Jen

Matt & Jen

Wedding Videos
Nathan & Morgan

Nathan & Morgan

Wedding Videos
Michael & Tammi

Michael & Tammi

Wedding Videos

Contact

Madison, WI

920-676-9725

Consulting Available