Specialty Group Underwriting Systems Analyst
Brooklyn, Ohio
Employer: Medical Mutual
Industry: Specialty Products
Salary: Competitive
Job type: Full-Time
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)
Specialty Group Underwriting Systems Analyst I
Education and Experience
Technical Skills and Knowledge
Specialty Group Underwriting Systems Analyst II
Education and Experience
Technical Skills and Knowledge
Specialty Group Underwriting Systems Analyst III
Education and Experience
Technical Skills and Knowledge
Senior Specialty Group Underwriting Systems Analyst
Education and Experience
Technical Skills and Knowledge
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:
Excellent Benefits and Compensation:
An Investment in You:
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.
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.
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.
Created: 2024-08-27
Reference: 96742
Country: United States
State: Ohio
City: Brooklyn
Similar jobs:
-
Business Systems Analyst (Adobe, Braze, or Salesforce as Marketing enablement systems)
Experis in Toronto, Ohio -
Systems Analyst
AEG in Columbus, Ohio -
Senior Systems Analyst
Idealforce LLC in Columbus, Ohio -
UAS Unmanned Aircraft Systems Analyst
Leidos Holding in Beavercreek, Ohio💸 $65000.00 per year -
Business Systems Analyst (Marketing enablement systems - Adobe, Braze, or Salesforce)
Experis in Toronto, Ohio -
Senior Systems Analyst
Global Data Consultants, Inc in Columbus, Ohio -
Financial Systems Analyst
Defense Logistics Agency in Whitehall, Ohio -
Business Systems Analyst
System One Holdings, LLC in Whitehall, Ohio -
Sr. Payroll and Systems Analyst
Gables Search Group in North Canton, Ohio -
Expert Business Systems Analyst
Akkodis in SolonÎle, Ohio💸 $60.00 - $65.00 per hour -
Business Systems/Technical Analyst
CBRE in Cleveland, Ohio💸 $75000.00 per year -
Systems Analyst
Oxford Global Resources in Blue Ash, Ohio -
[HYBRID] Systems Testing & Requirements Business Analyst (BPA2)
Ohio Department of Aging in Columbus, Ohio💸 $36.99 per hour -
Sr. IT Systems Analyst Specialist
Experis in Dublin, Ohio💸 $40.00 - $50.00 per hour -
Business Systems Analyst I-IV
Medical Mutual in Brooklyn, Ohio -
CRM Business Systems Analyst I-IV
Medical Mutual in Brooklyn, Ohio -
Sr. Payroll & Systems Analyst Job Details | Timken
Timken in North Canton, Ohio -
Human Resources - Human Resources Information Systems Analyst
The Cincinnati Insurance Companies in Fairfield, Ohio💸 $55000 - $70000 per year -
Business Systems Analyst
Experis in Columbus/OH/United States, Ohio💸 $67 per hour