SQL
Full Time
$80,000 - $100,000
Work from home available Travel not required
Essential Functions:
Business Application Upgrades and Support
• Oversees and supervises the organization's business applications including the deployment of new version upgrades and patches for the organizations primary and secondary applications.
• Provides second tier support for business application users and escalates to vendors as needed.
• Provides end user support, testing, and training.
• Oversees and supervises the creation of training programs, facilitates workshops and vendor coordinated training on business applications, including new and updated releases.
• Makes recommendations on business application products and improvements.
Requirements Gathering
• Gathers and analyzes business requirements for new initiatives and/or modifications to existing initiatives and user needs.
• Facilitates departmental meetings.
Business Intelligence, Analytics, Data Warehousing, and Reporting
• Creates, oversees, and supervises traditional SSRS and InfoMaker reports.
• Creates, filters, and groups BI visualization data.
• Designs and develops business analytics schemas.
• Designs and maintains the organizations data warehouse, including the collection, organization and utilization of all data and statistics from both internal and external data sources.
• Designs and develops ETL processes.
• Oversees, supervises, develops, and optimizes data solutions.
Data Integrity and Validation
• Places data integrity and validation in the forefront of all work efforts.
• Works with various departments to establish, coordinate and maintain data integrity and validation procedures.
• Facilitates the monthly internal user group meetings.
• Determines the correct source of data and designs and makes recommendations based on user requirements.
• Ensures all database objects are developed correctly.
• Stays abreast of peer data integrity processes, methods, and technology tools.
Database Administration and Security
• Monitors and diagnoses database performance issues.
• Conducts annual compliance testing and verification.
• Develops backup and recovery strategies of the business applications and databases.
• Keeps data secure by managing accessibility.
Project Management
• Maintains project plans and monitors work progress.
• Creates and maintains change management, standard operating procedures, and other technical documentation.