Junior Financial Data Analyst

Description

Humana is seeking a Junior Financial Data Analyst to join the Wisconsin Medicaid Market (iCare) team. The Junior Financial Data Analyst is responsible for data analysis, reporting, and operational analysis for departments throughout Humana/iCare as needed. Join this dedicated team and lead change in how health care for the underserved in Wisconsin is managed.

Responsibilities

• Assist in the preparation, review and reconciliation of the encounter submissions to the various governmental agencies (State and Federal).
• Provide information necessary to assist the contracting department during rate negotiations and assist in the developing of standardized rates.
• Integrate clinical and operational data into information that can be used to support committee and Board of Director reports.
• Perform ad hoc data analysis and reporting through the creation and use of SQL language queries and incorporating results in readable formats such as Excel, Power BI and/or PDF documents.
• Provide reports to analyze existing trends and research the elements causing the trends.
• Develop and analyze reports on various projects like Hierarchical Condition Categories (“HCC”) prospective member assessments and the Five-Star Program, to create operational efficiencies and improve financial performance.
• Create monthly saving initiative, managerial and Board of Director reports.
• Reconcile and research variances between paid claims and the check register.
• Provide backup to reconciliation duties performed by other financial data analyst.
• Provide backup to administrative expense development for HCC year-end accrual documentation and adjustments, development of projection models, and interactions with external vendors.
• Provide back-up assistance to the Senior and/or Lead Financial Data Analyst in providing governmental monitoring reports.
• Analyze and balance data results to ensure accuracy of the data results.
• Assist in developing systematic approaches to create efficiencies in reporting and operational procedures.

               

Required Qualifications

• Bachelor’s degree in Business, Finance, Accounting, Information Systems Management, or related field.
• Highly skilled and proficient with Excel as well as a working knowledge of Microsoft Access.
• Experience working with and analyzing large data sets.
• 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; wireless, wired cable or DSL connection is suggested.
  • Satellite, cellular and microwave connection can be used only if approved by leadership.
  • 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.

Preferred Qualifications

• Experience in analyzing data by writing complex queries in SQL
• Experience with Power BI
• Knowledge and experience in working with statistical data, formulas and actuarial tables.

Additional Information

• Workstyle: Home. Home workstyle is defined as remote but will use Humana office space on an as needed basis for collaboration and other face-to-face needs.  
• Typical Work Days/Hours: Monday - Friday, 8:30 – 5:00 pm CST
• Benefits: Benefits are effective on day 1. Full time Associates enjoy competitive pay and a comprehensive benefits package that includes: 401k, Medical, Dental, Vision and a variety of supplemental insurances, tuition assistance and much more!

Interview Format

As part of our hiring process, we will be using an exciting interviewing technology provided by Modern Hire, a third-party vendor.  This technology provides our team of recruiters and hiring managers an enhanced method for decision-making.

If you are selected to move forward from your application prescreen, you will receive correspondence inviting you to participate in a pre-recorded Voice Interview and/or an SMS Text Messaging interview.  If participating in a pre-recorded interview, you will respond to a set of interview questions via your phone. You should anticipate this interview to take approximately 10-15 minutes.

If participating in a SMS Text interview, you will be asked a series of questions to which you will be using your cell phone or computer to answer the questions provided.  Expect this type of interview to last anywhere from 5-10 minutes. Your recorded interview(s) via text and/or pre-recorded voice will be reviewed, and you will subsequently be informed if you will be moving forward to next round of interviews.

Social Security Alert

Humana Values personal identity protection. Please be aware that applicants selected for leader review may be asked to provide a social security number, if it is not already on file. When required, an email will be sent from Humana@myworkday.com with instructions to add the information into the application at Humana’s secure website.

#LI-JP1

#LI-Remote

This is a remote position

Scheduled Weekly Hours

40