DATABASE ADMINISTRATOR - INFORMATION TECHNOLOGY - FT DAYS

Anderson Hospital; Maryville (IL); On-site; USD 80,000 - 105,000; Full time

Job summary

Anderson Hospital is seeking a Data Analyst/Database Administrator to manage mission-critical data systems and reporting. You will ensure core data elements are defined, collected, stored, and interfaced to support objectives.

You’ll assist analysts with data reporting, acquisition, and transfers while maintaining SQL servers and developing Crystal Reports. The role requires two years of experience with SQL, Crystal Reports, and data transfer utilities, plus scripting knowledge for automation.

Qualifications

• Associates degree required in Health Information Management or MIS.
• Experience with SQL, Crystal Reports, and data transfer utilities.
• Familiarity with scripting for process automation (batch, PowerShell).
• Knowledge of data extract/validation/translation/load reporting methods.
• Ability to document the data workflow and maintain data dictionaries.

Responsibilities

• Manage mission-critical SQL servers, applying patches and updates.
• Develop reports using Crystal Reports and SQL stored procedures.
• Update application databases and dictionaries per Data Analytics Manager guidance.
• Test updates and new releases before deployment to production.
• Document and follow up on problems, enhancement requests, and change requests.
• Coordinate with Data Analytics Manager and prepare training materials.

Skills

SQL

Crystal Reports

Batch scripting

PowerShell

Data transfer

Education

Associate degree in Health Information Management

Associate degree in Management Information Systems

Tools

CoreFTP

WinSCP

Job description

JOB SUMMARY:Responsible for management of database mission- critical applications and reporting. Works to ensure that all core data set elements are defined, collected, stored, and interfaced accurately in support of customer objectives. Assists other analysts with data reporting, acquisition, & transfers.JOB RESPONSIBILITIES:Works well under stress or tight deadlines and remains flexible to changing systems and processes.Approaches problems analytically, using good judgment, common sense, and technical knowledge when problem solving.Maintains assigned SQL servers including patches, updates, and database ELTDevelops reports using a tools such as Crystal, SQL store proceduresUpdates application databases and dictionaries as needed or as directed by the Data Analytics ManagerEnsures testing of all updates/new releases for the applications for which they have responsibility is completedDocuments, communicates and follows-up on all reported problems, enhancement requests, and system change requests.Keeps Data Analytics Manager informed of all events affecting the operations of assigned applications.Works with other department staff as needed to develop training materials for assigned applications and provide leader lead training as needed.Contributes to the productivity and efficient operation of the department through skills transfer, continued professional growth and self-education of new technologies.Attend meetings as needed to provide assistance to hospital leaders on the use and/or development of assigned applications.Works with other analysts to assure that a consistent approach is followed throughout all clinical and financial applications.Works with technical staff to help resolve hardware and network problems impacting assigned applications. Presents unresolved hardware/software problems to Technology Manager for resolution.Takes equal amounts of after-hours and weekend after hours “call” with other “front call” staff.Other duties as assignedEDUCATION REQUIRMENTS AND OTHER REQUIREMENTS:Education Level:Associates degree in Health Information Management or Management Information SystemsExperience Requirement:Minimum of two years of experience with SQL, Crystal Reports, & data transfer utilities such as CoreFTP / WinSCP.Process automation using scripting utilities from basic batch files, powershell, etc…Understanding of data extract, validation, translation, & load reporting methodology.