Needs to be an expert in excel and have healthcare experience!
• In 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

Job duties:

· 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 assigned

Education and experience:
Required
• Bachelor’s Degree required in Data Analytics, Business, Healthcare Administration or similar
• Minimum 2 years of demonstrated experience of data processing using MS Excel at an expert level. Preferably in the healthcare industry
• Strong analytical skills and high attention to detail
• Proficiency 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 supervision
• Excellent communication and interpersonal skills with good judgment and strong operational focus
• Capability to efficiently complete tasks in a fast-paced environment
• Requires a positive attitude as well as being a team player with good organizational skills

Preferred
• Healthcare experience specifically processing of tracings, chargebacks or rebates; Minimum of 2 years of tracings process experience preferred
• Working knowledge of Salesforce, SAP, Model N (or any other A/P system) is a plus
• Experience working on analytical projects and programs that involve integration of external/third-party information, and data quality initiatives
• Strong collaboration skills, able to influence without authority, and have an innovative mindset

Strong analytical and problem-solving skills, with the ability to communicate