Manager, Data Warehouse Architecture

Schamburg, Illinois 60173

Employment Type:
Date Added:
May 13, 2015

Palace Gate Corporation is seeking a Manager, Data Warehouse Architecture for our premier client in Schaumburg, IL. This is a full-time position in the wellness industry.

Job Description

Reporting directly to the Chief Information Officer, the Manager, Data Warehouse Architecture is a hands-on role who will lead an enterprise data warehouse and act as a client-facing and internal business leader leading data exchange and reporting services.

Technical Requirements

  • Microsoft SQL Server, T-SQL
  • Microsoft Toolset: SSIS, SSAS, SSRS, BIDS
  • Modeling: ERWin (ideal)
  • Must have deep knowledge of dimensional and Data Vault modeling and the use of modeling software tools such as (ERWin)
  • Reporting/Analytics: Cognos, Tableau
  • Data Standards: HL7, ANSI X12

Duties and Responsibilities

  • Lead the development and maintenance of first-class enterprise data warehouse technologies, practices and processes
  • Lead the development and maintenance of first-class Data Exchange/ETL technologies, practices and processes
  • Assess and cultivate long-term strategic goals for technology and service development by acting as a consultant to executive management, clients and other stakeholders
  • Maintain thorough documentation of all systems, data structures and processes, including data dictionaries, entity relationship models and more
  • Work closely with application development team to develop and maintain ETL integrations with and between various proprietary and licensed business applications
  • Participate in the design of database schemas to ensure interoperability with the data warehouse and Data Exchange services
  • Work closely with the reporting and fulfillment teams to clarify needs and ensure deliverables are to their specifications and delivered in a timely manner
  • Mentor and provide leadership to junior team members

Education and Training

  • Bachelor’s degree in computer science or related field

Professional Experience

  • 5 years or more experience in a data architecture role within an enterprise data warehouse environment
  • Proven ability to analyze user requirements and subsequently design and build back-end data warehouse structures (stores, marts, cubes), ETL and front-end business intelligence applications according to specifications
  • Deep knowledge of dimensional and Data Vault modeling and the use of modeling software tools

Knowledge and Abilities

  • Strong communication, presentation, and interpersonal skills with an ability and willingness to present and consult to the management team
  • Experience managing a team and projects to requirements and deadlines
  • Ability to prioritize and execute tasks in a dynamic environment
  • Understanding of data privacy practices and laws such as HIPAA

Qualified candidates should sent their resumes to

Palace Gate Corporation is an information technology consulting firm that provides innovative staffing solutions to industry leading companies across the United States. Our experienced team uses new and unique approaches to deliver the right technology solutions and meet the most demanding enterprise needs. We strive to enable our clients to continue their success and achieve their business objectives by providing expert IT consultants. Our company approach is simple: Match the right people with the right opportunity.

Palace Gate Corporation offers full medical and dental insurance, 401(k) and match and weekly direct deposit. For more information or to view all our open jobs, please visit