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 pare
Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...