DescriptionOPEN DATE: 8/11/2023

CLOSING DATE: 9/8/2023

SALARY RANGE: $112,015 - 126,949

POSITION TYPE: Trust Fund

APPOINTMENT TYPE: Temporary

SCHEDULE: Full Time

DUTY LOCATION: Washington DCNon-Critical Sensitive/Moderate RiskOpen 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 PeriodMaintain 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.

OVERVIEWCome join a team of dedicated staff at an exceptional time in the Smithsonian s history as we prepare for the Smithsonian Campaign for Our Shared Future. This ambitious fundraising campaign s public phase will run from 2024 to 2026, culminating with the nation s 250th anniversary. It will expand the Smithsonian s reach and impact, empowering the institution to find solutions to today s most pressing challenges. The Smithsonian is also planning two exciting new 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. The Smithsonian has built a model fundraising organization, driven by talented staff across our many museums, research centers and cultural centers. 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.DUTIES AND RESPONSIBILITIESThe Smithsonian Institution s Office of Advancement seeks a Data Engineer to serve as a key member of the Advancement Technology Services team as we transform our data management approach. The data engineer reports to the Systems Manager and works with the team in developing and supporting high-quality, secure systems and data pipelines.

The Data Engineer:

Designs, develops, documents, and implements data solutions (ELT/ETL pipelines, tools, datasets, etc.) that support a variety of products.Performs data profiling and analysis, data cleansing and validation in support of data solutions.Builds solutions that support real-time and batch data processing and adhere to data management, security, and privacy standards.Tests and promotes work packages between non-production and production environments both independently, and with team members.Collaborates with stakeholders (internal technical and business teams) to understand processes and data needs.Monitors and troubleshoots solutions - correcting failures, security, and performance issues in a timely manner.Creates and manages incident reports as they pertain to data management processes.Provides advanced technical support for production applications and dataflows.

QUALIFICATION REQUIREMENTSSuccessful candidates will have:

Demonstrated expertise in data management with large/complex databases using SQL and PL/SQL, stored procedures, indexing, triggers, and performance tuning.Demonstrated expertise building resilient data pipelines for system integration and for reporting/analytics purposes.Experience with Oracle, MS SQL Server, Hive, and cloud/serverless databases.Experience with one or more of the following data management and orchestration technologies Azure Data Factory, SSIS, AWS Glue, Airflow, JSON, and APIs.Experience modeling datasets for, managing the configuration of, and supporting development in, business intelligence tools (e.g., Tableau, PowerBI).Experience with CRM-like and transactional datasets.Exposure to cloud services (e.g., AWS, Azure) and familiarity with serverless data architectures using those services.Proficiency in programming languages for data and analytics (e.g., SQL, Python and R).Strong analytical and problem-solving skills.Strong technical writing skills and experience creating procedural and audit documentation.Strong communication skills, presentation skills, and the ability to build relationships in a hybrid setting.Demonstrated ability to innovate and drive assigned tasks to successful completion.Curious, creative, and collaborative approach to challenges.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.

The Smithsonian Institution values and seeks a diverse workforce. Join us in "Inspiring Generations through Knowledge and Discovery."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.

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.

Relocation expenses are not paid.

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.About Smithsonian Institution

Founded in 1846, the Smithsonian is the world s largest museum and research complex of 19 museums and galleries, the National Zoological Park and nine research facilities. There are 6,000 Smithsonian employees, including approximately 500 scientists. The total number of objects, works of art and specimens at the Smithsonian is estimated at nearly 137 million.#J-18808-Ljbffr