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
Company Description:Company Description:
Harmony Healthcare IT (HHIT) provides technology solutions for healthcare organizations by safeguarding protected clinical information, increasing productivity and maximizing cash flow. We specialize solely in healthcare technology – driving accessibility, security, efficiency and quality for our customers who rely on accurate clinical data to provide care for their patients. We are best known for our excellence in data extraction, migration and retention of healthcare records ensuring system reliability and data integrity 24/7. We are growing and seek to add key members to our team to help continue our mission of helping the healthcare system work better for everyone.