Developer docs
API playgroundTry for free, no card

Search company profiles

Data Warehouse Consultants

Full company profile

uuid000eatk

Namestring
Data Warehouse Consultants
Legal namestring
Data Warehouse Consultants LLC
Company typeenum
Private
Founded yearint
2004
Descriptiontext

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.

Short descriptiontext

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.

Operating statusenum
Operating
Ownership categoryenum
Headcount rangeband
1–10
akta.pro rankint
HeadquartersPittsburgh, United States
HQ citystring
Pittsburgh
HQ countrystring
United States
HQ regionstring
North America
Markets served

Serves global market

Offices1 record

Each record includes

City, Country, Type, Description, Source

Keyword5 values
data warehouse consulting, ETL development services, custom web applications, business intelligence consulting, data integration solutions
Industry3 codes
PRIMARYBPAEAHAC
Data Platforms & Modern Data Stack Services (Lakehouse, DW, MDM)
SECONDARYBPAHAEAF
Data, Analytics & AI Consulting
SECONDARYBPAEAHAA
Data Strategy & Governance Services
NAICS code2 codes
  • Custom Computer Programming Services541511
  • Management Consulting Services54161
SIC code2 codes
  • Services-Computer Programming, Data Processing, Etc.7370
  • Services-Management Consulting Services8742
Product category
Data Warehouse Consulting
Social media profiles2 records
GTM motion1 record

Each record includes

Type, Description, Source

Revenue model3 records
1Consulting Services
TypeProfessional Services
Description

Professional consulting services for data warehouse development, ETL, custom applications, training, and system redesign. Projects vary in scope and duration based on client needs.

dwconsultants.com
2Q-Integrate Software Licensing
TypeSubscription Recurring
Description

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.

dwconsultants.com
3Database Conversion Services
TypeProfessional Services
Description

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.

dwconsultants.com
Marketing channels6 records

Each record includes

Title, Type, Stage, Description, Source

Distribution channels2 records

Each record includes

Title, Type, Scope, Target buyer, Description, Source

Cost components4 values
Personnel, Operations, Technology or R&D, Marketing or Sales
Pricing details4 tiers
1Microsoft Access Database Conversions
ModelOne time/ perpetual licenseBilling cadenceMulti-year contract
Notes

Typical conversion projects range from $5,000 to $30,000 depending on complexity (number of tables, reports, and data entry forms). Analysis and estimate provided at no cost.

dwconsultants.com
2Custom Mobile Web Applications
ModelOtherBilling cadenceMulti-year contract
Notes

Simple solutions can be done for $20,000, but complex processes and integrations cost much more. Budget varies based on application goals, business processes, data collection, and functionality requirements.

dwconsultants.com
3Q-Integrate Subscription
ModelSubscriptionBilling cadenceMonthly
Notes

Free download available with limited functionality (approximately 25% of events not recorded). Licensed product provides full functionality with up to 2 IP addresses for test and production environments. Annual and monthly payment options available.

dwconsultants.com
4On-site Training Services
ModelProfessional services/ project-basedBilling cadenceMulti-year contract
Notes

Training format can be 2, 3 or 4 days depending on client needs and budget. Provided on-site to increase in-house knowledge of technical teams.

dwconsultants.com
GTM typeB2B
B2B
Offering typeServices
Services
Core offering1 text field

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.

Differentiator
Functional benefit
Problem solved
Quantifiable outcome1 of 5 values shown
  • 40% reduction in medication misplacement at Children's Hospital of Pittsburgh
+4 more records
Product overview1 text field

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.

Product and service2 records
1Q-Integrate
CategoryData Integration Software
Description

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.

2ETL Development
Scale indicator7 records

Each record includes

Type, Value, Description, Source

Partnership1 partner
Strategic tierCoreTypeTechnology or Integration
Description

Qualtrics 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.

Peers10 records
TypeDirect peer
Description

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.

TypeBroad incumbent
Description

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.

