Amherst College invites applications for the Database Architect position. The Database Architect is a full time, year round position, job group and level PT-4. Amherst College has profoundly transformed its student body in terms of socioeconomic status, ethnicity, and nationality, among other areas. Today, nearly one-quarter of Amherst's students are Pell Grant recipients; 45 percent of our studentsidentify as domestic students of color. Our expectation is that the successful candidate will excel at working in a community that is broadly diverse with regard to race, ethnicity, socioeconomic status, gender, nationality, sexual orientation, and religion.
The Database Architect functions in a high performing team to strategically implement best industry practices and builds best-in-class business systems for data reporting and analysis.
As a technical resource, work with colleagues in the Enterprise Applications and Systems and Network Services IT staff. Discover and analyze technical and operational requirements from College administrative offices and translate them into viable technical solutions in support of enterprise reporting. Conduct Business Process Analyses, define and validate technical and business requirements, and implement enterprise operational and business intelligence data reporting solutions, primarily in the SAP Business Objects, Tableau, and MSSQL databases in the near term. The College is moving rapidly to best of breed applications, so the data reporting solutions are expected to change as we embrace new technologies and applications in the data reporting space. Takes appropriate actions to support a diverse workforce and participates in the College's efforts to create a respectful, inclusive, and welcoming work environment.
Summary of Principal Duties and Responsibilities:
Data Reporting Systems Architecture - Conduct Business Process Analyses to discover, document and assess end-user requests, provide time estimates and prepare project plans. Plan and execute the implementation, design, security and management of enterprise operational and business intelligence reporting solutions. Support reporting infrastructure with processes, documentation, security and performance monitoring;
Database Programming and Management - Define and validate technical and business requirements. Design, create and tune database objects to support normalized and dimensional models. Promote design that extends to meet future business and technical requirements. Develop, maintain, and enhance data quality control reports and electronic monitoring. Maintain referential integrity of the databases.
Report Writing - Support Information Technology staff and technical lead staff in administrative offices to deliver effective end-user reports. Support functional departments, consultants and partners to enhance existing reports and develop specifications for new reports.
Bachelor's Degree, or 7 years of relevant experience in lieu of a degree
5-7 years of professional experience in database administration
Professional experience producing complex operational and business intelligence reporting solutions
Professional experience working with enterprise business intelligence systems
Professional experience working with an enterprise resource planning (ERP) system
Commitment to or experience working with a diverse community
Interestedcandidates are asked to submit a cover letter, resume, and the names and contact information (email and/or telephone numbers) for three professional references. Review of applications will continue until the position is filled.
Internal Number: 110197079
About Amherst College
Amherst College is a private liberal arts college located in Amherst, Massachusetts, United States. Amherst is an exclusively undergraduate four-year institution and enrolled 1,800 students in the fall of 2013.