Our Values


Financial Data Analyst - SQL

    • Job Tracking ID: 512689-622843
    • Job Location: Milwaukee, WI
    • Job Level: Mid Career (2+ years)
    • Level of Education: BA/BS
    • Job Type: Full-Time/Regular
    • Date Updated: September 25, 2018
    • Years of Experience: 2 - 5 Years
    • Starting Date: ASAP
Invite a friend
facebook LinkedIn Twitter Email

Job Description:

  1. Prepare, review and reconcile the encounter submissions to the various governmental agencies (State and Federal).
  2. Provide information necessary to assist the contracting department during rate negotiations and assist in the developing of standardized rates.
  3. Review Patient Protection and Affordable Care Act ("PPACA") distribution analysis received from the State of Wisconsin to identify any abnormalities in the detailed data.
  4. Integrate clinical and operational data into information that can be used to support committee and Board of Director reports.
  5. 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 and/or PDF documents.
  6. Provide reports to analyze existing trends and research the elements causing the trends
  7. 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.
  8. Compile and provide Medicare Advantage Bid documents to actuaries.
  9. Analyze the year-end Part D reconciliation from Centers for Medicare and Medicaid Services ("CMS").
  10. Creation of monthly saving initiative, managerial and Board of Director reports.
  11. Reconcile and research variances between paid claims and the check register.

Experience and Skills:

  1. Bachelor’s Degree in Business/Finance/Accounting, Information Systems Management, or related field.
  2. Three to five years’ experience in analyzing data by writing complex queries in SQL.Experience with Business Objects and SAS software is a plus.
  3. Knowledge and experience in working with statistical data, formulas and actuarial tables.
  4. Highly skilled and proficient with spreadsheet, and word processing software as well as obtaining information from databases through SQL and a working knowledge of Microsoft Access.
  5. Three years’ experience working in a managed care environment preferred.Exposure to Medicare is also preferred.


  • Medical
  • Dental
  • Vision
  • Short Term and Long Term Disability
  • Life Insurance
  • 401k
  • Generous PTO Policy
  • On-Site Fitness Center
  • On-Site Wellness Program


  • Independent Care Health Plan
  • 1555 RiverCenter Drive, Suite 206
  • Milwaukee, WI 53212
  • All content and images unless otherwise indicated are
  • Copyright © 2017 Independent Care Health Plan