Systems Analyst II

Harmony Healthcare IT; United States; Hybrid; USD 70,000 - 95,000; Full time

Job summary

Harmony Healthcare IT is seeking a Systems Analyst II to perform data extraction for migrations and provide Health Data Archiver (HDA) support. This in-office, hybrid, or remote role requires strong SQL, ETL, and analytical skills.

You will lead HDA support efforts, analyze complex data, and collaborate with data integration specialists to ensure project data availability. A customer-focused, detail-oriented mindset is essential.

Qualifications

• Bachelor's degree or equivalent experience.
• At least three years of experience with database systems, MS SQL Server imports and linked servers, and SQL.
• Experience with Windows, Unix, Linux and AS400 environments; ETL processes and file transfers.

Responsibilities

• Lead the Health Data Archiver (HDA) application support, handling tickets and guiding others.
• Provide excellent customer service and remote system analysis support.
• Analyze databases and system structures, and collaborate with Data Integration Specialists.
• Serve as a technical resource for the Project Management team.
• Assist in data prep, data extracts, and loading data into HHIT's MS SQL Server.
• Configure ODBC/OLE DB drivers and linked servers, and support new installations.
• Contribute to process improvements and assist in facilities maintenance as needed.

Skills

Excellent communication

Problem solving

Interpersonal skills

Organization

Time management

Team player

Task prioritization

Education

Bachelor's degree or equivalent experience

Tools

MS SQL Server

ETL Tools

ODBC / OLE DB

Linked servers

Unix / Linux / AS400

Job description

Company Description

Harmony Healthcare IT (HHIT) is a data management firm that moves and stores patient, employee, and business records for healthcare organizations. To strengthen care delivery and improve lives, vital information is preserved and managed by HHIT in a way that keeps it accessible, releasable, usable, interoperable, secure, and compliant.

Company Description

Harmony Healthcare IT (HHIT) is a data management firm that moves and stores patient, employee, and business records for healthcare organizations. To strengthen care delivery and improve lives, vital information is preserved and managed by HHIT in a way that keeps it accessible, releasable, usable, interoperable, secure, and compliant.

HHIT has established core values for the workplace. This helps to maintain a culture of excellence and provides guidance in our daily work.

HHIT’s Core Values Are

• Do the right thing
• Be easy to work with
• Exceed expectations
• Serve humbly
• Never stop improving

Position Summary

The Systems Analyst II is responsible for performing daily activities such as data extraction for migrations, sales engineering, and Health Data Archiver (HDA) support tasks. This position is an in-office, in-person, or hybrid role if local to South Bend, or remote if not local to South Bend.

Primary Responsibilities

• Lead the Health Data Archiver (HDA) application support efforts by handling support tickets directly and being a resource for others to resolve complex system issues
• Provide excellent customer service
• Connect remotely to customer machines to analyze database, document, and system structures of an application, provide support to others for complex system analysis
• Ensure that information is shared with the appropriate staff in a timely manner
• Collaborate with Data Integration Specialists to ensure data that is necessary to complete a given project is available
• Act as a technical resource for the Project Management team
• Assist the Manager of Systems Analysis in day-to-day tasks around data prep and miscellaneous tasks
• Perform deep analysis of data contained in multiple applications and platforms
• Perform data extracts and work with complex systems
• Extract data from multiple application types and platforms and load it into HHIT’s preferred database engine, MS SQL Server
• Bring ideas for improvement of processes and efficiency to team lead for discussion and implementation
• Perform file transfers and move data to and from customers via secure FTP or external encrypted hard drives
• ODBC, OLE DB driver, and linked server configuration
• Act as a second Tier for HDA support
• Assist in deploying activities for complex, new installations of the product
• Provide general utility code development
• Assist in the care and maintenance of department facilities, equipment, and supplies
• Participating in committees as requested

Required Skills/Abilities

• Excellent communication skills both written and spoken
• Strong problem solving and analysis skills
• Strong interpersonal skills
• Excellent organizational skills and attention to detail
• Excellent time management skills
• Team player
• Drive to complete project work on time
• Ability to effectively prioritize and handle multiple tasks and projects

Education & Experience

• Bachelor’s degree or equivalent experience
• At least three years of experience and knowledge of the following:
• Database and flat file systems
• MS SQL server imports and linked servers
• Structured query language
• OS: Windows, Unix, Linux AS400
• General database structure knowledge
• ETL processes
• File transfer protocol
• HDA application and database structure

Other

• Willing and ready to exemplify HHIT’s core values on a daily basis
• Responsible for protecting data entrusted to HHIT by customers or other parties by strictly adhering to HHIT’s data security and privacy policies and procedures, as well as HIPAA, PIPEDA and all other applicable law.
• Speaking and writing English is a requirement for this position
• Must be authorized to work in the United States

Physical Requirements

• Prolonged periods sitting at a desk and working on a computer
• Must be able to lift up to 15 pounds at times