Business Intelligence Consultant delivering analytical capabilities and visual analytics for global specialty insurance. Collaborating with business partners to enhance data - driven decision - making.
MI
Onsite Business Intelligence Analyst
Posted 3 hours ago
About the role
- Business Intelligence Analyst providing business intelligence support for MercyCare’s Actuarial and Underwriting department. Handling data collection, reconciliation, reporting, and analysis for informed decision-making.
Responsibilities
- Provide business intelligence support for MercyCare’s Actuarial and Underwriting department along with other MercyCare directors, managers and clients in making informed business decisions based on past and present data collected, curated, reconciled and reported from all available data sources.
- 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.
Requirements
- Bachelors degree in a financial field with strong data handling and analysis skills.
- Directly related work experience will be considered in lieu of targeted degree (Five years prior business experience with spreadsheet design, databases, and ad hoc report writing programs required).
- Healthcare experience a plus.
- Relevant certifications preferred (i.e. SQL and Microsoft Office).
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.
Job title
Job type
Experience level
Salary
Degree requirement
Tech skills
Location requirements
Entry - Level Power BI Analyst at Mitsubishi Power supporting development and maintenance of Power BI reports. Collaborating with teams to ensure reporting consistency and data quality standards.
Senior Business Intelligence Analyst at Clio creating data solutions for better decision - making. Collaborating with stakeholders and enhancing business intelligence in a hybrid work environment.
SR BI ANALYST in an international insurance company analyzing and visualizing data. Collaborating with Finance and Operations areas to meet information needs.
Senior Specialized BI Analyst creating advanced business intelligence insights for Memorial Hermann's analytics team. Responsible for supporting critical business decisions across various organizational domains.
Business Intelligence Developer working on reporting and dashboard solutions for 32BJ Benefit Funds. Collaborating with senior developers to advance business insights through data analytics.
Intern supporting Business Intelligence Developer tasks while collaborating with professionals at Uline's corporate headquarters. Focusing on data integrations and analytics for business solutions.
BI Developer reviewing data and metrics on insider and cyber risks for SMBC at a hybrid workplace. Building visualizations and reports to foster security within the organization.
Senior Manager driving business intelligence initiatives for Snap’s Small & Mid - sized Clients business. Leading analytics team to transform insights into data - driven actions across Go - To - Market and Sales strategies.
Lead PowerBI Developer managing analytics solutions for People Analytics unit at Novo Nordisk. Collaborate across teams to drive data quality and decision - making through insights.