Database Architect
Guided by the needs of our patients and their families, Massachusetts General Hospital aims to deliver the very best health care in a safe, compassionate environment; to advance that care through innovative research and education; and to improve the health and well-being of the diverse communities we serve. The Data Warehouse team is responsible for the support and maintenance of the underlying database platforms that pull in financial, clinical and operational data from various sources in order to make that data available for consumption through reports and extracts provided to thousands of users throughout Partners Health Care system. As part of an exciting initiative, team is embarking on building state-of-the-art data warehousing environment that will make use of SQL Server 2016 and IBM Netezza platforms.
Working under the general direction of the Data Warehouse Manager within the Physician Analytics & Business Intelligence department, the Database Architect is responsible for the design, and optimization of the Massachusetts General Physician Organization’s Data Warehouses and Data Marts. This position will be actively involved in the design, review and maintenance of database structures, ETL and query optimization, and data management. This position will work collaboratively with the other Data Warehouse team members to ensure high levels of availability and accuracy
Primary Responsibilities:
• Define Data Standards and models for warehouse activities
• Design, implement and deploy complex data models (relational or dimensional) to support BI initiatives Identify inefficiencies and gaps in current data warehouses and leverage solutions
• Develop and maintain relevant documentation to ensure consistent and up to date content.
• Coordinate and work with other BI staff to develop and enforce quality assurance policies and procedures.
• Contribute to the research and selection of data warehouse products, services, protocols, and standards in support of development efforts.
• Provide second tier user support for business authors and report developers.
• Assist with the scheduling, distribution, bursting and refreshing of corporate content
• Assist other team members with design and build physical database environments from table, column, index and view definitions to storage requirements and drive spacing and growth accommodations.
• Assist other team members with Design and implementation of ETL solutions for extraction and integration of data to and from data warehouses and data marts for the purposes of reporting, decision support and analysis.
• Work on optimization and tuning of data loads, extractions and recommending appropriate procedure, query or package changes and optimizations to ensure and improve system performance and reliability
• Work collaboratively with the others on the Data Warehouse team to implement the physical data model for the development and / or production environments.
• Stay abreast of market developments, tools and strategies in the data management space
• Work with developers or vendors as necessary to resolve issues
• Work collaboratively with the BI administrator, developers and PHS IS teams to ensure BI solution accuracy, performance and to viability Work closely with developers, vendors, and people from the server, network, and SAN teams to ensure best practices for the design, integrity, and performance of systems
• Manage assigned projects and resolve or escalate issues to the appropriate level of management Evaluate existing and alternate software applications and analyze upgrade requirements and impacts
• Participate as team member in Business Intelligence initiatives as the Data Architecture expert
•
Massachusetts General Hospital offers employees comprehensive health care, generous retirement benefits designed to accommodate each employee’s personal choices and specific needs, earned time off, a fitness center, resources for child care and emergency back-up child care, “dinners to go”, Wellness Programs, PERKS discounts, Pet insurance, Subsidized MBTA Pass, Employee Assistance Program, Tuition Assistance, and MORE!
To learn more about this opportunity and apply online, click the line below:
https://partners.taleo.net/careersection/ex/jobdetail.ftl?job=3050456