Data Management Specialist

Summary

ESSENTIAL DUTIES AND RESPONSIBILITIES

1. Database Administration:

• Design, implement, and maintain SQL and non-SQL databases to ensure optimal performance, security, and scalability.
• Develop and optimize queries, stored procedures, and functions for data retrieval and manipulation.
• Perform database administration tasks such as backup and recovery, monitoring, and troubleshooting.
• Extract data in various formats to migrate to other enterprise systems.

2. Reporting Services:

• Design and develop reports using SQL Server Reporting Services (SSRS) to present data in a clear and actionable format.
• Work closely with business users to understand their reporting and analytical needs and deliver solutions that provide actionable insights.
• Maintain and enhance existing SSRS and Tableau reports, ensuring accuracy and reliability of data.

3. Search and Analytics:

• Configure and manage data warehouse tools, such as Elasticsearch, to support efficient search and analytics capabilities.
• Develop custom queries and aggregations to extract meaningful insights from large volumes of data.
• Monitor data warehouse performance and troubleshoot issues to ensure reliability and scalability.
• Leverage Python to work with data analytics, including Jupyter Notebooks and standalone Python applications.
• Help to build an integrated data warehouse that can index and relate structured and unstructured data.
• Work with NFWF’s scientists to index data from the wide variety of data sources in the Foundation.
• Support NFWF’s Artificial Intelligence strategy with various analytics and system integrations.

MINIMUM QUALIFICATIONS (EDUCATION, EXPERIENCE, SKILLS)

• Three to five years relevant experience; Bachelor's degree in Computer Science, Information Systems, or related field.
• Proven experience in SQL Server database management, including database design, optimization, and administration.
• Strong proficiency in SQL programming and experience with complex query optimization.
• Hands-on experience with SQL Server Reporting Services (SSRS) for report development and deployment.
• Experience with programming in Python, Jupyter Notebooks, and related data analytics tools.
• Familiarity with Elasticsearch setup, configuration, and query optimization.
• Excellent problem-solving skills and ability to work independently or as part of a team.
• Strong communication and interpersonal skills, with the ability to effectively collaborate with stakeholders at all levels.

PREFERED QUALIFICATIONS

• Certifications in SQL Server and Elasticsearch.
• Experience working with large-scale data warehousing and ETL processes.
• Knowledge of data modeling techniques and best practices.
• Experience in software development or scripting languages such as Python or R.

COMPENSATION

Commensurate with experience.

LOCATION

Washington, DC

Application Notes:

Please submit a cover letter describing your interest and qualifications, and resume.

Applicants must be currently authorized to work in the US on a full-time basis.

Equal Opportunity Statement - The National Fish and Wildlife Foundation complies with all applicable federal, state and local laws in its commitment to being an equal opportunity employer. The Foundation does not discriminate against applicants or employees on the basis of race, color, religion, age, sex, national origin, ancestry, marital status, personal appearance, citizen status, disability, sexual orientation, gender, identity or expression, pregnancy, child birth or related medical conditions, family responsibilities, matriculation, genetic information, political or union affiliation, veteran status or any other status protected by applicable law.

Disclaimer - The statements contained herein are intended to describe the general nature and level of work to be performed by the employees in these positions. The statements are not intended to be construed as an exhaustive list of all responsibilities, duties, and skills required of a person in each position. Other responsibilities, duties, and skills may be assigned and management retains the right to add or change the responsibilities, duties, and skills at any time.