Be a part of a dynamic team dedicated to NSTA’s mission to promote excellence and innovation in science teaching and learning for all. We are looking for a Database Administrator who will take ownership of data management, reporting, and analytics functions to support strategic decision-making across the organization. This role combines expertise in database administration, report generation, and data analysis to deliver actionable insights to staff, leadership, and the Board of Directors. The position also involves programming, system maintenance, and experimentation with emerging technologies to enhance data-driven initiatives. 

This position reports to the Director of IT. 

ESSENTIAL DUTIES AND RESPONSIBLITIES

Reporting and Analytics

• Design, generate, and distribute recurring reports, including membership, sales, inventory, and financial reports, tailored to meet the needs of staff, leadership, and the Board of Directors. This process should be automated whenever possible to increase efficiency and speed of deliverability. 
• Conduct data analysis and deliver insights to inform revenue forecasts, including membership and conference revenue budgets. 
• Develop and maintain a centralized library of self-service reports for efficient access and reuse. 
• Design, develop and maintain automated executive dashboards. 

Database Administration and Programming

• Serve as the database administrator for Association Management System (AMS) and other SQL databases, ensuring optimal performance, security, and availability. 
• Develop and maintain views, reports, and configurations within AMS to meet organizational needs, including building and managing test environments. 
• Perform SQL programming to create, modify, and optimize database queries and stored procedures. 
• Utilize AMS functionality to automate data workflows. Knowledge in Python, ASP.NET, and Crystal Reports may be needed to enhance reporting capabilities, and support web-based initiatives. 

System Development and Automation

• Leverage systems as designed to maximize automation capabilities, proactively recommending improvements to enhance performance and reduce reliance on customizations whenever possible.
• Assists in the development and maintenance of intranet dashboards to support organizational decision making. 
• Automate routine processes, such as address correction using the USPS and Google Maps API, and API integrations. 
• Experiment with AI tools for data-driven projects, including text analysis for topic and sentiment extraction. 

Collaboration and Teamwork

• Actively participate in cross-departmental teams to align technical efforts with organizational goals. 
• Provide technical support and expertise to staff on reporting and data management best practices. 
• Proactively solicit feedback from end users for report and data improvements. Work with internal and external stakeholders to understand processes and develop more efficient and effective ones using system functionality or other applications.

Strategic Support 

• Research and produce ad hoc reports. 
• Contribute to organizational planning by providing data insights that support strategic initiatives and decision-making. 

Backup Support and Infrastructure Maintenance 

• Work with infrastructure staff to perform systems administration tasks and support cloud-based servers in Azure and Amazon. 
• Assist in supporting seamless integration and maintenance of the organization’s technical infrastructure. 

OTHER SKILLS AND ABILITIES

Database Management

• Expertise in relational database design, maintenance, and optimization. 
• Advanced proficiency in SQL for writing, debugging, and optimizing queries and stored procedures. 

Reporting and Analytics

• Strong experience creating and maintaining reports using various tools such as Crystal Reports. 
• Proficiency with analytics and visualization tools such as Power BI and/or Tableau. 
• Advanced knowledge of Microsoft Excel, including complex formulas, pivot tables, and data modeling. 

Data Analysis and Insight Development 

• Proven ability to analyze complex datasets, identify trends, and derive actionable insights. 
• Skilled in producing accurate, meaningful reports and dashboards to support decision-making. 

Cloud Architecture

• Hands-on experience with cloud platforms such as Microsoft Azure and Amazon AWS, including managing databases and applications in cloud environments. 

Programming and Automation

• Proficiency in programming languages such as T-SQL and Python for automating processes and enhancing systems functionality. 
• Experience implementing automation solutions using platforms and APIs to streamline workflows and increase efficiency. 

AI and Emerging Technologies 

• Familiarity with artificial intelligence (AI) tools and techniques, including their application in data analysis and process automation. 

Communication and Collaboration 

• Strong interpersonal skills with the ability to communicate technical information to non-technical stakeholders effectively. 
• Team-oriented mindset, with a demonstrated ability to collaborate across departments to achieve organizational goals. 

Additional Skills 

• Proven problem-solving abilities, attention to detail, and a commitment to maintaining high-quality standards. 
• Self-motivated with excellent time management and organizational skills to handle multiple projects simultaneously. 

TRAVEL REQUIREMENTS

Travel and attendance at national events, conferences and events. Estimated maximum 2 trips annually.

PREFERRED EDUCATION AND/OR EXPERIENCE  

Bachelor’s degree from a four-year college or university program; or four to six year’s related experience and/or training; or equivalent combination of education and experience. 

SOME OF OUR BENEFITS

• Work/ Life Balance
• Remote work
• Good health, dental/ vision insurance
• Vacation, sick and personal leave
• Generous retirement contribution

Salary

$80-$90 K annually

Position Location

This position is remote.