Remote Pharmacy Data Analyst

Must Haves:Bachelors Degree4+ years of experience with data analytics experience, preferably within a healthcare entityAdvanced knowledge and use of ExcelAdvanced knowledge and demonstrated skill in building, maintaining, and querying large databases in SQL from disparate data sources.Advanced skills in data aggregation, cleaning, and analysis. Demonstrated ability to create, maintain, and query large data sets to create concise executive management reports and guidance.Excellent organizational skills and demonstrated ability to work independently.Must possess strong communication and written skills. Plusses:Extensive knowledge of 340BEPIC experience Day-to-Day:Insight Global is looking for remote Pharmacy Data Analyst for a major health system based out of the Charleston, SC area. This person conducts complex analyses and reporting solutions to support the system pharmacy decision making. Leveraging data from different platforms, this person is responsible for normalizing, aggregating, and reporting pharmacy, financial, supply chain, and prescribing data to support leaders and other stakeholders throughout the organization.Compile, standardize, aggregate, and analyze data to develop strategies for process enhancements and program modifications.Develop and build predictive models and databases as needed for program maintenance and analysis.Process, clean and verify the integrity of the data used for analysis.Identify and analyze risk as it pertains to program compliance and financial trends.Analyze monthly, quarterly and annual trends to identify and investigate irregularities or variances in prescribing, compliance, financial and other identified metrics related across system pharmacy.Validate 340B prices, supply chain contracts, and cost savings initiatives for related programs and internal processes.Improve and automate current manual processes to increase accuracy, productivity and reduce errors for all related processes when needed.Develop and maintain technical processes for management and optimization of pharmacy programs.Performs detailed project gap analyses between current and future state of pharmacy systems and provides input to shape project plans that meet future state goals.Create and distribute “scorecards” in key areas to member hospitals and system leadership, focusing on key areas of compliance and financial performance.Assist and assess data submission request for 340B and other pharmacy related audits.Create and maintain related standard operating procedures.Apply analytical processes to evaluate large 340B and other data sets to provide actionable insights and drive decision making for senior executives.Maintain and report monthly program dashboards for key metrics such as 340B prescription capture, financial savings, reconciliation, and contract pricing utilization.Convert data analysis results in clear and compelling narratives to inform and educate other departments including finance and supply chain.Assist with quarterly financial risk assessments for executive management and board committees to identify areas of potential exposure.Keep abreast of 340B landscape to better contextualize 340B data and understand organization implications.Respond to departmental analytical requests as it relates to pharmacy data and reporting solutions.Collaborate with other departments to support cross-organizational projects and assist with quality improvement.