Database Architect MGPO Finance SQL Server platform exp required

GENERAL SUMMARY/ OVERVIEW STATEMENT: 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 Organizations 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 PRINCIPAL DUTIES AND RESPONSIBILITIES: Primary Responsibilities:Define Data Standards and models for warehouse activitiesDesign implement and deploy complex data models (relational or dimensional) to support BI initiativesIdentify inefficiencies and gaps in current data warehouses and leverage solutionsDevelop 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 contentAssist 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 reliabilityWork 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 spaceWork with developers or vendors as necessary to resolve issuesWork collaboratively with the BI administrator developers and PHS IS teams to ensure BI solution accuracy performance and to viabilityWork closely with developers vendors and people from the server network and SAN teams to ensure best practices for the design integrity and performance of systemsManage assigned projects and resolve or escalate issues to the appropriate level of managementEvaluate existing and alternate software applications and analyze upgrade requirements and impactsParticipate as team member in Business Intelligence initiatives as the Data Architecture expert QUALIFICATIONS: Bachelors degree in Computer Science strongly preferred (or equivalent experience)10 years of IT and Data Analysis Data Management Experience Enterprise Architecture and Enterprise Data Architecture Enterprise Data Management Data Modeling Conceptual Logical SDLC Business Process Modeling. Extensive experience in SQL Server (or Oracle) database administration in a Windows server environment required6years experience in design and development using the Cognos BI platform Business Intelligence tools Framework Manager Transformer Report Studio Analysis Studio etc.4years experience in data architecture and modelingdimensional databases normalized versus denormalized data trending data capture technologies etc.Expertise working with high volume partitioned data databases; with performance tuning and development skills; and a strong knowledge of Data Warehousing methodologies and concepts is requiredAbility to monitor and tune application SQL query performance for production applicationsDemonstrated knowledge through work experience in architecting and oversight of Data Warehouses Data Marts Operational Data Stores and associated frontend technologiesExperience in current trends in technologies tools and methods in the business intelligence space is a mustBe able to solve complex business problems through innovative technology solutions at an enterprise levelPossess relevant experience in transaction and information systems ETL and Data Integration Tools data warehouses data marts ODS MDM BPM and SOAExcellent verbal and written communication skills and willingness to act as team player; sharing information willingly and accurately. SKILLS/ ABILITIES/ COMPETENCIES REQUIRED: Supports and demonstrates the values of the Massachusetts General Hospital and the Massachusetts Physicians Organization by conducting activities in an ethical manner with integrity honesty and confidentiality.Maintains a positive openminded cando attitude. Represents a team perspective and willingness and enthusiasm to collaborate with others. Follows through on commitments and achieves desired results. Exhibits sound judgment obtains the facts examines options gains support and achieves positive outcomesHighly selfmotivated/disciplined performs role with minimal supervision notice or direction to identify and resolve problems and complete workAn expertise in MS SQL Server data warehousing and data mining concepts including but not limited to: star schemas snowflakes ETL processes dimensional modeling and reporting tools is needed Experience in SQL Server Integration Services (SSIS) is critical to success candidates must be familiar with the different data sources transformations and destinations involved with SSIS ETL. Experience with automation and configuration settings are advantageous. Understanding of business intelligence concepts as well as finance knowledge in the healthcare industry is preferred; experience with EPIC and IBM Cognos BI a plusMust be deadline oriented and able to multitask and work on multiple deliverables. Occasional support outside of normal business hours and weekends will be required. WORKING CONDITIONS: The Physicians Analytics & Business Intelligence group is located in the Charlestown Navy Yard campusThe work environment is very busy and dynamicThe employee is required to travel to any Partners facilities to attend offsite meetings.Staff is very collaborative and work together to solve issues SUPERVISORY RESPONSIBILITY:None Massachusetts General Hospital is an Equal Opportunity Employer. By embracing diverse skills perspectives and ideas we choose to lead. Applications fromprotected veterans and individuals with disabilities are strongly encouraged.