Business and Data Systems Analyst

Company Name: 

Oakland Museum of California


Apply Online
Oakland, CA 94607

Job Description: 

Oakland Museum of California

Req No 2018-1260
Category Information Technology
Type Regular Full-Time
Closing Date
Targeted Job Start Date 9/15/2018


The Oakland Museum of California values are fundamental to our institutional culture and guide our work together.

Excellence: We are committed to excellence and working at the highest standards of integrity and professionalism.

Community: We believe everyone should feel welcome and part of our community, both within the Museum and with our visitors and neighbors.

Innovation: We embrace innovation and calculated risk-taking to achieve our mission.

Commitment: Our work at the Museum demonstrates a sense of purpose and a shared accountability for the institution's success.


The Business and Data Systems Analyst is a critical staff position to help the museum better use data and information both internally and externally. The position is responsible for all phases of database management, design and administration for the organization's business systems.



The following reflects OMCA's definition of essential functions for this position, but does not restrict the tasks that may be assigned. OMCA may assign or reassign duties and responsibilities to this position at any time due to reasonable accommodation or other reasons.


  • Support the Museum's mission, values, vision, and core commitment to the visitor experience, community engagement, and institutional relevancy for the future
  • Contribute to and support the OMCA strategic plan, annual priorities, and institutional initiatives such as diversity advancement
  • Contribute to a positive organizational culture based on mutual respect, a spirit of collegiality, cooperation, and openness to many perspectives
  • Participate in a culture of ongoing learning, collaboration, innovation, creativity, and community engagement


  • Provides technical and business process support for the museums business systems. Works with staff and external consultants to ensure success of the current configuration and implementation of new features
  • Leads digital literacy of data systems for staff, ensuring comprehension of data, opportunities and responsibilities
  • Develops and provides advanced reports, data extractions and data management as required by business units, including custom reports, stored procedures and custom views using Microsoft SQL Server, SQL Server Reporting Services and database system tools
  • Provides advanced query-writing, data imports and exports, report creation, testing and quality assurance across database systems
  • Manages the development of new methods, procedures, processes or systems and possesses the ability to understand the impact of these changes
  • Provides day-to-day technical support, maintenance, training, and troubleshooting for museum staff by working in various mission critical business systems
  • Manages and supports database and system upgrades
  • Manages the configuration, setup, implementation and training for new systems
  • Performs data cleaning and transformation for migration into new systems and data sharing between existing and new systems
  • Provides general technical assistance for various data-related projects as needed



A combination of experience and education that demonstrates possession of the necessary knowledge and abilities for this position is required as noted:

  • Ability to display and encourage visitor and internal customer service, take and share responsibility and treat others with respect
  • 4+ years of experience in administering SQL databases required
  • Degree, course work or certificate in Computer Science, Information Technology, or a related discipline preferred
  • Working knowledge of Microsoft SQL, MySQL, SSRS and other database related systems.
  • Working knowledge of IIS, web configurations, Windows Server 2012
  • Ability to develop and edit basic HTML
  • Experience with museum and non-profit business systems
  • Proven project manager who can work collaboratively cross-departmentally and as a part of a team
  • Strong troubleshooting skills and methodology
  • Good written and oral communication skills
  • Ability to establish and maintain good working relationships with museum staff and vendors
  • Ability to use logic and analysis to solve computer and systems problems
  • Ability to maintain confidentiality within and outside the museum
  • Ability to learn, install, and support new application software


While performing the duties of this position, the employee is frequently exposed to the following:

  • Noise, such as groups of people working in enclosed areas
  • Typical office environment


The Oakland Museum of California is dedicated to diversity, inclusion, accessibility and equity. We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to age, race, color, religion, sexual orientation, gender identity, national origin, ability/disability status, protected veteran status, or any other characteristic protected by law. We highly encourage our diverse community to apply for available employment, internship, fellowship and volunteer positions at the Museum, as we aim to ensure our staff reflects the diversity of our visitor and surrounding community.

Apply Here