IT Specialist (Membership Systems Lead) (IS-2210-13), Smithsonian Institution, Washington, DC
Smithsonian Institution -
Washington, DC,
US
IT Specialist (Membership Systems Lead) (IS-2210-13)
Date Posted: 2024-06-25
Job description
IT Specialist (Membership Systems Lead) (IS-2210-13)
Application Deadline: 5 July 2024
Department: Office of Advancement
Employment Type: Full Time
Location: Washington, DC
Reporting To: Assistant Director, Membership Services
Compensation: $117,962 - $133,692 / year
Description
OPEN DATE: June 6, 2024
CLOSING DATE: July 5, 2024
POSITION TYPE: Trust Fund
APPOINTMENT TYPE: Indefinite
SCHEDULE: Full Time
DUTY LOCATION: Washington, DC
Non-Sensitive/Low Risk
Open to all qualified applicants
What are Trust Fund Positions?
Trust Fund positions are unique to the Smithsonian. They are paid for from a variety of sources, including the Smithsonian endowment, revenue from our business activities, donations, grants and contracts. Trust employees are not part of the civil service, nor does trust fund employment lead to Federal status. The salary ranges for trust positions are generally the same as for federal positions and in many cases trust and federal employees work side by side. Trust employees have their own benefit program and may include Health, Dental & Vision Insurance, Life Insurance, Transit/Commuter Benefits, Accidental Death and Dismemberment Insurance, Annual and Sick Leave, Family Friendly Leave, 403b Retirement Plan, Discounts for Smithsonian Memberships, Museum Stores and Restaurants, Credit Union, Smithsonian Early Enrichment Center (Child Care), Flexible Spending Account (Health & Dependent Care).
Conditions of Employment
OVERVIEW
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 Futurewill 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.
DUTIES AND 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:
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.
QUALIFICATION REQUIREMENTS
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 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 ...@si.edu. 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 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. See Smithsonian EEO program information: www.si.edu/oeema.
Application Deadline: 5 July 2024
Department: Office of Advancement
Employment Type: Full Time
Location: Washington, DC
Reporting To: Assistant Director, Membership Services
Compensation: $117,962 - $133,692 / year
Description
OPEN DATE: June 6, 2024
CLOSING DATE: July 5, 2024
POSITION TYPE: Trust Fund
APPOINTMENT TYPE: Indefinite
SCHEDULE: Full Time
DUTY LOCATION: Washington, DC
Non-Sensitive/Low Risk
Open to all qualified applicants
What are Trust Fund Positions?
Trust Fund positions are unique to the Smithsonian. They are paid for from a variety of sources, including the Smithsonian endowment, revenue from our business activities, donations, grants and contracts. Trust employees are not part of the civil service, nor does trust fund employment lead to Federal status. The salary ranges for trust positions are generally the same as for federal positions and in many cases trust and federal employees work side by side. Trust employees have their own benefit program and may include Health, Dental & Vision Insurance, Life Insurance, Transit/Commuter Benefits, Accidental Death and Dismemberment Insurance, Annual and Sick Leave, Family Friendly Leave, 403b Retirement Plan, Discounts for Smithsonian Memberships, Museum Stores and Restaurants, Credit Union, Smithsonian Early Enrichment Center (Child Care), Flexible Spending Account (Health & Dependent Care).
Conditions of Employment
- Pass Pre-employment Background Check and Subsequent Background Investigation for position designated as low risk.
- Complete a Probationary Period
- Maintain a Bank Account for Direct Deposit/Electronic Transfer.
- The position is open to all candidates eligible to work in the United States. Proof of eligibility to work in U.S. is not required to apply.
- Applicants must meet all qualification and eligibility requirements within 30 days of the closing date of this announcement.
OVERVIEW
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 Futurewill 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.
DUTIES AND 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.
QUALIFICATION REQUIREMENTS
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 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 ...@si.edu. 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 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. See Smithsonian EEO program information: www.si.edu/oeema.