Intermountain Health - Austin, TX
posted 2 months ago
The Data Architect is responsible for designing relational and dimensional databases, applying relational theory and business process analysis to develop logical data models, and converting these models into physical database objects using data modeling CASE tools. This role involves developing and implementing enterprise-level strategies and principles for the integration of enterprise information resources, defining corporate standards for data architecture, format, quality, and database design. The Data Architect also plays a crucial role in the design, development, and implementation of ETL processes. As a Staff level Data Architect, the individual will independently manage moderately complex projects and their components, validating analysis, models, and data conversion and quality assurance processes. This position requires close collaboration with leadership and customers at the corporate level to develop integrated and standardized business intelligence solutions. The Data Architect is expected to record detailed logical and physical data models in the information repository, facilitating database design sessions and translating business requirements into logical and physical system designs for moderately complex projects. The role includes coordinating the physical database design and implementation process, designing optimal data presentation environments, and monitoring database performance. The Data Architect will also develop, test, and implement ETL routines, document business requirements, and ensure proper integration with existing data standards and business processes. Leadership for moderately complex projects is a key responsibility, including developing project work plans, tracking milestones, and coordinating project team efforts. The Data Architect will also assist in developing system backup, recovery, and support plans, addressing customer needs, and managing expectations. In addition, the Data Architect will participate in the technical review process of designs completed by other designers, develop complex ad-hoc queries of production data, and consult with business users to determine needs and project priorities. This role requires a Bachelor's degree in Computer Science, Bioinformatics, Statistics, or a closely related field, along with three years of experience in database design, development, and business intelligence technologies. The ideal candidate will demonstrate flexibility, motivation, interpersonal communication skills, project management skills, and the ability to handle sensitive and confidential material while adhering to data security protocols.