This job has expired

Membership Systems Specialist

Smithsonian Institution
District of Columbia, United States
$74,950.00 - $97,430.00
Closing date
Sep 23, 2022

View more

Position Type
Administrative, Information Systems
Arts, Education, Museum
Employment Type
Full Time

Come join a team of dedicated staff at an exceptional time in Smithsonian history. With our Secretary, Lonnie G. Bunch III, who was previously the founding director of the Smithsonian's National Museum of African American History and Culture, we are positioned to realize our goal of being a truly 21st century museum complex. The Smithsonian is dedicated to its founding mission, “the increase and diffusion of knowledge” and as such we use our resources to encourage curiosity, ignite wonder and spark the joy of learning. Following the success of the Smithsonian’s first comprehensive capital campaign, the largest ever undertaken by a cultural organization, the Smithsonian has built a model fundraising organization. This position offers exciting opportunities for the successful candidate to make a significant impact on the future of the Smithsonian. There is no better time to join this amazing Institution.

The Membership Systems Specialist works in the Office of Advancement for the Smithsonian Institution. This position delivers production and systems support for the five museums currently in the Smithsonian membership COOP. It offers the opportunity to work in partnership with a team of dedicated staff while directly serving a diverse group of membership programs.

This position performs the following activities:

  • Runs production jobs to produce data for direct mail, telemarketing, text and online campaigns, regularly scheduled reports, data extracts and data uploads
  • Troubleshoots and resolves membership systems issues by identifying causes, assisting with remedies, and advising on error prevention
  • Serves as a programming specialist by reviewing specifications, writing simple programs and creating and executing test plans as part of the development life cycle
  • Collaborates with business users across Smithsonian Institution membership teams and developers to improve membership data, deliver regular and ad-hoc data sets and reports
  • Identifies tasks that are repetitive and do not require review, participates in automation of those tasks
  • Serves as an in-house specialist on the membership portion of the Pan-Institutional Database for Advancement (PANDA) (Ellucian Advance).

The position requires the ability to thrive in a fast-paced environment and meeting deadlines with complete and accurate data while providing good customer service.

Successful candidates will have demonstrated experience with:

  • Microsoft Office tools (Outlook, Excel, Access, Word, PowerPoint, Teams)
  • Complex Excel spreadsheets with pivot tables and data from multiple sources
  • SQL, Pl/SQL or Toad
  • ETL tools to import/export data between applications
  • Knowledge of Python, JavaScript, C/C++/C# is a plus
  • Experience with SSIS, SSRS or Tableau is a plus

Additional requirements:

  • Strong analytical and problem-solving skills with attention to detail
  • Strong communication and customer service skills
  • Bachelor’s degree
  • Experience with membership, fundraising, non-profit organizations and/or database management preferred

The Office of Advancement oversees and guides the fundraising efforts of the entire Smithsonian and is home to the central advancement organization for the Institution. In addition to raising significant support for a variety of Smithsonian initiatives, the Office of Advancement provides support services to advancement offices across the Institution.  The office engages with staff throughout the Smithsonian in accomplishing their goals.

The Smithsonian Institution is a unique complex of 21 museums and galleries, the National Zoological Park, and nine research centers. Its exhibitions, programs, collections, and outreach touch the lives of millions of Americans every year, as well as many who visit us from abroad.

The Smithsonian Institution offers a competitive salary and a comprehensive package of benefits. This is not a federal position but has similar requirements and benefits. Interested candidates should submit their resumes and a cover letter to by September 23, 2022. Please include the position title in your e-mail subject line. Resumes should include a description of your paid and non-paid work experience that is related to this job; starting and ending dates of job (Month and year); average number of hours worked per week; and salary requirements.

The Smithsonian Institution ensures its employees (federal and trust), applicants, and affiliated persons (interns, research associates, fellows, and volunteers) are protected from discrimination and unfair treatment in the workplace regardless of their race, color, religion, national origin, sex (including gender identity, gender stereotyping, pregnancy, and sexual orientation), age, disability, genetic information, marital status, parental status, or political affiliation and are free from reprisal against protected activities. In addition, other Smithsonian policy prohibits discrimination based on membership in an employee organization or other non-merit factors, and political affiliation.

The Smithsonian provides reasonable accommodation to applicants with disabilities. If you need an accommodation for any part of the application and hiring process, please notify the contact person listed in this announcement. The decision on granting a reasonable accommodation will be made on a case-by-case basis.

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert