×

Are you sure?

This cannot be undone.
Employment

Membership Systems Specialist

Smithsonian Institution

https://www.si.edu

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 drafting specifications, writing 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 expert 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:

  • Comprehensive knowledge of Microsoft Office tools (Outlook, Excel, Access, Word, PowerPoint, Teams).
  • Develop and maintain complex Excel spreadsheets with pivot tables and data from multiple sources with clear and effective presentation.
  • Utilize ETL tools to import/export data between applications.
  • Strong analytical and problem-solving skills with attention to detail.
  • Proficiency analyzing, maintaining, and automating data workflows.
  • Working knowledge of SQL, PL/SQL, Python, JavaScript, C/C++/C#.
  • Experience with SSIS, SSRS or Tableau preferred.
  • Strong communication and customer service skills.
  • Bachelor’s degree required.
  • 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 oastaffing@si.edu by May 20, 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); and average number of hours worked per week.

The Smithsonian Institution is an Equal Opportunity Employer. We believe that a workforce comprising a variety of educational, cultural, and experiential backgrounds support and enhance our daily work life and contribute to the richness of our exhibitions and programs.

Details

Type:
Full-Time
State(s):
District Of Columbia
Location(s):
Function:
Information Technology
Industry:
Education/Research
Salary:
$89,834 to $101,813
Posted on:
April 19, 2022

How to Apply

Interested candidates should submit their resumes and a cover letter to oastaffing@si.edu by May 20, 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); and average number of hours worked per week.