Intermountain Health - Augusta, ME
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 designs, develops, and implements ETL processes, managing moderately complex projects independently. This position requires validating analysis, models, and data conversion and quality assurance processes, while providing input to define best practices and standards in database design and business intelligence solutions. The Data Architect collaborates closely with leadership and customers at the corporate level to develop integrated and standardized business intelligence solutions. In this role, the Data Architect records detailed logical and physical data models in the information repository, coordinates the publication and maintenance of these models, and facilitates database design sessions. They translate business requirements into logical and physical system designs for moderately complex projects, coordinating the physical database design and implementation process. The Data Architect also designs optimal data presentation environments for customers and works with various reporting tools. They are responsible for database performance monitoring and tuning tasks, including designing optimization and indexing schemes, developing, testing, and implementing ETL routines, and documenting business requirements and essential functionality for in-house developments. This position ensures proper integration with existing data, standards, and business processes, while providing leadership for moderately complex projects through the development of project work plans and coordination of project team efforts. The Data Architect addresses customer needs, manages expectations, and ensures system-wide integration, participating in the technical review process of designs completed by other designers. They develop, document, and deliver complex ad-hoc queries of production data as requested by business users, consulting with business users to determine needs, specifications, feasibility, and project priorities.