Senior Business Intelligence Data Analyst
About the position Become a part of our caring community and help us put health first Humana is seeking an individual for the Senior Business Intelligence Data Analyst to provide support for its pharmacy programs to achieve success on the Service Fund team. You will report to the Associate Director, Business Intelligence. Humana is seeking an individual for the Senior Business Intelligence Data Analyst to provide support for pharmacy programs, working heavily with market and finance partners to achieve success on the Service Fund team. This individual will be responsible for the development, implementation and valuation of new pharmacy programs, as well as the maintenance of current programs. Utilizes complex SQL, Azure Synapse Analytics, Databricks, and other technical skills to drive process improvement and assist in managing pharmacy program expense allocation Conducts research and produces reporting of monthly activity, providing an understanding of how the data reconciles and what it means for current and potential programs Assists in producing reports and completing ad hoc requests using Excel, PowerPoint, SQL, and other various analytical tools Provides support for payments to value-based specialists Aids in the evaluation of new pharmacy program opportunities Use your skills to make an impact Responsibilities • development, implementation and valuation of new pharmacy programs, as well as the maintenance of current programs • Utilizes complex SQL, Azure Synapse Analytics, Databricks, and other technical skills to drive process improvement and assist in managing pharmacy program expense allocation • Conducts research and produces reporting of monthly activity, providing an understanding of how the data reconciles and what it means for current and potential programs • Assists in producing reports and completing ad hoc requests using Excel, PowerPoint, SQL, and other various analytical tools • Provides support for payments to value-based specialists • Aids in the evaluation of new pharmacy program opportunities Requirements • Bachelor's degree and 5+ years of data analysis experience OR Master's degree and 3+ years of data analysis experience • 2+ years' advanced experience developing complex SQL queries • 1+ years' experience in Healthcare related data ie. Provider, Insurance, etc. • 1+ years' experience with pharmacy claims data • Advanced knowledge of Excel (ex. Pivot tables, Vlookups, formatting etc.) • Advanced experience working with big and complex data sets within large organizations • Proficiency in verbal and written communication to senior and executive leadership • You must be authorized to work in the US without Humana sponsorship as Humana does not provide work visa sponsorship for this role. • To ensure Home or Hybrid Home/Office associates’ ability to work effectively, the self-provided internet service of Home or Hybrid Home/Office associates must meet the following criteria: • At minimum, a download speed of 25 Mbps and an upload speed of 10 Mbps is recommended to support Humana applications, per associate. • Wireless, Wired Cable or DSL connection is suggested. • Satellite, cellular and microwave connection can be used only if they provide an optimal connection for associates. • The use of these methods must be approved by leadership. (See Wireless, Wired Cable or DSL Connection in Exceptions, Section 7.0 in this policy.) • Humana will not pay for or reimburse Home or Hybrid Home/Office associates for any portion of the cost of their self-provided internet service, with the exception of associates who live or work from Home in the state of California, Illinois, Montana, or South Dakota. • Associates who live and work from Home in the state of California, Illinois, Montana, or South Dakota will be provided a bi-weekly payment for their internet expense. • Humana will provide Home or Hybrid Home/Office associates with telephone equipment appropriate to meet the business requirements for their position/job. • Work from a dedicated space lacking ongoing interruptions to protect member PHI / HIPAA information Nice-to-haves • Advanced Degree in a quantitative discipline, such as Mathematics, Economics, Finance, Statistics, Computer Science, Engineering or related field • Experience in health insurance related data ie. Medicare, Medicaid, Claims, Premium Data, etc. • Experience with Azure Synapse Analytics and/or Databricks • Experience with Pyspark and/or Python • Experience with tools such as Power BI for creating data visualizations Benefits • Humana provides medical, dental and vision benefits, 401(k) retirement savings plan, time off (including paid time off, company and personal holidays, volunteer time off, paid parental and caregiver leave), short-term and long-term disability, life insurance and many other opportunities.