Intermountain Health - Montgomery, AL
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. The Staff Data Architect validates analysis, models, and data conversion and quality assurance processes, providing input to 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 Data Architect records detailed logical and physical data models in the information repository, coordinating the publication and maintenance of these models. They facilitate database design sessions, 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 for customers, and working with various reporting tools. Additionally, the Data Architect is responsible for database performance monitoring and tuning, developing, testing, and implementing ETL routines, and ensuring proper integration with existing data, standards, and business processes. Leadership for moderately complex projects is also a key responsibility, involving the development of project work plans, resource utilization recommendations, milestone tracking, and coordination of project team efforts. The Data Architect keeps management and customers informed of progress and exceptions, assists in developing system backup and recovery plans, and addresses customer needs while managing expectations. They participate in the technical review process of designs completed by other designers and develop complex ad-hoc queries of production data as requested by business users, consulting with them to determine needs, specifications, feasibility, and project priorities.