Intermountain Health - Bismarck, ND
posted 2 months ago
The Data Architect is responsible for designing relational and dimensional databases. This role involves applying relational theory and business process analysis to develop logical data models, which are then converted into physical database objects using data modeling CASE tools. The Data Architect is tasked with developing and implementing enterprise-level strategies and principles for integrating enterprise information resources, defining corporate standards for data architecture, format, quality, and database design. Additionally, the Data Architect is responsible for the design, development, and implementation of ETL (Extract, Transform, Load) processes. As a Staff level Data Architect, the individual will independently manage moderately complex projects and their components. This includes validating the analysis, models, and data conversion and quality assurance processes. The Staff Data Architect will provide input to help define best practices and standards in database design and business intelligence solutions. This position requires close collaboration with leadership and customers at the corporate level to develop integrated and standardized business intelligence solutions. The role also includes recording detailed logical and physical data models in the information repository, facilitating database design sessions, coordinating the physical database design and implementation process, and ensuring proper integration with existing data, standards, and business processes. The Data Architect will also be involved in developing, testing, and implementing ETL routines, documenting business requirements, and providing leadership for moderately complex projects.