Adam Knust, Data Architecture Developer in Velpen, IN, United States
Adam Knust

Data Architecture Developer in Velpen, IN, United States

Member since June 18, 2020
Adam is an experienced and successful data architect and engineer, having led the BI practice for a $4 billion company and three successful data warehouse and business intelligence implementations. Along with RDBMS platforms, Adam has Spark, Hive, and Sqoop experience on Hadoop with Java, Python, and Scala. As a former business manager, he communicates very well with all levels and picks up on the business domain extremely fast.
Adam is now available for hire

Portfolio

Experience

Location

Velpen, IN, United States

Availability

Part-time

Preferred Environment

Git, Visual Studio, PyCharm, IntelliJ, SQL Server Management Studio, Microsoft SQL Server

The most amazing...

...thing I've single-handedly built is two data warehouses and BI solutions from requirements gathering to production delivery.

Employment

  • Data Architect

    2019 - PRESENT
    DemandJump
    • Designed and modified ETLs to support business use cases.
    • Built stored procedures to automate account creation in the application back end.
    • Designed new integrations to integrate, transform, and load Bing Ads data into a star schema.
    Technologies: Amazon Web Services (AWS), Kubernetes, AWS Kinesis, Snowflake, Hadoop, Scala
  • Data Architect

    2018 - 2018
    SemanticBits
    • Provided lift for the analytics and reporting wing of a new federal system that was coming online.
    • Built ETL from Mongo into Postgres.
    • Designed system integrations.
    • Built ETL processes using Python.
    • Helped build automated CI/CD pipelines.
    Technologies: Jenkins, MongoDB, Python
  • Manager of Data Engineering

    2015 - 2018
    Next Gear Capital
    • Architected a state-of-the-art data warehouse and ETL process on the 2016 Microsoft SQL Server stack for a $4 billion financial services company.
    • Sunsetted an archaic BI platform in favor of modern, feature-rich technologies and more lean, enterprise-grade processes.
    • Migrated all code into Git and automated deploys through Bamboo scripts.
    • Served as engineering lead on our Release Train team, which encompassed five teams of developers.
    • Hired, trained, and mentored three teams of developers.
    Technologies: Hadoop, Python, Java, Scala, SSRS, SSAS, SQL Server Integration Services (SSIS), SQL Server 2016
  • Developer

    2014 - 2015
    Next Gear Capital
    • Supported modifications to the sales data warehouse via T-SQL stored procedures to account for new and updated KPIs and org structure.
    • Updated existing risk and KPI applications in C# and ASP.NET.
    • Developed extracts and transformations from Microsoft Dynamics GP accounting platform.
    • Developed third-party integrations to support periodic information transfer.
    • Mentored junior developers.
    Technologies: ASP.NET, C#, SSAS, SQL Server Integration Services (SSIS), SQL Server 2008
  • Manager of Data Analytics

    2013 - 2014
    IU Health
    • Oversaw data collection of ICD, CPT, and other clinic data points.
    • Developed an ETL process to extract data from our EMR and schedule solutions to analyze outcomes and costs of onsite clinic solutions.
    • Developed costing models to prove cost overall savings of onsite clinics against traditional primary and immediate care strategies.
    • Developed a reporting solution for the interface with the data warehouse to generate reports for clients.
    • Helped effect change with our occupational health partners by sharing best practices and operational trends.
    Technologies: Python, Talend, PostgreSQL
  • Strategic Data Manager

    2012 - 2013
    Purdue University - College of Agriculture
    • Translated the strategic plan into objective metrics.
    • Developed ETL processes to extract data from the siloed data sources to bring together in a comprehensive data warehouse.
    • Provided KPI reporting to the deans and department heads, which was used to make data-based decisions.
    • Served as an information resource for state and federal audits.
    • Served as the primary functional analyst for Purdue's enterprise data warehouse initiative.
    Technologies: SQL Server 2008 R2

Experience

  • NextGear Capital Enterprise Data Warehouse

    Modern Data Warehouse platform and process to support a $4 billion financial services company. The initial sub-project was a broadly scoped revenue data mart, which provides detailed insight into revenue across all aspects of the business. It also supports product decisions including risk-based pricing. Technologies used were SQL Server 2016, SSIS, SSAS, and Tableau.

  • NextGear Capital Report Modernization

    Sunset the IBI WebFOCUS platform, which only supported tabular reporting, and instituted Tableau, SSAS, SSIS, and SSRS 2016 to support the differentiated information needs of our executives, operations teams, sister companies, and third parties. We also revamped the requirements gathering process to better scope the business problem so that devs could implement the correct solution (i.e., dashboards, mobile reports, standard PDF reports, etc...).

  • IU Health - Client Reporting Standardization

    Client reporting had historically been very manual, tedious, and error-prone. To solve these problems, I built a complete data warehouse and reporting solution to automate information collection and reporting so that effort could be spent on commenting and elaborating on the report for our clients.

  • Purdue - Strategic Plan and Departmental KPI Reporting

    The College of Agriculture had a number of initiatives outlined in its strategic plan; however, they had no means to measure success. To solve this, we had to work together to identify objective measures that mapped to each initiative, then collect that information from the disparate systems that housed this data across the university. Then I developed processes to extract and bring this data together so that automated reports could be built and provided for data-driven decisions.

Skills

  • Languages

    SQL, Java, C#, Snowflake, Scala, Python
  • Storage

    Microsoft SQL Server, SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), SQL Server Management Studio, SQL Server 2016, SQL Server 2008, SQL Server 2008 R2, PostgreSQL, MongoDB, Database Replication, Database Administration (DBA)
  • Other

    Data Architecture, Query Optimization, Software Development
  • Frameworks

    Hadoop, Spark, ASP.NET
  • Tools

    Git, IntelliJ, PyCharm, Visual Studio, SSAS, SSRS, Jenkins, Maven
  • Paradigms

    ETL, ETL Implementation & Design
  • Platforms

    Linux, Azure, Databricks, Talend, AWS Kinesis, Kubernetes, Amazon Web Services (AWS), Windows, MacOS

Education

  • Bachelor's Degree in Economics
    2000 - 2004
    Purdue University - West Lafayette, IN

Certifications

  • Microsoft Certified Professional
    JULY 2017 - PRESENT
    Microsoft

To view more profiles

Join Toptal
Share it with others