Data Management & Warehousing

1 Billion Rows of Analytics Data

A horse racing startup needed to run reports and analysis on the data they were collecting from various API sources. We setup a complete ETL infrastructure, including data warehousing built with PostgreSQL and AWS, allowing them to quickly query and pull the business insights they need.

Screenshot of a database query

Designing and Building a Project Reporting App

Our client works on something we all use but almost never see - the pipelines beneath our roads. We are helping them overhaul their text-based workflow with a React app that will allow them to document their progress and generate attractive work reports for their clients. This will save their managers hours every week and let them get back to managing.

Learn More

Postgres and SQLServer Data Migrations

How do you manage the accuracy of data migrations with a code base of 200k + lines? We made a robust set of automatic tests on the migration itself for our client that alerts us to any issues immediately and automatically. Our test suite reduced the manual testing workload and increased the accuracy of data in our databases.

Learn More
Dev Talk: PostgreSQL and SQLServer

Migrate Away From Legacy Analytics

With many years invested in a legacy analytics tool that was no longer supported, our client needed to find a replacement that would allow their business users to continue to analyze and evaluate Key Performance Indicators (KPIs) and to pull reports for organizational activities and data. We designed and built a data warehouse and developed numerous (ETL) processes to organize and move data from their operations database into the data warehouse. We built an ETL framework that shared libraries with the operations database to cut down on development time and prevent errors caused by the ETL data models and operations data models getting out of sync.

Learn More

Racing with Terraform and AWS

Racing is big in Kentucky. Whether you are into NASCAR or horse racing, KY can accommodate. One project we are working on cashes in on this sector with a data driven wagering tool using PostgreSQL, AWS, and Terraform.

Learn More