Data Analyst
Current@Spends Analytics Team-Utilize various data analytic tools (SQL, Excel, Microsoft Dynamics) and techniques to identify issues such as duplicate items or inconsistency in attributes -Generate automated PowerBI reports on item master data quality and weekly data cleansing KPIs-Review data gaps from overnight ETL process and process accordingly -Validate incoming vendor-based data and use data mining and cleansing techniques to create and/or update item master data and item attributes-Communicate with both internal and external stakeholders regarding project status and any risks to timelines -Support offshore resource team through clarification of standards, creating work packages, managing workload, quality review, publishing and dashboarding of KPIs-Continuous review and tracking of KPIs for incoming data -Leveraging data to identify, implement and document opportunities for more efficient work processes or enhancements to existing processes/systems-Comparison of vendor and hospital data to improve data integrity and data availability -Support system enhancements: providing test cases, completing test cases, creating training documents and training peers
