ETL Analyst

Role : ETL AnalystLocation : Atlanta, GA (Onsite)Exp: 8-9+ yearsVisa: Any VisaOn W2 Note: Need Pharmaceutical or Healthcare ExperienceJob PurposeIn this role, the Analyst will assist in Extracting, Transforming, and Loading data (ETL). You will be responsible for familiarizing yourself with the tracings data received from various distributors, whether the data is received via EDI or spreadsheets. Said data will have to be moved into our systems in a timely manner while ensuring timeliness, accuracy and integrity of sales tracings data by properly matching sales lines to the correct customer accounts. As a member of the team, you will be expected to contribute to the development of best practices within the data processing methods. This work will require quite a bit of troubleshooting when data received has errors. The ideal candidate will have experience working with large data sets, strong Excel skills, and an eye for data quality.Your role·        Ingest and process sales tracings data from various sources·        Validate and clean incoming data to ensure consistency and accuracy·        Match sales lines to appropriate customer accounts using established business rules and reference data·        Collaborate with internal teams to resolve data discrepancies·        Maintain documentation of data processing workflows and matching logic·        Support ad hoc data analysis and reporting requests as needed·        Coordinates with Contracts Admin team to ensure correct contract is loaded; and provides updates as required.Monitors the flow of tracings within Model N·        Communicates and collaborates with assigned distributors as needed when tracings are missing to initiate business process and ensures that their system is updated, continuous improvement activities, conduct root                                cause analysis where required.·        Identify opportunities to enhance tracings issue prevention strategies and develop and implement new procedures to minimize incidents·        Other duties as assignedEducation and experience:RequiredBachelor’s Degree required in Data Analytics, Business, Healthcare Administration or similarMinimum 2 years of demonstrated experience of data processing using MS Excel at an expert level. Preferably in the healthcare industryStrong analytical skills and high attention to detailProficiency in MS Excel (VLOOKUP, pivot tables, data validation) and data management tools (Model N, SAP or similar)A well-organized and self-directed individual who can work with minimal amount of supervisionExcellent communication and interpersonal skills with good judgment and strong operational focusCapability to efficiently complete tasks in a fast-paced environmentRequires a positive attitude as well as being a team player with good organizational skills PreferredHealthcare experience specifically processing of tracings, chargebacks or rebates; Minimum of 2 years of tracings process experience preferredWorking knowledge of Salesforce, SAP, Model N (or any other A/P system) is a plusExperience working on analytical projects and programs that involve integration of external/third-party information, and data quality initiativesStrong collaboration skills, able to influence without authority, and have an innovative mindsetStrong analytical and problem-solving skills, with the ability to communicate in a clear and succinct manner and effectively evaluates information / data to make decisions