Data Warehouse Design
One place where all the numbers agree
Sales, operations and finance figures brought together, so two departments stop bringing two answers to the same meeting.
Photo: stux / Pixabay 
Photo: Frantichek / Pixabay
Selected work demonstrating this service.
-
Made a geographical data pipeline 50x faster
Accelerated geographical data pipeline performance by 50x by improving SQL programming and data modeling across PostgreSQL, MS SQL, and Google Cloud BigQuery.
-
Designed and ran 6 ETL/ELT pipelines
Designed, implemented, and administered 6 ETL/ELT pipelines, utilizing Google BigQuery, MSSQL, PostgreSQL, Shell scripting, PL/pgSQL, and Transact‑SQL, integrating data for efficient Python API processing.
-
Ran 100 PostgreSQL, MS SQL, BigQuery warehouses
Architected, created, and managed 100 PostgreSQL, MS SQL, and Google BigQuery data warehouse databases with primarily GIS and time‑series data, optimizing performance and scalability.
If this is the work you need done, the next step is a conversation.
Tell us the problem and we will tell you honestly whether we are the right people.
