Specialty Group Underwriting Systems Analyst

Founded in 1934, Medical Mutual is the oldest and one of the largest health insurance companies based in Ohio. We provide peace of mind to more than 1.

2 million members through our high-quality health, life, disability, dental, vision and indemnity plans. We offer fully insured and self-funded group coverage, including stop loss, as well as Medicare Advantage, Medicare Supplement, and individual plans.

Supporting the underwriting system, the Specialty Group Underwriting Systems Analyst collaborates with other system developers and liaisons to translate user requirements and systems objectives of increasing complexity into a logical, efficient and optimal systems design.

This role develops and maintains new and existing applications by writing code to ensure that business rules, security standards and government regulations are met.

Performs data analysis by writing queries to pull and validate data, which may be also used for reporting and ad hoc projects as requested by management.

Provides consultative and analytical insights about forecasting, management reporting, and other tactical sales metrics to guide decision for growth and retention of specialty product business.

This position has the option to work hybrid; Cleveland, Ohio area residents preferred.

Responsibilities

Specialty Group Underwriting Systems Analyst (I, II, III, Senior)

• Develops and maintains underwriting system application by analyzing, designing, and writing code of increasing complexity that satisfies a logical, efficient, and optimal systems design.
• Develops and creates reporting to support the specialty products division underwriting, sales and account management, which support our internal and external customers.
• Creates data analytics to monitor and manage the specialty product book of business ,including segmentation analysis, quarterly analysis and reporting, and reporting to VP and Executive staff.

Completes additional ad hoc reporting projects as needed.

• Supports testing, implementation, and break-fix tasks of underwriting systems.
• Learns new technical concepts and software languages.
• Works with database staff and security staff to ensure that data standards and security standards are properly applied.
• Assists underwriting staff with use of systems, tools and formulas.
• Performs other duties as assigned.

Qualifications

Qualifications

Specialty Group Underwriting Systems Analyst I

Education and Experience

• Bachelor's degree in Computer Science, Business, Math, or related field.
• 0-1 years of work experience in maintaining and developing business systems.

Technical Skills and Knowledge

• Basic understanding of programming design and coding techniques.
• Basic understanding and familiarity with SAS, SQL, Office and other components of Microsoft technology (Access, Excel specifically).
• Basic understanding of DB2 and VB.
• Basic knowledge of insurance concepts is preferred.
• Knowledge of data analysis and report design / development.

Specialty Group Underwriting Systems Analyst II

Education and Experience

• Bachelor's degree in Computer Science, Business, Math, or related field.
• 1-2 years of work experience in maintaining and developing business systems.

Technical Skills and Knowledge

• Ability to apply basic programming design and coding techniques.
• Ability to apply basic SAS, SQL, Office and other components of Microsoft technology (Access, Excel specifically).
• Understanding of DB2 and VB.
• Knowledge of underwriting concepts & techniques and general knowledge of employee benefits (group life, disability, dental, vision) is preferred.
• Working knowledge of data analysis and report design / development.

Specialty Group Underwriting Systems Analyst III

Education and Experience

• Bachelor's degree in Computer Science, Business, Math, or related field.
• 3-4 years of work experience in maintaining and developing business systems.

Technical Skills and Knowledge

• Solid understanding of programming design and coding techniques.
• Solid understanding and familiarity with SAS, SQL, Office and other components of Microsoft technology (Access, Excel specifically).
• Preferred solid understanding of DB2 and VB.
• Basic understanding of Optum's Stepwise Formula Designer.
• Knowledge of underwriting concepts & techniques and general knowledge of employee benefits (group life, disability, dental, vision) is preferred.
• Experience in Data analysis and report design / development.

Senior Specialty Group Underwriting Systems Analyst

Education and Experience

• Bachelor's degree in Computer Science, Business, Math, or related field.
• 5 years of work experience in maintaining and developing business systems.

Technical Skills and Knowledge

• Advanced understanding of programming design and coding techniques.
• Advanced understanding and familiarity with SAS, SQL, Office and other components of Microsoft technology (Access, Excel specifically)
• Solid understanding of DB2 and VB
• Advanced understanding of Optum's Stepwise Formula Designer.
• Knowledge of underwriting concepts & techniques and solid understanding of specialty division products (group life, disability, dental, vision)
• Experience in Data analysis and report design / development

Medical Mutual is looking to grow our team! We truly value and respect the talents and abilities of all of our employees.

That's why we offer an exceptional package that includes :

A Great Place to Work :

• We will provide the equipment you need for this role, including a laptop, monitors, keyboard, mouse and headset.
• Whether you are working remote or in the office, employees have access to on-site fitness centers at many locations, or a gym membership reimbursement when there is no Medical Mutual facility available.

Enjoy the use of weights, cardio machines, locker rooms, classes and more.

• On-site cafeteria, serving hot breakfast and lunch, at the Brooklyn, OH headquarters.
• Discounts at many places in and around town, just for being a Medical Mutual team member.
• The opportunity to earn cash rewards for shopping with our customers.
• Business casual attire, including jeans.

Excellent Benefits and Compensation :

• Employee bonus program.
• 401(k) with company match up to 4% and an additional company contribution.
• Health Savings Account with a company matching contribution.
• Excellent medical, dental, vision, life and disability insurance insurance is what we do best, and we make affordable coverage for our team a priority.
• Access to an Employee Assistance Program, which includes professional counseling, personal and professional coaching, self-help resources and assistance with work / life benefits.
• Company holidays and up to 16 PTO days during the first year of employment with options to carry over unused PTO time.
• After 120 days of service, parental leave for eligible employees who become parents through maternity, paternity or adoption.

An Investment in You :

• Career development programs and classes.
• Mentoring and coaching to help you advance in your career.
• Tuition reimbursement up to $5,250 per year, the IRS maximum.
• Diverse, inclusive and welcoming culture with Business Resource Groups.

About Medical Mutual :

Medical Mutual's status as a mutual company means we are owned by our policyholders, not stockholders, so we don't answer to Wall Street analysts or pay dividends to investors.

Instead, we focus on developing products and services that allow us to better serve our customers and the communities around us.

There's a good chance you already know many of our Medical Mutual customers. As the official insurer of everything you love, we are trusted by businesses and nonprofit organizations throughout Ohio to provide high-quality health, life, disability, dental, vision and indemnity plans.

We offer fully insured and self-funded group coverage, including stop loss, as well as Medicare Advantage, Medicare Supplement and individual plans.

Our plans provide peace of mind to more than 1.2 million Ohioans.

We're not just one of the largest health insurance companies based in Ohio, we're also the longest running. Founded in 1934, we're proud of our rich history with the communities where we live and work.

We maintain a drug-free workplace and perform pre-employment substance abuse and nicotine testing.