Junior Financial Data Analyst

R-309568
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 developing systematic approaches to create efficiencies in reporting and operational procedures.
• Reconcile and research variances between paid claims and the check register.
• Analyze and balance data results to ensure accuracy of the data results.
• Create monthly saving initiative, managerial and Board of Director reports.
• 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.
• Provide backup to reconciliation duties performed by other financial data analyst.
• Provide information necessary to assist the contracting department during rate negotiations and assist in the developing of standardized rates.
• 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.
• Assist in the preparation, review and reconciliation of the encounter submissions to the various governmental agencies (State and Federal).
• Provide backup to administrative expense development for HCC year-end accrual documentation and adjustments, development of projection models, and interactions with external vendors.
• Provide reports to analyze existing trends and research the elements causing the trends.
• Integrate clinical and operational data into information that can be used to support committee and Board of Director reports.
• Provide back-up assistance to the Senior and/or Lead Financial Data Analyst in providing governmental monitoring reports.

Required Qualifications

• Humana will provide Home or Hybrid Home/Office associates with telephone equipment appropriate to meet the business requirements for their position/job.
• Highly skilled and proficient with Excel as well as a working knowledge of Microsoft Access.
• 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.
• Bachelor’s degree in Business, Finance, Accounting, Information Systems Management, or related field.
• 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:
• Work from a dedicated space lacking ongoing interruptions to protect member PHI / HIPAA information.
• Experience working with and analyzing large data sets.

Preferred Qualifications

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

Additional Information

• Typical Work Days/Hours: Monday - Friday, 8:30 – 5:00 pm CST
• 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.
• 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 [email protected] with instructions to add the information into the application at Humana’s secure website.
This is a remote position
Scheduled Weekly Hours
40