Position Summary:

The Systems Analyst is responsible for performing daily activities such as data extraction for migrations, sales engineering and Health Data Archiver (HDA) support tasks.

Essential Functions:

• Connects remotely to customer machines to analyze database, document and system structures of an application


• Provides Health Data Archiver (HDA) application support as needed by customers


• Ensures that information is shared with the appropriate staff in a timely manner


• Collaborates with Data Integration Specialists to ensure data that is necessary to complete a given project is available


• Acts as a technical resource for the Project Management team


• Assists the Manager of Systems Analysis in day to day tasks around data prep and miscellaneous tasks


• Performs deep analysis of systems contained in multiple applications and platforms


• Extracts data from multiple application types and platforms and loads it into HHIT’s preferred database engine, MS SQL Server


• Performs file transfers and moves data to and from customers via secure FTP or external encrypted hard drives


• ODBC, OLE DB driver, and linked server configuration


• Assists in the care and maintenance of department facilities, equipment and supplies


• Participates in committees as requested


• Completes other job-related assignments and special projects as directed

Job Specifications:

• Bachelor’s degree or equivalent experience


• Excellent communication with customers and other staff members in a courteous, responsive and helpful manner


• Working knowledge of various DBMS platforms (i.e., Informix, DB2, Sybase, Oracle, etc.)


• Familiarity with SSIS, visual studio, basic data structures, PowerShell, bash or batch scripting and one or more computer languages a plus


• Knowledge of databases and flat file systems


• Familiar with MS SQL server imports and linked servers


• Knowledge of structured query language


• Familiar with OS: Windows, Unix, Linux AS400


• General database structure knowledge


• Familiar with ETL processes


• Experience with file transfer protocol