Junior Financial Data Analyst
Company: Humana
Location: Lancaster
Posted on: May 28, 2023
|
|
Job Description:
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
Humana complies with all applicable federal civil rights laws and
does not discriminate on the basis of race, color, national origin,
age, disability, sex, sexual orientation, gender identity or
religion. We also provide free language interpreter services. See
our
https://www.humana.com/legal/accessibility-resources?source=Humana_Website.
Keywords: Humana, Lancaster , Junior Financial Data Analyst, Professions , Lancaster, Pennsylvania
Click
here to apply!
|