Data Warehouse Manager

SUMMARY: Responsible for managing the Data Warehouse team. The Data Warehouse team designs, develops, and supports the AAMC Data Warehouse, the AAMC’s central data repository for research, data analysis, and enterprise reporting. The team works closely with the Business Intelligence team is responsible for enterprise reporting and/or reporting applications.

In support of these activities, the incumbent: (1) Is responsible for ensuring that users have access to the timely and accurate data compiled from AAMC and external sources they need. (2) Works with IT and non-IT managers and staff to develop and document data access, management, reporting, and retention requirements and then to implement solutions to meet those requirements. (3) Manages a team of data management professionals who construct and maintain the data processing infrastructure to integrate data into the Data Warehouse and prepare data for decision support. (4) Responsible for expanding the scope and changing the structure of the Data Warehouse in accordance with strategic goals and user requirements. (5) Maintains excellent working relationships with Data Warehouse customers" (internal AAMC staff, researchers, analysts, data stewards) and IT managers and developers responsible for the perational systems. (6) Has day-to-day responsibility for the Data Warehouse support and operations, and manages evaluation, implementation, and development projects as needed. (7) Contributes to the overall leadership of the Enterprise Information unit inside IT to ensure that activities and priorities are well coordinated. (8) Works closely with technical staff, internal AAMC program management staff, external partners' technical contacts, and, on occasion, external constituents. (9) Possesses the technical knowledge and the ability to effectively lead and manage information systems staff.

RESPONSIBILITIES:

Responsible for managing the specification, design, development, maintenance, and operation of the AAMC Data Warehouse.

Responsibilities include but are not limited to:

• Plan for and implement the expansion and enhancement of the Data Warehouse to meet the evolving data and reporting needs of the AAMC.
  
• Assure that AAMC analysts and researchers have access to the data they need in an efficient form and that all data access policies are supported and enforced.
  
• Provide positive, pro-active, thoughtful, and timely customer service to AAMC programs and staff.
  
• Establish and maintain high levels of end-user satisfaction.
  
• Assure that the Data Warehouse is current, reliable, accurate and well documented.
  
• Establish and support data retention requirements for operational systems.
  
• Gather and further define project requirements.
  
• Develop methods, procedures and quality objectives including metrics for assessing progress.
  
• Participate in IT management activities to include visioning, planning, and budgeting.
  
• Manage projects effectively in accordance with published standards and processes.
  
• Develop and maintain a productive working relationship with project sponsors, vendors and key clients.
  
• Evaluate commercial products and make build or buy recommendations.
  
• Supervise and evaluate permanent staff. Develop and foster an effective and motivated team. Encourage leadership and professional growth in project team members as appropriate.
  
• Oversee the hiring process for positions directly supervised, making hiring and salary recommendations.
  
• Participate on AAMC cross-functional teams as needed

• Bachelor’s degree in relevant field required, plus a minimum of 8 years of relevant experience.
  
• 5 years combined project management or supervisory experience required.
  
• Demonstrated analytical and diagnostic skills required.
  
• Familiarity and experience with data warehousing, business intelligence, and reporting software required.
  
• Programming and design experience in both database and software development required. Experience with Oracle database and SAP Business Objects software strongly desired; XML and Web development useful.
  
• Prior experience in technical writing, quality assurance, or business analysis desirable.
  
• Knowledge and prior experience in social science research preferred.
  
• Knowledge and prior experience in the business operations, organization, and administration of medical schools and/or academic health centers useful.
  
• Excellent oral and written communication skills required including ability to make effective presentations, create project documentation artifacts, and interact effectively in negotiations and team settings serving multiple levels of constituents.