TypeBroad incumbent
Description

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.

TypeDirect peer
Description

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.

5West Monroe Partners
TypeDirect peer
Description

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.

TypeDirect peer
Description

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.

TypeBroad incumbent
Description

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.

TypeDirect peer
Description

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.

9Adastra Group
TypeDirect peer
Description

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.

10Insight (BlueMetal)
TypeBroad incumbent
Description

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

Each record includes

Headline, Details, Source

Weaknesses5 records

Each record includes

Headline, Details, Source

Competitive moat4 records

Each record includes

Type, Details

Key risks6 records

Each record includes

Headline, Details, Source

Key highlights7 records

Each record includes

Headline, Details, Source

Customer concentration

Classification, Details

Named customers13 records

Each record includes

Name, Industry, Type, Use case, Source, UUID

Segment4 records

Each record includes

Title, Type, Primary, Description, Pain point addressed, Use case, Source

Ideal customer profile4 records

Each record includes

Profile, Firmographic size, Sales motion, Sales cycle length, Buying structure, Purchase trigger, Buyer persona, Geography, Industry vertical, Primary use case, Description, Pain points, Evidence proof points, Target buyer

Technology focused
Yes
API detail
Has APIbool
Yes

Docs URL, Description

Integration3 records

Each record includes

Title, Type, Description, Source

AI maturity
App detail

Has app

Feature4 records

Each record includes

Title, Differentiator, Description, Source

Core technology
Revenue estimate
Valuation estimate
Number of profiles
Profiles2 records

Each record includes

Name, Designation, Designation category, Overview, Profile commentary, Source

No data
No data
Funding overview

Funding stage, Last funding date, Total funding USD

Funding rounds

Each record includes

Round, Amount USD, Date, Pre money valuation, Total investors, Investors, News

Investors

Each record includes

Name, Type, Date of entry, Rounds participated, Website

Funding detail is available on the Subscription and Enterprise plan.Contact sales →

M&A

Each record includes

Name, Acquisition type, Announced date, Completed date, Status, Website, News

Investment

Each record includes

Name, Round, Announced date, Lead investor, Website, News

M&A and investment is available on the Subscription and Enterprise plan.Contact sales →

Data Warehouse Consultants

Data Warehouse Consultingdwconsultants.com

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.

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 industry
PRIMARYBPAEAHAC
Data Platforms & Modern Data Stack Services (Lakehouse, DW, MDM)
SECONDARYBPAHAEAF
Data, Analytics & AI Consulting
SECONDARYBPAEAHAA
Data Strategy & Governance Services

Keywords

  • Data warehouse consulting
  • ETL development services
  • Custom web applications
  • Business intelligence consulting
  • Data integration solutions

Where Data Warehouse Consultants is headquartered

Location

Headquarters

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

  1. 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.
  2. 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.
  3. 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

ModelBillingPrice
One time/ perpetual licenseMulti-year contractMicrosoft Access Database Conversions
OtherMulti-year contractCustom Mobile Web Applications
SubscriptionMonthlyQ-Integrate Subscription
Professional services/ project-basedMulti-year contractOn-site Training Services

Go-to-market motion1 record

Distribution channels2 records

Marketing channels6 records

Data Warehouse Consultants product offering

Product offering

Core 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 profile

Named customers13 records

Segments4 records

Ideal customer profiles4 records

Data Warehouse Consultants technology and API

Technology

Technology 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 signal

Partnerships

One partnership is on record.

  • QualtricscoreTechnology or IntegrationQualtrics 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 assessment

Direct 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 presence

Data Warehouse Consultants financial estimates

Financial estimate

Revenue estimate

Valuation estimate

Data Warehouse Consultants leadership team

Management profile

Number of profiles

Profiles2 records

Data Warehouse Consultants funding detail

Funding detail

Funding 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 investment

M&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.

Unlock the full company data

50 free credits on sign-up, no credit card required.

Contact sales