Supervisory IT Specialist (Membership Systems Lead)

Washington, DC, United States

Come join a dedicated and creative team at an exceptional time for the Smithsonian, an institution with a bold vision for the future: to build a better tomorrow for all. Smithsonian Secretary Lonnie G. Bunch III and the institution’s leadership are launching a campaign to support this vision. The Smithsonian Campaign for Our Shared Future will secure funds for all Smithsonian museums and centers as the institution reimagines its mission to find solutions for collective challenges in a rapidly changing world. The campaign will provide a foundation for critical research to ensure people and nature thrive together, build unparalleled education programs with families and partners, collect the world’s most precious objects, document the present while reflecting on the past, and reimagine the visitor experience both in-person and online. We are bringing the Smithsonian off the National Mall and across the country through dynamic programming and affiliate partnerships, creating access for all. The Smithsonian is also developing two new museums—the National Museum of the American Latino and the Smithsonian American Women's History Museum. These museums will share the experiences and perspectives of Latinos and women across history and deepen our shared understanding of what it means to be American.

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.

Key Responsibilities

The Membership Systems Lead works in the Office of Advancement for the Smithsonian Institution. This position manages production and systems support for 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 Membership Systems Lead manages the production schedule and executes jobs to produce data for direct mail, telemarketing, text and online campaigns, regularly scheduled reports, data extracts, and data uploads. This position serves as an in-house expert on the membership portion of the SI Advancement CRM and as the lead programmer for membership-related CRM functions, 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 to troubleshoot and resolve membership systems issues.

This position:

·      Writes program design specifications

·      Participates in data management and databases conversions

·      Writes custom SQL for direct response fundraising campaigns, data extracts and in-house reporting

·      Drafts and executes structured test plans

·      Drafts and maintains technical documentation

In addition, the position runs production jobs, including data extracts, reports, and uploads, verifies output and record counts, ensures data accuracy and timely, secure delivery of files.

Skills, Knowledge, and Expertise

Qualified applicants will successfully demonstrate strong SQL (PL/SQL or TOAD), Python, JavaScript and Microsoft Office skills. Familiarity with SSIS, SSRS, ETL tools, Tableau and Salesforce environments is strongly encouraged. Knowledge of and experience with the systems development life cycle, quality assurance, managing multiple deadlines, completing priorities, and demonstrating superior organization skills, are critical. Experience with large, complex membership program(s) is required. Familiarity with Salesforce environments and/or a Salesforce conversion is preferred.

Applicants who wish to qualify based on education completed outside the United States must be deemed equivalent to higher education programs of U.S. Institutions by an organization that specializes in the interpretation of foreign educational credentials. This documentation is the responsibility of the applicant and should be included as part of your application package.

Any false statement in your application may result in your application being rejected and may also result in termination after employment begins.

Application Instructions

The Smithsonian Institution values and seeks a diverse workforce. Join us in "Inspiring Generations through Knowledge and Discovery." Interested candidates should submit their resumes and a cover letter to this link by July 5, 2024. 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. Relocation expenses are not paid.

What To Expect Next: Once the vacancy announcement closes, a review of your resume will be compared against the qualification and experience requirements related to this job. After review of applicant resumes is complete, qualified candidates will be referred to the hiring manager.

Commitment to Diversity, Equity, and Inclusion

The Smithsonian Institution provides reasonable accommodation to applicants with disabilities where appropriate. Applicants requiring reasonable accommodation should contact [email protected]. Determinations on requests for reasonable accommodation will be made on a case-by-case basis. To learn more, please review the Smithsonian’s Accommodation Procedures.

The Smithsonian Institution is anEqual 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. See Smithsonian EEO program information:www.si.edu/oeema.