Medical Data Analyst / Programmer

Company DescriptionWe have been focused on delivering innovative group benefits for over 30 years. Fully-customizable programs give companies the peace of mind that comes from top quality protection at prices that help protect the bottom line. Our full product line includes Medical, RX, Wellness, Dental, Life, Disability, and Vision.

Nippon Life Benefits is the U.S. subsidiary of Japan-based Nippon Life Insurance Company, one of the world’s largest mutual life insurance companies with over $520 billion in assets.

We are proud of our A- (Excellent) rating from AM Best.

Role DescriptionThis is a full-time role for a Medical Data Analyst / Programmer with a hybrid work schedule. As a Medical Data Analyst / Programmer, you will contribute to the success of the Underwriting Department through the implementation of new technology for Underwriting. Responsibilities include maintaining and improving the Proposal System (Stepwise/Gateway) used to illustrate our proposals and generate renewals. You will also be responsible for maintaining database warehouse. Serve as a technical resource to the department in matters related to Underwriting, risk selection, etc.

Nature and Scope of ResponsibilitiesDevelop, maintain, and support existing Microsoft VBA, MS Word Document customization, OptumStepwise rating system, and analyze and convert business requirements as needed.Create SQL stored procedures/queries, enhance existing data objects and actively mitigate potential data credibility issues. Responsible for working with outside vendor (OPTUM) on new business rating system and any issues related to the system.Translate algorithms from filed rate manuals into Underwriting tools and Optum StepWise rating system to meet business, end user, and regulatory requirements.Load monthly claims and premium data for Underwriting to complete monthly renewals.Address any system related issues that are brought to attention.Ensure compliance with State Laws with regard to rating and update our benefit summaries and SBCs.Provide reports on status of new business activity, renewals, sales and other ad hoc reports as deemed necessary.Work with Trustmark on data transfers, special projects, reporting, etc.Perform other tasks as requested.

QualificationsBachelor's degree in Computer Science, Data Science, Information Systems, or a related field5+ years experience with data analysis, programming, and/or statistical modelingProficiency in SQL, VBA and programming languages such as Python or RStrong analytical and problem-solving skillsKnowledge of Group insurance with an emphasis on Underwriting preferredAbility to work independently and collaboratively in a team environment Excellent communication and presentation skillsThis position may be remote or hybrid (reliably commute to office in Midtown Manhattan 2 to 3 days a week preferred)

Pay: $70,000.00 - $95,000.00 per year(inclusive of a merit-based bonus, dependent on years of experience, level of education obtained, location as well as applicable skillset) and an excellent benefits package, including a comprehensive benefit plan, generous employer match for 401k and employer paid Money Purchase retirement plan.

This position outline reflects the general responsibilities and level of work being performed by employees in this position. It is not intended to be an exhaustive list of all duties, responsibilities and qualifications of employees assigned to this position. Nothing in this position outline restricts management's rights to assign or reassign duties and responsibilities to this job at any time.