Adam Knust, Developer in Velpen, IN, United States
Adam is available for hire
Hire Adam

Adam Knust

Verified Expert  in Engineering

Data Architecture Developer

Location
Velpen, IN, United States
Toptal 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.

Portfolio

DemandJump
Amazon Web Services (AWS), Kubernetes, Amazon Kinesis, Snowflake, Hadoop, Scala
SemanticBits
Jenkins, MongoDB, Python
Next Gear Capital
Hadoop, Python, Java, Scala, SQL Server Reporting Services (SSRS), SSAS...

Experience

Availability

Part-time

Preferred Environment

Git, Visual Studio, PyCharm, IntelliJ IDEA, SQL Server Management Studio (SSMS), 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.

Work Experience

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, Amazon 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, SQL Server Reporting Services (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

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.
2000 - 2004

Bachelor's Degree in Economics

Purdue University - West Lafayette, IN

JULY 2017 - PRESENT

Microsoft Certified Professional

Microsoft

Tools

Git, IntelliJ IDEA, PyCharm, Visual Studio, SSAS, Jenkins, Apache Maven

Storage

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

Languages

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

Frameworks

Hadoop, Spark, ASP.NET

Paradigms

ETL, ETL Implementation & Design

Platforms

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

Other

Data Architecture, Query Optimization, Software Development, Amazon Kinesis

Collaboration That Works

How to Work with Toptal

Toptal matches you directly with global industry experts from our network in hours—not weeks or months.

1

Share your needs

Discuss your requirements and refine your scope in a call with a Toptal domain expert.
2

Choose your talent

Get a short list of expertly matched talent within 24 hours to review, interview, and choose from.
3

Start your risk-free talent trial

Work with your chosen talent on a trial basis for up to two weeks. Pay only if you decide to hire them.

Top talent is in high demand.

Start hiring