About Us

Data Warehouse Consultants is a small company with big connections in Pittsburgh. Since its start in 2004 Data Warehouse Consultants (DWC) has been developing superior data management solutions and custom applications for some of the top organizations in Pittsburgh. We are a growing, technology-based company with years of experience developing software and providing business-based technical solutions to meet our clients’ needs. Our mission has remained the same since starting our company over 20 years ago; we want to help our clients excel. 


To solve our clients’ business problems and provide superior technology solutions via custom software development and process improvement.



Data Warehouse Consultants was founded in 2004 by John Shantz, a former manager at Deloitte. He worked for Deloitte Consulting in their information technology and business intelligence practices for seven years and was one of the founding members of the public sector data warehouse practice. His specialties at Deloitte were the design and development of data warehouse systems and associated Internet applications. He helped Deloitte to grow their data warehousing practice from 2 individuals in 1997 to a $40 million practice in 2003 with 50+ consultants on dozens of projects.



Mr. Shantz’s credentials include design, development and management duties on dozens of different business intelligence initiatives in various industries across the country. He is also an accomplished program designer and programmer in many different languages and environments. John’s experience in data warehousing over nearly two decades have helped him become an authority on successful data warehouse and big data implementations.

Along with being the lead consultant on some current engagements, Mr. Shantz is also an adjunct professor at the Carnegie Mellon University Heinz School in Pittsburgh teaching graduate-level courses in Data Warehousing and Decision Support Systems. He holds a Bachelor’s Degree in Electrical Engineering from The Pennsylvania State University and a Master of Business Administration from Carnegie Mellon’s Tepper School of Business.


0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply