Wanted: Data Architect, The Denver Art Museum

Hey, everybody! Come wrangle some data with me at the Denver Art Museum. You know you want to. Please contact me (Koven J. Smith, Director of Technology) at ksmith@denverartmuseum.org if you have any questions about the position.

About the Position:
The Denver Art Museum is seeking a consultant for a two-year, non-benefited, on-site engagement to propose, design, and implement an overall Data Architecture for the enterprise. Experience working in/with non-profit organizations like the Denver Art Museum is preferred, but not required. This position will be responsible for specific deliverables during the contract period, and will also be responsible for ongoing maintenance and upkeep of the Museum’s data architecture.

Essential Duties & Responsibilities
The Data Architect will be responsible for the following deliverables during the contract period:

• Implement a new collections management system for the Museum. The Data Architect will be the primary technology lead for the implementation of a new SQL-based collections management system. Within this implementation role are the following sub-deliverables:
  • Data mapping and migration: The Data Architect will be responsible for mapping data from the Museum’s previous collections management system to its new system in consultation with the primary Vendor and key staff members.
  • Quality Assurance: The Data Architect will perform, in conjunction with departmental stakeholders, QA testing on draft mappings and migrations to ensure data integrity.
  • Data Normalization: Where necessary, the Data Architect will develop and execute data normalization routines and protocols to ensure the accuracy and integrity of legacy data.
  • Primary Vendor Interface: During the implementation process, the Data Architect will be the primary interface between the collections management system vendor and Denver Art Museum staff.
  • Configuration and Customization: The Data Architect will work with the Vendor and stakeholders to configure data entry screens and produce custom Crystal Reports.
• Manage the implementation of a new Digital Asset Management (DAM) system for the Museum. In parallel with the implementation of a new collections management system, the Museum will be implementing a DAM system for the management of internal assets. Within this management role are the following deliverables:
  • Schema design: The Data Architect will work directly with the Museum’s chosen DAM vendor to develop an appropriate metadata schema for multiple asset types.
  • Data mapping: The Data Architect will be responsible for mapping relevant collections data onto the DAM schema.
  • Integrate collections data and digital assets with existing business systems: The Data Architect will be responsible for integrating the collections management and digital asset management systems with existing business systems (primarily financial and fundraising systems).
• Develop and/or implement web services for loose data coupling: The Data Architect will develop RESTful web services for the movement of data between multiple business systems.
• Data Warehousing: If necessary, the Data Architect will design and implement a data warehouse for optimized storage and retrieval of data from multiple business systems.

Ongoing Responsibilities:
In addition to the timed deliverables listed above, the Data Architect will be responsible for supporting the on-going operations of the Museum, with responsibilities including, but not limited to:

• Database design and performance tuning
• Data normalization and systems optimization
• Direct technical support to departmental system administrators
• Business analysis of currently implemented processes and databases
• Schema design for data transport formats such as XML and JSON

Job Qualifications:
A successful candidate for the contract position will possess the following:

• Demonstrated experience with business analysis (familiarity with specific modeling tools, languages, and techniques preferred)
• Demonstrated experience with relational database design, performance tuning, and capacity planning for MS SQL, MySQL, and Postgres environments
• Knowledge of database replication and database monitoring
• Demonstrated experience with report-writing tools such as Crystal or SSRS
• Demonstrated experience with data normalization, and familiarity with common normalization tools

Additional Information:
This is a two-year, non-benefited, on-site engagement. Posting closes on May 1, 2012. If you are interested in this consultant position, please email your cover letter and resume to: hrcoordinator@denverartmuseum.org. In the subject line of your email, please list your name first followed by the position you are interested in obtaining.
It is the policy of theDenverArt Museumto prohibit discrimination against any person or organization based on age, race, sex, color, creed, religion, national origin, sexual orientation, transgender status, gender identity, gender expression, ancestry, marital status, gender, veteran status, political service, affiliation or disability.