NewHavenRecruiter Since 2001
the smart solution for New Haven jobs

Healthcare Data Analyst

Company: Executive Alliance
Location: Melville
Posted on: March 19, 2023

Job Description:

Executive Alliance is pleased to represent our client who are a fast-growth healthcare technology leader whodevelops and distribute cutting-edge software solutions to all 340B-eligible healthcare providers and pharmacies that offer patients access to lower cost pharmaceuticals reimbursed by state Medicaid agencies. Their software and consulting services are adapted and customized to each of their client's needs and are top tier leaders in their field. They are seeking an Data Analyst to work out of their Melville, Long Island, New York regional headquarters who will lead their IT operations' service management programs, levels and client engagements. . NOTE: This is an on-premise opportunity located in Melville, N.Y. and is not remote role. This company does not offer U.S. visa sponsorship support to prospective employees. No C2C's, please. Job Summary: The Data Analyst position favors the technical side and supports the Operations infrastructure. This person will help organize and automate the current validation processes. The primary responsibilities involve tracking, investigating, and researching inbound and outbound files including tracing files from source to target, analyzing, and debugging issues. Responsibilities:

  • Administer daily operations, retrieve inbound/outbound file transactions- EDI, HL7s, and Text files (Retrieval and analysis of files, File format identification, Plan a resolution)
  • Track daily claims processing, PO, Invoices, Process files and analyze gaps/overall impact, and coordinate with vendors to correct discrepancies on missing files
  • Monitor, analyze and track daily customer and vendor files (Claims, PO, Invoice, Price, Member, Provider etc.)
  • Identify and escalate both internal and external customer/vendor issues to the appropriate business partners and drive solutions to resolution
  • Monitor workflow, analyze processes, and make recommendations for improvements
  • Setup new jobs for (Wholesaler Inventory, PO, Price Files , Patients, etc.) and maintain changes (BAU)
  • Coordinate and test implementations with new customers/vendors, and Implementation team
  • Review (Exceptions, Bad Files) and trace through the file system and work issues with appropriate analyst/development team to correct the problem. This issue will be owned by Monitoring person until resolved.
  • Independently research tickets/issues from start to finish, in addition to work on projects as assigned
  • Manage SyncService connectivity until the system is phase out Qualifications/Required Skills/Education Required:
    • Comfortable working with large raw data files (Csv, Txt, EDI, .xlsx)
    • Ability to edit, manipulate, and search information utilizing Excel and Notepad++. (Pivot tables, VLOOKUP's, filers, calculated fields, macros, etc.)
    • Ability to write sophisticated SQL queries and an understanding of relational databases (MS SQL). Parsing queries, utilizing window functions, rewriting queries for efficiency, joins, common table expressions, dynamic SQL, etc.
    • Organized with Strong written and Verbal communication skills. Can cohesively present and translate findings to the business and development teams. Comfortable reaching out via email, phone, or Microsoft teams internally and externally to address issues in a professional manner
    • Ability to recognize past issue patterns/trends and relate them to existing problem resolution process
    • Time management and prioritization. Ability to adjust priorities accordingly as they frequently can change when issues arise. Work steadily, actively and consistently to complete assignment within established timeframes. Preferred:
      • Experience in healthcare industry preferred
      • 340B industry a plus
      • Familiar with Jira and Agile Process
      • Experience creating test cases and conducting QA on enhancements/bugs
      • Experience working with EMRs, HL7 interfaces/messages (ADT and SIU), and patient information Benefits:
        • 401(k)
        • 401(k) matching
        • Dental insurance
        • Health insurance
        • Paid time off
        • Vision insurance Experience:
          • Data Analysis: 2-4 years (Required)

Keywords: Executive Alliance, New Haven , Healthcare Data Analyst, Healthcare , Melville, Connecticut

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Connecticut jobs by following @recnetCT on Twitter!

New Haven RSS job feeds