MedStar Health
posted 3 months ago
The IS Business Intelligence Data Architect plays a crucial role in overseeing and developing MedStar Health's Enterprise Data Warehouse (EDW), data marts, and data pipelines. This position is responsible for designing and implementing database and Business Intelligence (BI) solutions that empower the organization to extract valuable insights from data. The Data Architect collaborates closely with stakeholders and subject matter experts to document requirements for data marts, dashboards, and data extracts, translating these requirements into detailed technical design specifications. Additionally, the role involves working with MedStar Health's EDW vendor to manage data warehouse data pipelines and optimize the EDW platform, ensuring that data governance and standardization practices are adhered to across the organization. In this position, the Data Architect will participate in various cross-functional activities related to data governance, standardization of data and reporting, and the utilization of BI reports across all business areas. The architect will contribute to achieving established departmental goals and objectives while adhering to departmental policies, procedures, quality standards, and safety regulations. A thorough understanding of database technologies, data integration, and BI tools is essential for success in this role. The Data Architect will create and maintain accurate design documentation for new projects and existing reporting artifacts, ensuring a comprehensive repository of data architecture and design artifacts and procedures. The role also includes operational responsibilities, such as assisting in the maintenance of the EDW data pipelines, scheduling data pipeline execution, monitoring results, and remediating any data pipeline errors. The Data Architect will lead multiple design and development projects involving various stakeholder groups, delivering cohesive data solutions that meet business, technical, and data governance requirements using the EDW and MedStar Health's enterprise reporting solutions. Establishing architectural guidelines for the data and analytics environment in areas such as scalability, security, performance, data recovery, reliability, and usability is a key responsibility, as is applying these guidelines to the design and implementation of EDW, reporting, and analytics projects. Furthermore, the Data Architect will lead development teams in building and validating data marts, dashboards, and extracts, ensuring that performance and validation tasks are executed effectively.