Data Warehouse Architect
Healthcare Quality Catalyst - Salt Lake City, UT

This job posting is no longer available on Indeed. Find similar jobs:Data Warehouse Architect jobs - Healthcare Quality Catalyst jobs

Job Summary
The Data Architect participates in all aspects of the design, development, and deployment of data marts for our data warehouse solution. Our product is a comprehensive data warehouse for healthcare systems that contains clinical, financial, patient experience data integrated into a single repository for analytics. The Data Architect will also participate in analyzing the warehouse data, developing advanced visualizations, and interacting with clinical staff to empower meaningful improvements to healthcare.

Desired Technical Skills
Working knowledge of:

  • Database principles, processes, technologies and tools
  • Structured Query Language (SQL)
  • SQL Server Integration Services (SSIS)
  • RDBMS systems (MS SQL Server or Oracle)
  • Data Architecture, e.g., data modeling / data normalization, database design and tuning for On-Line Transaction Processing (OLTP) and On-Line Analytical Processing (OLAP) information systems, and relational and dimensional architectures
  • Extract, Transform, and Load (ETL) into a data warehouse
  • Data Modeling tools (Toad, ER Studio, Visio)
  • Software development methodologies including the Systems Development Lifecycle

Desired Relevant Experience

  • Any work experience in the healthcare domain will be valuable
  • Any work experience in data warehousing/analytics will be valuable

Required Functional Skills

  • Effective written and verbal communication and presentation skills
  • High comfort level interacting with colleagues and with various levels of client organizations
  • Strong sense of customer service to consistently and effectively addresses customer needs
  • Ability to deal with highly sensitive and confidential information and adhere to data security and confidentiality protocols and procedures
  • Ability to mentor other team members with lesser experience and skill sets
  • Acts independently under general direction

Primary Duties & Responsibilities

  • Perform analyses that ensure established requirements are met
  • Design and construct data structures that meet project requirements and that comply with EDW design standards and principles
  • Develop Extraction, Transformation and Loading (ETL) applications
  • Understand and implement client, project, and security requirements
  • Manage client projects and provide technical oversight; ensure assigned projects are executed efficiently and according to project requirements.
  • Ensure project deliverables comply with team and organizational standards and principles
  • Participate in development of data marts in-house using a sample data set
  • All other duties as assigned

Education & Relevant Experience

  • BS/BA in information or business-related field or equivalent relevant work experience
  • 0-5 years’ experience in technology or technology related field

Employment with HQC requires U.S. citizenship or an unrestricted work authorization. HQC does not sponsor restricted Work Visas.

About this company
Healthcare Quality Catalyst helps healthcare organizations improve patient outcomes and reduce costs through an evidence-based approach to...