What are the responsibilities and job description for the Database Analyst position at Massanutten Resort?
Job Summary
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.
Required
2 to 4 years hands on experience with SQL, databases, custom report creation, and ETL/ELT processes
Preferred
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)
Typical Schedule
Days:
Monday-Friday, weekends and holidays as needed
Position will be required to be part of rotating on call schedule
Hours:
8am to 5pm, extra hours as needed
Core 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
- Other duties as assigned by management
Focus
Tasks and Duties
- 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
Communication and Team Involvement
- 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
Decision-Making and Initiative
- 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
Professional Development and Mentoring
- Seek additional specialized training relevant to current field and pursue continued learning
- Cross train co-workers related to special projects or new departmental processes
For more information, please contact Gabriel Diaz at 540-289-3143.