Integration Eng - Remote

Company Description

We specialize in Staffing, Consulting, Software Development, and Training along with IT services to small to medium size companies. AG's primary objective is to help companies maximize their IT resources and meet the ever-changing IT needs and challenges.

In addition, AG offers enterprise resource planning and enterprise application integration, supply-chain management, e-commerce solutions, and B2B public exchanges and B2B process integration solutions. Our company provides application analysis, design, development and programming, software engineering, systems development, testing, integration, and implementation, and management consulting services to various clients – including governmental agencies and private companies – throughout the United States and India.

We provide these services in multiple computing environments and use technologies such as client/server architecture, object-oriented programming languages and tools, distributed database management systems, state-of-the-art networking, and communications infrastructures. Our honest and realistic approach to recruiting dictates that AG does not entice or lure engineers from their employers. We represent only high caliber technical professionals who have committed to making a change required by career.

Job Description

Responsibility

40 New and Ongoing Interface Implementation

• Determines and analyzes interface/integration capabilities between client hospital information systems and Premier products by reviewing specifications and working with interface vendors and client technical teams to determine the best interface options.

• Analyzes raw data for structure, format, content, and relationships to ensure compatibility and requirements for the various analyses performed.

• Develops and maintains scripts, regular expressions, and other data transformations needed to support data interfacing.

• Generally sets up data processing for new clients to ensure proper data flow, analysis, and reporting.

• Serves as a liaison with vendors, clients, and consultants to resolve data integration issues.

• Collaborate closely with other internal teams to ensure proper data context, mapping, and analysis processing.

25 Analysis & Development

• Plan, design, implement, maintain, and provide ongoing optimization and support for specified clinical and/or business applications

• Perform workflow assessments, capture business needs, and analyze internal systems to determine functional requirements for optimal utilization of extracts

• Work with cross-functional team and with end-users to achieve application integration to meet clinical needs

• Execute builds, upgrades, and system enhancements as needed.

• Build and provide SQL and other database query technology for writing packages, functions, stored procedures, triggers and creating tables and indexes

• Performs data profiling, data analysis and modeling to provide customer-focused solutions

• Advise on the development of data specifications and canonicals that reflect source system data balanced with application requirements

• Participate in planning sessions and provide status reports using task tracking tools such as JIRA

• Communicate with Members regarding integration requirements and customizations

20 Client Technical and Data Support

• Provides application and client user support.

• Performs ad-hoc queries (esp. T-SQL) to troubleshoot and ‘sleuth’ data issues; often as a result of client Help Desk issues.

10 Implementation Support

• Support applications and interfaces throughout all phases of implementation

• Implement changes to extracts as needed

• Deliver post-implementation training, support, troubleshooting and maintenance

• On-call support responsibilities as assigned

5 Product Development

• Subject matter expert with vendor specific applications and technologies, and associated products

• Provides guidance and expertise in healthcare data domains, with particular emphasis on EMR and clinical data sets

• Provides expertise on database extraction techniques

 

Minimum Entry Requirements

Bachelor's Degree: Computer Science, Management of Information Systems, Information Technology or related discipline

3 years related experience

• Operational experience in information systems, including experience integrating large, complex, mission-critical systems. Experience in healthcare and/or financial environments is strongly preferred.

• A minimum of one (1) year commercial experience with programming languages including in-depth understanding and practical knowledge of relational databases.

• Experience with Java and MySQL is ideal.

• Extensive experience inspecting and parsing complex textual data using regular expressions.

• Strong working knowledge of HL7 2.x and XML a plus

• Excellent analytical ability and interpersonal skills to communicate and collaborate effectively with senior management, customers, and other staff members.

• Ability to work independently and proactively in a fast-paced, dynamic environment while delivering outstanding customer-focused software solutions.

Technical skills to include:

• Data Interfacing and Transformation Technologies: Experience with (or ability to quickly learn) data interfacing technologies such as SQL Server DTS, DataJunction/ DataIntegrator, and HL7.

• Data Filtering, Manipulation, and Loading: Experience with loading data into database tables, data filtering, parsing, and recognition using regular expressions and other common techniques.

• Data Processing Setup: Ability to learn proprietary data loading/processing techniques and implement initial workflow and data setup including loading workflow process data, initial data mappings, pick-lists, subscription information, user accounts, core reports, and other meta-data.

 Preferred

Master’s degree

5 years related experience

5 or more years’ experience in business or healthcare data environment that includes:

• Proven database and report/query development experience (T-SQL stored procedures, views, and other queries) in a small, fast-paced, growing environment

• Proven experience in data interfacing and transformation technologies

Demonstrable ‘must-have’ experience with the following technologies: SQL Server 2000 and Windows based operating systems

HL7 Certification

Additional Information

GOOD COMMUNICATION S

C2H

H1B,OPT- EAD,GC or USC

DURATION: 6 + MONTHS