Summary
Overview
Work History
Education
Skills
Certification
Interests
Timeline
SoftwareEngineer
Danny Beachnau

Danny Beachnau

Data Engineer
Grand Rapids,MI

Summary

Self-motivated Data Engineer with 5 years of experience. Collaborates effectively with multi-functional roles to identify and leverage areas for improvement in data systems. Bringing a comprehensive skillset ready to exploit the value of data.

Overview

6
6
years of professional experience
4
4
years of post-secondary education
1
1
Certification
7
7
Languages

Work History

Data Engineer

AllCloud
Denver, CO
02.2022 - Current
  • Lead dbt developer on two million dollar SOWs. Models data for Data Vault 2.0 and Kimball star schema.
  • SnowFlake administrator - manage compute resources, system monitoring, and access management.
  • Create, monitor, and maintain data ingestion pipelines loading millions of rows daily from source systems to a centralized SnowFlake enterprise data warehouse.
  • Produce data driven ETL pipelines for re-use across projects.
  • Develop Python scripts for automating file processing and data migration tasks.
  • Build and monitor CI/CD pipelines in Azure DevOps., GitLab, and BitBucket.

Manager of Data Analytics and Business Intelligence

Orthopaedic Associates Of Michigan
Grand Rapids, MI
11.2020 - 02.2022
  • Built and maintain entire data stack. Use Python scripts to collect data from many sources into a central data lake. Transform data using dbt. Orchestrate the ETL Process using Python and Dagster.
  • Model data using fact, dimension, and bridge tables into a star schema.
  • Automate jobs, scripts, report distribution, and data pipelines.
  • Develop intelligence-sharing dashboards, providing company-wide access to collected data using PowerBI.

Data Analyst and Warehousing Specialist

Michigan Pain Consultants
Grand Rapids, MI
04.2018 - 11.2020
  • Performed ad hoc analysis using a combination of analytical SQL queries, R (Tidyverse), and Python (Pandas, SciKit, Matplotlib).
  • Used machine learning to risk stratify patients for aberrant narcotic behaviors and activity.

Data Developer Consultant

National Committee For Quality Assurance
Washington, DC
05.2019 - 06.2020
  • Advised on best practices for development operations including CI/CD tools, coding environments, and database versioning.
  • Developed and maintained a data collection and reporting tool in R with the Shiny library hosted on ShinyServer.

Education

Bachelor of Science - Biomedical Sciences

Grand Valley State University
Allendale, MI
08.2013 - 04.2017

Skills

SQL

undefined

Certification

  • SnowPro Core

Interests

Board games

Disc Golf

Cooking

Timeline

  • SnowPro Core
05-2022

Data Engineer

AllCloud
02.2022 - Current

Manager of Data Analytics and Business Intelligence

Orthopaedic Associates Of Michigan
11.2020 - 02.2022

Data Developer Consultant

National Committee For Quality Assurance
05.2019 - 06.2020

Data Analyst and Warehousing Specialist

Michigan Pain Consultants
04.2018 - 11.2020

Bachelor of Science - Biomedical Sciences

Grand Valley State University
08.2013 - 04.2017
Danny BeachnauData Engineer