Data Warehouse Consultants
Data Warehouse Consultants is a small Pittsburgh-based consulting firm that designs data warehouses, develops ETL processes, and builds custom web and mobile applications for healthcare organizations, government agencies, and educational institutions.
- Company typePrivate
- Founded2004
- HeadquartersPittsburgh, United States
- Headcount1–10
- GTM typeB2B
- OfferingServices
What Data Warehouse Consultants does
Data Warehouse Consultants (DWC) is a small, founder-owned professional services firm headquartered in Pittsburgh, Pennsylvania, founded in 2004 by John Shantz, a former Deloitte Consulting manager who previously grew Deloitte's data warehousing practice from two individuals to a $40 million, 50-consultant operation. The firm specializes in data warehouse design, ETL development, dimensional data modeling (Ralph Kimball methodology), and custom web and mobile application development. Its primary client base consists of healthcare organizations (Children's Hospital of Pittsburgh/UPMC, Children's Healthcare of Atlanta), government agencies (Allegheny County Department of Human Services, Yamhill County), educational institutions (University of Pittsburgh, Yale, Partnership for LA Schools), and a long tail of enterprise clients.
DWC's technical stack is anchored on Microsoft and Oracle data platforms — SQL Server, Oracle, SSIS, ASP.NET, C# — supplemented by Hadoop ecosystem experience (MapR, Hortonworks, Hive, HBase), Tableau visualization, and mobile web applications built on .NET Core hosted on Windows Server/IIS. Beyond consulting services, DWC has productized a portfolio of custom-built applications including Q-Integrate (a real-time Qualtrics survey event listener with REST API, sold via subscription), GeocodeIt! (geocoding via Geocode.Farm), and a suite of healthcare and government applications such as the DHS Data Exchange, Allegheny County Mental Health Bedboard, Hello Baby referral tracker, AIU TEAR Project, CVRI Rapid Response, Radiology Tracking Board, and Pharmacy Mobile Application. The firm's healthcare work was recognized by HIMSS with the 2016 Davies Award for a custom solution deployed at UPMC.
DWC operates a primarily project-based professional services model with pricing ranging from $5K–$30K for Microsoft Access conversions, $20K+ for custom mobile web applications, and multi-day on-site training engagements. Q-Integrate is the only productized, subscription-based offering, supporting both annual and monthly billing. Go-to-market is sales-led through direct client relationships, referrals, and long-term partnerships, with most work concentrated in the Greater Pittsburgh region and remote delivery available nationally. The company is bootstrapped, privately held, has no external funding, and revenue is not publicly disclosed.
Data Warehouse Consultants firmographics
Firmographics- Name
- Data Warehouse Consultants
- Legal name
- Data Warehouse Consultants LLC
- Website
- https://dwconsultants.com
- Company type
- Private
- Founded year
- 2004
- Operating status
- Operating
- Headcount range
- 1–10 employees
- Short description
- Data Warehouse Consultants is a small Pittsburgh-based consulting firm that designs data warehouses, develops ETL processes, and builds custom web and mobile applications for healthcare organizations, government agencies, and educational institutions.
- Ownership category
- akta.pro rank
Data Warehouse Consultants industry classification
Industry- Product category
- Data Warehouse Consulting
- NAICS
- Custom Computer Programming Services (541511), Management Consulting Services (54161)
- SIC
- Services-Computer Programming, Data Processing, Etc. (7370), Services-Management Consulting Services (8742)
- akta.pro primary industry
- Data Platforms & Modern Data Stack Services (Lakehouse, DW, MDM) (BPAEAHAC)
- akta.pro secondary industries
- Data, Analytics & AI Consulting (BPAHAEAF), Data Strategy & Governance Services (BPAEAHAA)
Keywords
Where Data Warehouse Consultants is headquartered
LocationHeadquarters
- HQ city
- Pittsburgh
- HQ country
- United States
- HQ region
- North America
Offices1 record
Markets served
Data Warehouse Consultants business model
Business model- GTM type
- B2B
- Offering type
- Services
- Cost components
- Personnel, Operations, Technology or R&D, Marketing or Sales
Revenue model
- Consulting Services: Professional consulting services for data warehouse development, ETL, custom applications, training, and system redesign. Projects vary in scope and duration based on client needs.
- Q-Integrate Software Licensing: Q-Integrate tool available with subscription licensing. Free download with limited functionality (25% of events not recorded). Licensed versions provide full functionality with real-time listener for Qualtrics events. Supports up to 2 IP addresses per subscription for test and production environments.
- Database Conversion Services: Conversion of Microsoft Access and Excel applications to enterprise-level architecture (ASP.NET and SQL Server or Oracle). Typical conversion projects cost between $5K and $30K.
Pricing tiers
| Model | Billing | Price |
|---|---|---|
| One time/ perpetual license | Multi-year contract | Microsoft Access Database Conversions |
| Other | Multi-year contract | Custom Mobile Web Applications |
| Subscription | Monthly | Q-Integrate Subscription |
| Professional services/ project-based | Multi-year contract | On-site Training Services |
Go-to-market motion1 record
Distribution channels2 records
Marketing channels6 records
Data Warehouse Consultants product offering
Product offeringCore offering
Data Warehouse Consultants provides specialized consulting services for designing, building, and improving enterprise data warehouses, with deep expertise in ETL (Extraction, Transformation, Load) development and dimensional data modeling. The firm also develops custom web and mobile applications for healthcare and government clients, and offers Q-Integrate, a subscription-licensed tool for real-time Qualtrics-to-database integration.
Product overview
Data Warehouse Consultants (DWC) offers a portfolio of consulting services and custom-built products centered on data warehouse development, ETL processes, and web application development. The core offerings include ETL Development, Data Warehouse Design and Improvement, SSIS Consulting, and Customized Data Warehouse Training. The product portfolio includes Q-Integrate (real-time Qualtrics-to-database integration), GeocodeIt! (address geocoding), and various healthcare and government applications including DHS Data Exchange, Allegheny County Hello Baby, Mental Health Bedboard, AIU TEAR Application, and CVRI Rapid Response. Additional products include Radiology Tracking Board, Neonatal Breastmilk Tracker, Pharmacy Mobile Application, DWC HL7 Receiver, and DWC Patient Communications Tracker. Services are built using ASP.NET, SQL Server, Oracle, and related Microsoft technologies, with specialized offerings in Big Data/Hadoop and Tableau visualization development.
Differentiator
Problem solved
Functional benefit
Products and services
- Q-Integrate A real-time database integration tool that creates a listener for Qualtrics survey completion events and records responses into Oracle or SQL Server databases. Supports both cloud and on-premise environments with up to 2 IP addresses per subscription. Sold to organizations using Qualtrics who need automated survey response capture.
- ETL Development
Quantifiable outcome
- 40% reduction in medication misplacement at Children's Hospital of Pittsburgh
- +4 more outcomes
Companies that use Data Warehouse Consultants
Customer profileNamed customers13 records
Segments4 records
Ideal customer profiles4 records
Data Warehouse Consultants technology and API
TechnologyTechnology focussed Yes
API detail
- Has API
- Yes
- API docs
- API detail
Core technology
AI maturity
App detail
Integration3 records
Feature4 records
Data Warehouse Consultants partnerships and signals
Strategic signalPartnerships
One partnership is on record.
- QualtricscoreQualtrics is the XM company providing survey software. Data Warehouse Consultants developed Q-Integrate as an integration tool that creates listeners for real-time integration from Qualtrics into customer database environments. The tool catches event notifications that users subscribe to using their Qualtrics accounts, enabling seamless integration with internal tools.
Scale indicators7 records
Data Warehouse Consultants competitors and assessment
Company assessmentDirect peers
- Slalom Consulting: Slalom is a mid-size consulting firm with a strong data, analytics, and modern data platform practice that includes data warehousing, ETL, and BI consulting for healthcare and public sector clients. Overlap with DWC is high in DW design, ETL development, and Microsoft-stack implementations.
- KPI Partners: KPI Partners is a data and analytics consulting firm focused on data warehousing, ETL, BI, and custom application development for enterprise clients. Highly comparable to DWC in boutique-style data engineering services and licensed-product offerings.
- West Monroe Partners: West Monroe runs a dedicated Data & Analytics practice delivering data warehousing, MDM, and analytics consulting to healthcare, financial services, and energy clients. Comparable to DWC in vertical focus on healthcare and government and in bespoke DW/ETL engagement style.
- Sagence: Sagence is a data and analytics consulting firm that delivers data warehousing, BI, and modern data platform solutions to mid-market and enterprise clients. Comparable to DWC in DW/ETL focus and project-based delivery model.
- 3Cloud: 3Cloud is a Microsoft-focused data and AI consultancy delivering Azure data platform, Synapse, and Power BI implementations. Directly comparable to DWC's Microsoft SQL Server and SSIS consulting focus.
- Adastra Group: Adastra is an international data and analytics consultancy with deep data warehousing, data integration, and governance offerings for regulated industries. Similar to DWC in core data platform consulting and emphasis on dimensional modeling and data quality.
Broad incumbents
- Deloitte Consulting: Deloitte is a global Big Four firm whose Analytics & Information Management practice was the prior employer of DWC's founder John Shantz, who helped grow its DW practice to a $40M business. Overlaps DWC in DW/ETL consulting for healthcare and public sector, but at vastly larger scale and broader portfolio.
- Capgemini Invent: Capgemini Invent's Insights & Data practice delivers enterprise data warehousing, data integration, and analytics consulting across industries including public sector and healthcare. Operates broadly in the same space as DWC with global scale.
- Accenture Data & AI: Accenture's Data & AI practice delivers data warehousing, cloud data platform, and analytics consulting to enterprise and public sector clients. Same broad DW/ETL consulting category as DWC but at much larger scale and across a much broader service portfolio.
- Insight (BlueMetal): Insight, through its BlueMetal division, delivers data platform, application development, and analytics consulting with strong Microsoft expertise. Provides overlapping capabilities to DWC as part of a much larger IT solutions and services portfolio.
Market position
Strengths5 records
Weaknesses5 records
Competitive moat4 records
Key risks6 records
Key highlights7 records
Customer concentration
Data Warehouse Consultants social profiles
Digital presenceData Warehouse Consultants financial estimates
Financial estimateRevenue estimate
Valuation estimate
Data Warehouse Consultants leadership team
Management profileNumber of profiles
Profiles2 records
Data Warehouse Consultants funding detail
Funding detailFunding overview
Funding rounds
Investors
Funding detail is available on the Subscription and Enterprise plan.Contact sales →
Data Warehouse Consultants M&A and investment
M&A and investmentM&A
Investments
M&A and investment is available on the Subscription and Enterprise plan.Contact sales →
Frequently asked questions about Data Warehouse Consultants
What does Data Warehouse Consultants do?
Data Warehouse Consultants provides specialized consulting services for designing, building, and improving enterprise data warehouses, with deep expertise in ETL (Extraction, Transformation, Load) development and dimensional data modeling. The firm also develops custom web and mobile applications for healthcare and government clients, and offers Q-Integrate, a subscription-licensed tool for real-time Qualtrics-to-database integration.
Is Data Warehouse Consultants a public or private company?
Data Warehouse Consultants is a private company. It is classified as founder individual operated bootstrapped and is currently operating.
When was Data Warehouse Consultants founded?
Data Warehouse Consultants was founded in 2004. It employs 1 to 10 people.
Where is Data Warehouse Consultants based?
Data Warehouse Consultants is headquartered in Pittsburgh, United States, in the North America region.
How does Data Warehouse Consultants make money?
Three revenue lines are on record. Consulting Services are the primary driver. The others are Q-Integrate Software Licensing and database Conversion Services.
Who are Data Warehouse Consultants's main competitors?
Direct peers on record are Slalom Consulting, KPI Partners, West Monroe Partners, Sagence, 3Cloud and Adastra Group. Broad incumbents are Deloitte Consulting, Capgemini Invent, Accenture Data & AI and Insight (BlueMetal).
Does Data Warehouse Consultants have an API?
Yes. Q-Integrate provides a REST API listener for real-time Qualtrics event integration. It uses POST method with x-www-form-urlencoded format to receive survey completion events. Supports Oracle and SQL Server databases with configurable connection strings. The REST endpoint is /api/qualtrics/response.
What industry is Data Warehouse Consultants in?
Data Warehouse Consultants's product category is Data Warehouse Consulting. Its primary akta.pro industry code is BPAEAHAC, Data Platforms & Modern Data Stack Services (Lakehouse, DW, MDM), with a secondary code of BPAHAEAF, Data, Analytics & AI Consulting. Its NAICS code is 541511 and its SIC code is 7370.