Career Confidence with CCG

Everything starts with our people

Microsoft Data Warehouse Architect

Looking for a company that not only encourages but pays for you to learn new Data Warehouse/ETL tools? Enjoy working with the best and the brightest in your field? Join CCG and learn more than you ever thought imaginable, while having some fun along the way.

As a CCG Consultant you are not only creating a technical solution you are helping our clients make better business decisions by leveraging structured and unstructured data, improving business efficiency and revealing answers through intuitive visualizations.

As a Microsoft Data Warehouse Architect you will be responsible for a variety of responsibilities such as design, development, documentation and quality assurance of the technical architecture of business intelligence solutions. Primarily focused on the back end architecture of a BI solution. You will work with both technical and functional business teams at client sites to deliver and manage a robust, high-quality Data warehouse solution that provides key insights for strategy and decision making.

Required Technical Skills

  • Extensive knowledge of Data Warehousing and Business Intelligence including various data modeling methodologies and techniques.
  • Experience in Gathering and analyzing business and technical requirements.
  • Knowledge of Data warehouse lifecycle
  • Expert level knowledge of the Enterprise Server technology areas: SQL Server Analysis Server (SSAS) or SQL Server Integration Services (SSIS).
  • Experience in SQL Server performance tuning and administration working with large to very large databases (multiple terabyte or larger).
  • Ability to use and explain all aspects of, relational database design, multidimensional database design, OLTP, OLAP, KPIs, Scorecards, and Dashboards
  • Ability to recommend architecture best practices related to ETL, ELT, BI, and the life-cycle of an EDW solution.

Preferred Technical Skills

  • Knowledge of other ETL tools (e.g. Informatica, Business Objects Data Services, or Data Stage) is preferred.
  • Exposure to Business Intelligence tools such as: SAP BusinessObjects, Microsoft BI Stack, IBM Cognos, Oracle OBIEE, Microstrategy, Informatica
  • Consulting Experience

Comprehensive compensation and benefits package included. All Candidates must have ability to travel up to 80% and work in the U.S without sponsorship.

Preferred Method of Contact *

How did you hear about us (select all that apply) *

Upload Resume