Mercy Health · 15 hours ago
Business Intelligence Analyst - MercyCare
Janesville, WI
Full-time
Onsite
Mid, Senior Level
$27/hr - $44/hr
5+ years expMercyhealth is seeking a Business Intelligence Analyst to provide support for MercyCare’s Actuarial and Underwriting department. The role involves making informed business decisions based on data analysis and reporting, while also maintaining and extracting information from various data sources.
Health CareNon Profit
Responsibilities
Maintenance and extraction of information from the data warehouse and other data sources with an emphasis on creating reports and visualizations for management
Monthly reconciliation with Finance of key control totals underpinning loss ratio reporting along with assistance in the reconciliation of reports developed outside of MercyCare (by MHS)
Annual maintenance of risk adjustment scoring algorithm and monthly updates of MercyCare risk scores to support reserving
Support prioritization of pended claim processing during Q1 of each calendar year for risk adjustment optimization
Assist Finance in the completion of Medicaid financial reporting
Monthly updating of enrollment and loss ratio budget vs. actual along with an analysis of variance
Support or completion of certain regulatory financial surveys, such as the EDGE Server baselines, NAIC survey and the 1332 Waiver survey
Auditing of operations as needed, such as an investigation of duplicate claims, Medicaid pricing or fee schedule analysis
Support of monthly commercial reinsurance notification and filing process
Development of utilization and cost trend reporting
Creation of data sets supporting ACA Single Risk Pool pricing and end of year Statement of Actuarial Opinion
Extraction and initial preparation of large group experience-rated renewals
Creation of additional meaningful utilization reports for large group clients
Staging of data for ad hoc actuarial studies
Qualification
Required
Bachelors degree in a financial field with strong data handling and analysis skills
Five years prior business experience with spreadsheet design, databases, and ad hoc report writing programs required
Preferred
Relevant certifications preferred (i.e. SQL and Microsoft Office)
Healthcare experience a plus
Company
Mercy Health
Mercy Health is a mission-driven, integrated healthcare organization.
10001+ employees
H1B Sponsorship
Mercy Health has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (8)
2021 (3)
2020 (12)
Funding
Current Stage
Late StageTotal Funding
$0.05MKey Investors
Appalachian Regional Commission
2024-09-18Grant· $0.05M
Leadership Team
Kenneth James
Market Chief Operating Officer, Cincinnati
Staci Lucius
President, Mercy Health Physicians
Recent News
Bizjournals.com Feed (2025-11-12 15:43:17)
2026-01-17
Lane Report | Kentucky Business & Economic News
2025-12-19
2025-11-14
Company data provided by crunchbase