Job Description

Job Description

Come join a team of dedicated staff at an exceptional time in Smithsonian history, as the Institution Come 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.

About the Data Engineer Position

The 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

Successful 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

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 development 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 22 museums and galleries, the National Zoo, and eight 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 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. This position is a term position funded through September 2025. This is an excellent opportunity to join Smithsonian Advancement, demonstrate your talents and abilities, learn, and grow, with potential for a permanent position. Interested candidates should submit their resumes and a cover letter to oastaffing@si.edu by May 12, 2023. Please include the position title in your e-mail subject line. Resumes should include a description of your paid and non-paid work experience related to this job; starting and ending dates of job (Month and year); and average number of hours worked per week.

Commitment to Diversity, Equity, and Inclusion

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.

The Smithsonian Institution provides reasonable accommodation to applicants where appropriate. Applicants requiring reasonable accommodation should contact the Human Resources Specialist listed. 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.