Mercyhealth Wisconsin and Illinois ยท 8 hours ago
Business Intelligence Analyst - MercyCare
US-WI-Janesville
Full-time
Hybrid
Mid, Senior Level
5+ years expMercyhealth Wisconsin and Illinois is seeking a Business Intelligence Analyst to provide support for their Actuarial and Underwriting department. The role involves data management, report generation, and financial reconciliation to aid in informed decision-making for the organization.
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
Benefits
Comprehensive Benefits Package: Mercyhealth offers a retirement plan with competitive matching contribution, comprehensive medical, dental, and vision insurance options, life and disability coverage, access to flexible spending plans, and a variety of other discounted voluntary benefit options.
Competitive Compensation: Mercyhealth offers market competitive rates of pay and participates in various shift differential and special pay incentive programs.
Paid Time Off: Mercyhealth offers a generous paid time off plan, which increases with milestone anniversaries, to allow employees the opportunity for a great work-life balance.
Career Advancement: Mercyhealth offers a number of educational assistance programs and career ladders to support employees in their educational journey and advancement within Mercyhealth.
Employee Wellbeing: Mercyhealth has a focus on wellbeing for employees across the organization and offers a number of tools and resources, such as an employer-sponsored health risk assessment and a Wellbeing mobile application, to assist employees on their wellbeing journey.
Additional Benefits: Mercyhealth employees have access to our internal and external employee assistance programs, employee-only discount packages, paid parental and caregiver leaves, on-demand pay, special payment programs for patient services, and financial education to help with retirement planning.
Company
Mercyhealth Wisconsin and Illinois
At Mercyhealth, our doctors, nurses and staff are committed to making lives better for our patients and their families.
5001-10000 employees
H1B Sponsorship
Mercyhealth Wisconsin and Illinois 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
2025 (2)
2024 (5)
2023 (6)
2020 (1)
Funding
Current Stage
Late StageLeadership Team
Nathan Schultz
Chief Technology Officer
Shawn David
Chief Technology Officer / Chief Security Officer IMS Technical Director
Company data provided by crunchbase