Database Analyst

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.