80 applicants

Company

Original Job Post

National Fish and Wildlife Foundation · 2 days ago

Data Management Specialist

Washington, DC

Full-time

Onsite

Mid Level

3+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

AssociationWildlife Conservation

Insider Connection @National Fish and Wildlife Foundation

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

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.

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.

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.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

SQL ServerDatabase ManagementDatabase DesignQuery OptimizationSQL ProgrammingSSRSPythonJupyter NotebooksData AnalyticsElasticsearchConfigurationProblem-SolvingHard WorkingCommunicationInterpersonalETL processesData modelingRSoftware development

Required

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.

Preferred

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.

Company

National Fish and Wildlife Foundation

The National Fish and Wildlife Foundation (NFWF) works with the public and private sectors to sustain, restore and enhance the nation’s fish, wildlife, plants and habitats for current and future generations.

Founded in 1984

Washington, District of Columbia, USA

51-200 employees