Architect, Business Intelligence Data Warehouse

Role overview

Responsibilities

• Oversee logical and physical data models, ETL scripts, metadata definitions and models, queries, and reports.
• Oversee schedules, work processes, and maintenance procedures; ensure proper backup and recovery processes.
• Supervise selection of hardware, storage, and software products.
• Lead architecture, design, implementation, and operational support of business intelligence databases and related infrastructure.

Education, training, and experience

• Education, training, and experience equivalent to a Bachelor's Degree in Computer Science and five years of recent related experience.
• Relevant experience includes data warehouse implementations; MS SQL Server DBA functions; backup and recovery; performance monitoring and optimization; disk-space utilization; and software installation and upgrades.
• Experience includes data modeling, stored procedures, triggers, views, other database objects, ETL procedures, large-scale project management, and healthcare clinical and administrative implementations.
• Prior experience building data warehouses, performing database administration, and tuning performance.

Skills and abilities

• Understand hospital settings and departmental business data needs; translate these into logical and physical data requirements.
• Understand data warehouse content and business rules that make data meaningful to users.
• Communicate effectively, program in a variety of languages, transfer knowledge, document systems, and keep technical skills current.
• Familiarity with HL7, XML, and MIS guidelines; strong IBM Cognos and Microsoft development and architecture understanding.
• Strong SQL, ETL, OLAP, metadata management, use-case analysis, conceptual, and analytical skills; knowledge of operating platforms and business domains.
• Work independently, organize priorities, and balance theory with practical realities; physical ability to perform the job.