×
Danny Beachnau

Danny Beachnau


Grand Ledge, Michigan

Background


About

About

Results-driven Data Architect with expertise in designing and implementing solutions tailored to meet business goals. Proficient in ETL processes, Matillion, dbt, SnowFlake, and AWS. I have helped over a dozen clients, both as an independent contractor and as a Data Engineer at AllCloud. Working in the consulting space, I have solved a large variety of challenges including: massive data sets, low latency requirements, inconsistent data producers, and sensitive data.

Work Experience

Work Experience

  • Cloud Data Architect, 

    Feb, 2022 - Present

    Technical lead on client engagements delivering quality solutions in areas of machine learning, large language models, and data warehousing.

    • Designed many large language model applications including an email parser that converts email threads to automated workflows, internal assistant for creating and managing Jira boards, and an internal chatbot that utilized RAG against company documents.

    • Successfully completed 6 AWS MAP Assess programs for clients encompassing a variety of industries including finance, healthcare, and transportation.

    • Overhauled a client's existing machine learning infrastructure on AWS utilizing SageMaker ecosystem. Client saw improvements in their overall spend and ability to manage a growing number of production machine learning models.

    • Authored best practices and delivery 'playbooks' in areas of AWS, ETL, Matillion, dbt, SnowFlake, CI/CD, and DataOps.

    • Leveraged Kimball modeling techniques to build out information marts for enterprise clients.

    • Created CI/CD pipelines for SnowFlake administration scripts and dbt core deployments.

    • Reduced greenfield SnowFlake RBAC deployments from days to minutes.

    • Reduced SnowFlake credit consumption by optimizing dbt models resulting in a 75% reduction in spend.

  • Manager of Data Analytics and Business Intelligence & Independent Consultant, 

    Nov, 2020 - Feb, 20221 year 3 months

    Sole data engineer responsible for delivering daily analytics for the executive board and upper management.

    • Built an effective data warehousing solution for a medium sized organization on a 0$ budget.

    • Modeled data to optimize for analytics use-cases using dbt.

    • Orchestrated data pipeline using Dagster.

    • Created financial, operational, and executive dashboard in PowerBI.

  • Data Analyst and Warehousing Specialist, 

    Apr, 2018 - Nov, 20202 years 7 months

    Completed data analytics engineering work for a mid-sized pain management practice.

    • Consolidated multiple EHR systems into a central data warehouse.

    • Performed large-scale data conversions including the transformation of prescription free-text data into standardized formats for integration into opioid monitoring and compliance programs.

    • Developed data exploration dashboards enabling self-service analytics.

Skills

Skills

  • AWS

    Redshift

    Lambda

    S3

    Glue

    SageMaker

    Athena

    Quicksight

    DynamoDB

    SQS

    SNS

  • Programming Languages

    Python

    SQL

    TypeScript

    R

  • Large Language Models

    LangChain

    Haystack

    Embeddings

    Vector Storage

    Agents

    AWS Bedrock

  • Modern Data Stack

    dbt

    Snowflake

    Matillion

    PySpark

    Kimball

Education

Education

  • Biomedical Sciences, Bachelor of Science, Grand Valley State University

    Aug, 2013 - Apr, 2017

Certificates

Certificates