Membership Systems Specialist

Come join a team of dedicated staff at an exceptional time in the Smithsonian’s history during the creation of two new Smithsonian museums. The National Museum of the American Latino and the Smithsonian American Women’s History Museum share the experiences and perspectives of Latinos and women across history and deepen our shared understanding of what it means to be an American. These museums build on the legacy and impact of the National Museum of African American History and Culture, which has helped transform the nation’s understanding of American history since its opening in 2016. 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.

About the Membership Systems Specialist

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. The Specialist runs production jobs to produce data for direct mail, telemarketing, text and online campaigns, regularly scheduled reports, data extracts, and data uploads. The incumbent troubleshoots and resolves membership systems issues by identifying causes, assisting with remedies, and advising on error prevention. This person 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 and identifies tasks that are repetitive and do not require review, participates in automation of those tasks. The incumbent serves as an in-house specialist on the membership portion of the Pan-Institutional Database for Advancement (PANDA) (Ellucian Advance).

The successful applicant will have at least intermediate level knowledge of Microsoft Office tools (Outlook, Excel, Access, Word, PowerPoint, Teams). Experience working with complex Excel spreadsheets including pivot tables and data from multiple sources should be demonstrated in applicant materials. Applicants must have experience with SQL, PL/SQL or TOAD and ETL tools to import/export data between applications. Familiarity with Python, JavaScript, C/C++/C# as well as SSIS, SSRS or Tableau is a plus. 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. Applicants should demonstrate strong analytical and problem-solving skills with attention to detail. Strong communication and customer service skills are required. Experience with membership, fundraising, non-profit organizations and/or database management preferred. Degrees and certifications should be included on resume.

About the Office of Advancement and Smithsonian Institution

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. The Smithsonian is a national and world treasure and is dedicated to its founding mission, “the increase and diffusion of knowledge.” Its exhibitions, programs, collections, and outreach touch the lives of millions of Americans every year, as well as many who visit us from abroad.  

Benefits Information and Application Instructions

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 oastaffing@si.edu by November 25, 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.

Commitment to Diversity, Equity, and Inclusion

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.