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 sourcesValidate and clean incoming data to ensure consistency and accuracyMatch sales lines to appropriate customer accounts using established business rules and reference dataCollaborate with internal teams to resolve data discrepanciesMaintain documentation of data processing workflows and matching logicSupport ad hoc data analysis and reporting requests as neededCoordinates with Contracts Admin team to ensure correct contract is loaded; and provides updates as required.Monitors the flow of tracings within Model NCommunicates 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 requiredIdentify opportunities to enhance tracings issue prevention strategies and develop and implement new procedures to minimize incidentsOther duties as assignedEducation and experience :
Required
Bachelor’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 skillsPreferred
Healthcare 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