Database Analyst

Job Details

Description

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

Communication and Team Involvement

Decision-Making and Initiative

Professional Development and Mentoring

For more information, please contact Gabriel Diaz at .