Skip to Main Content

Data Warehouse Architect

Below you will find the details for the position including any supplementary documentation and questions you should review before applying for the opening.  To apply for the position, please click the Apply for this Job link/button.

If you would like to bookmark this position for later review, click on the Bookmark link.  If you would like to print a copy of this position for your records, click on the Print Preview link.

Posting Details

Posting Details

Position Number: 124820
Title: Systems Analyst
Functional Title: Data Warehouse Architect
Category Status: 34-Exempt Contingent Category 1
Applicant Search Category: Staff
University Authorized FTE: 1.0
Unit: LIBR-Libraries
Hiring Range Minimum:
Hiring Range Maximum:
Campus/College Information:

Founded in 1856, University of Maryland, College Park is the flagship institution in the University System of Maryland. Our 1,250-acre College Park campus is just minutes away from Washington, D.C., and the nexus of the nation’s legislative, executive, and judicial centers of power. This unique proximity to business and technology leaders, federal departments and agencies, and a myriad of research entities, embassies, think tanks, cultural centers, and non-profit organizations is simply unparalleled. Synergistic opportunities for our faculty and students abound and are virtually limitless in the nation’s capital and surrounding areas. The University is committed to attracting and retaining outstanding and diverse faculty and staff that will enhance our stature of preeminence in our three missions of teaching, scholarship, and full engagement in our community, the state of Maryland, and in the world.

Position Summary/Purpose of Position:

University of Maryland Libraries’ Digital Systems and Stewardship (DSS) Division provides systems support and development services to the University System of Maryland and Affiliated Institutions (USMAI) Library Consortium (usmai.org). This 6-month contract position will work independently and collaboratively with DSS team members and staff at USMAI libraries to implement a data warehouse (DW) and business intelligence (BI) solution that addresses the short-term needs and long-term vision for data use and analysis by the consortium’s 17 member libraries.

The project involves establishment of a DW/BI program and completion of an initial data project. The Data Warehouse Architect is expected to lead the defining of program and project-level requirements, as well as lead design activities for technical architecture, data modeling, and BI tools. The Architect will work closely with developers and systems staff on the DW/BI implementation and ETL processes for selected data. The incumbent will be relied upon as an expert during all phases of the project.

Business analysis and requirements definition activities are essential components of the work and will require in-person meetings with staff and administrators at USMAI libraries located throughout the state of Maryland. Expenses for travel accommodations within Maryland State guidelines will be covered. Some telework is possible.

At USMAI’s discretion, project success may lead to awarding of one additional 6-month contract for subsequent data warehouse projects.

Minimum Qualifications:

Requirements
• Knowledge of data warehouse planning and implementation best practices and resources
• Knowledge of data warehouse and business intelligence tools and technologies
• Knowledge of project management concepts and practices
• Excellent analytical skills
• Excellent verbal and written communication skills
• Demonstrated ability to conduct business/systems analysis in order to define functional and technical requirements
• Demonstrated ability to develop data models
• Demonstrated ability to plan and design ETL processes
• Bachelor’s degree
• At least two years of experience supporting various stages of the data warehouse lifecycle

Preferences:

Preferred
• Previous experience with the planning, design, and implementation of a data warehouse program or project
• Previous experience in higher education
• Previous experience in libraries
• Bachelor’s Degree in a field related to information sciences, data sciences, computer sciences, or information management
• Certificate and/or post-graduate studies related to data warehousing, business intelligence, or data science

Additional Certifications:
Additional Information:

DUTIES AND RESPONSIBILITIES:
• Conduct business analysis activities in order to define both program and project-level business requirements (30%)
• Develop dimensional models for initial project’s business requirements (15%)
• Design ETL processes for initial data project (20%)
• Contribute to selection and implementation of the data warehouse’s technical architecture (10%)
• Design the data warehouse’s business intelligence application (10%)
• Advise on data warehouse implementation project plan (5%)
• Participate in the development of implementation and operational financial projections (5%)
• Develop documentation and provide training (5%)

For the full position description, please go to http://www.lib.umd.edu/hr/employment-opportunities/staff-faculty-positions.

Posting Date: 12/04/2017
Closing Date: 12/17/2017
Open Until Filled
Best Consideration Date
Physical Demands

Normal office duties

Diversity Statement:

The University of Maryland, College Park, an equal opportunity/affirmative action employer, complies with all applicable federal and state laws and regulations regarding nondiscrimination and affirmative action; all qualified applicants will receive consideration for employment. The University is committed to a policy of equal opportunity for all persons and does not discriminate on the basis of race, color, religion, sex, national origin, physical or mental disability, protected veteran status, age, gender identity or expression, sexual orientation, creed, marital status, political affiliation, personal appearance, or on the basis of rights secured by the First Amendment, in all aspects of employment, educational programs and activities, and admissions.

Applicant Documents

Required Documents
  1. Resume
  2. Cover Letter
  3. List of References (no emails sent from system)
Optional Documents

Posting Specific Questions

Required fields are indicated with an asterisk (*).

  1. * How did you hear about this position?
    • UMD Job Site
    • Personal Referral
    • Washington Post
    • Baltimore Sun
    • Local Publication
    • Chronicle of Higher Education
    • Inside Higher Education
    • INDEED
    • HERC
    • Hispanic Outlook
    • Diverse Jobs
    • HigherEdJobs
    • Professional Journal
    • Listserv
    • Other
    • SimplyHired
    • CareerBliss
    • Job Fairs
    • Monster.Com