Database Analyst

Massanutten Current Openings•Mc Gaheysville, VA

About The Position

Responsible for creating and troubleshooting views, functions, stored procedures and writing optimized SQL queries for reporting, analytics, and integrations with other applications. Responsible for creating database triggers or jobs for use in automation and ETL/ELT processes. The candidate will also interface with the software development team to assist in creating custom in-house built applications. In addition, the candidate will create and maintain existing databases for both custom and purchased applications. The candidate must be comfortable working with both on premise and cloud-based databases and moving information between these systems. The candidate will assist with troubleshooting documentation for support team and act as a level 1 support on database request, tickets, reporting, and analytics request submitted by end users. Must be able to manage initiatives individually or as a member of a team.

Requirements

2 to 4 years hands on experience with SQL, databases, custom report creation, and ETL/ELT processes

Nice To Haves

A degree in computer science or a related field or certifications in database management or technical certifications
Familiarity with advanced data concepts (i.e., AI and Machine Learning)

Responsibilities

Act as a level 1 support on data and analytics requests
Analyze databases to ensure optimal performance and uptime
Manage and optimize databases included with purchased products
Create custom program integrations
Create custom databases for internal applications and warehousing of data
Creation and optimization of views, functions, stored procedures, queries and ETL processes
Creation and optimization of reports for directors and stake holders
Manage change management documentation and approval process
Work with development/programming staff to create connections between databases and programs
Work with IT Manager – Data and Analytics on Help Desk knowledge base and documenting resolutions
Perform specialized duties using specific area of expertise
Complete assigned projects efficiently using available resources in a timely manner
Recognize departmental needs and suggest/implement solutions
Provide a high level of customer service to guests, employees, and/or vendors
Contribute specialized knowledge to department, managers, or the company at large
Lead special project implementation and assist team as needed
Effectively communicate changes (e.g. policy, law, operating procedures) when pertinent to operations
Provide constructive feedback to Manager
Organize work in an efficient manner
Think critically to effectively identify problems and troubleshoot solutions
Develop projects and growth initiatives relevant to current area utilizing available resources
Research long range solutions and provide feedback and analysis to management
Seek additional specialized training relevant to current field and pursue continued learning
Cross train co-workers related to special projects or new departmental processes
Other duties as assigned by management