Position: ETL Data Analyst
Company: Yallah
Category: Data Analyst
Experience required: 2y
English level: upper
Published: 2022-03-01T00:00:00+02:00

Our main product, Portico, helps uninsured patients to cover their medications by creating superior technology connecting various parties: hospitals, pharmacies, drug vendors.

The **ETL Data Analyst** position favors the technical side and supports the current operations infrastructure. This position resided in Operations and will work with the Development team to resolve specific issues. The primary responsibilities involve tracking, investigating, researching inbound and outbound files which includes tracing files from source to target, analyzing, and debugging issues. This person should be comfortable working with native EDI and Text files as well as SFTP protocols and HL7 connections with a desire to learn about the Healthcare Industry. This position will work on the back-end operations using Azure and will become a subject matter expert on how the files flow through the system.

**Responsibilities:**
* Perform daily monitoring of customer and vendor files (Claims, PO, Invoice, Price, Member, Provider etc.) with the ability to understand when to escalate concerns.
* Administer daily operations, retrieve inbound/outbound file transactions- both EDI and text files
* Plan resolutions to file issues, both format/layouts as well as loading to the system
* Monitor workflow, analyze processes and make recommendations for improvements
* Identify, manage, and document requirements for customers/vendors; review and coordinate file layouts, facilitate testing, verify counts, and ensure accuracy
* Independently research tickets/issues from start to finish, in addition to work on projects as assigned
* Coordinate and test implementations with new customers/vendors
* Willingness and ability to learn

**Required Skills/Education:**
* English level: B2+
* Comfortable working with large raw data files( Csv, Txt, EDI, HL7 )/data sets is a must (editing, manipulating, searching) - Required
* Self-starting independent person
* Ability to write SQL queries at the basic to intermediate level as needed, preferably MS SQL – Required
* Organized with Strong written and Verbal communication skills – Required
* Detail Oriented
* Be able to work from 06:00 am to 02:00 pm (+/- 1 hour) NY time.

**What you get:**
* Friendly, agile working environment
* Work in the product company
* Competitive base pay with a performance-based bonus
* Yearly Corporate Retreats where our colleagues fly from all over the world to meet each other in person
* Opportunity to become part of a successful product that makes a difference
* Possibility to grow into an Engineering role in the future