Medical Data Analyst

Position Outline

Position: Data Analyst
Department: Group Underwriting
Reports to: AVP - Renewal Underwriting
Location: New York, NY - Hybrid / Remote

Position Purpose:
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. This role is also responsible for maintaining database warehouse. Serve as a technical resource to the department in matters related to Underwriting, risk selection, etc.

Essential Functions of the Job:

• Work with various departments on business related requests to further improve our rating system.
• Ensure all rates, benefits, and premium/claim information is loaded into our system with no issues on a monthly basis.

Nature and Scope of Responsibilities:

• Develop, maintain, and support existing Microsoft VBA, MS Word Document customization, Optum Stepwise 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.

Qualifications / Requirements:

• Bachelor’s degree or business equivalent experience.
• 5+ years of programming and database experience.
• Programming skills required (VBA, SQL).
• Strong database skill required.
• Proficiency in MS Office products (Word, Excel, PowerPoint & Outlook).
• Strong communication, organization and interpersonal skills.
• Knowledge of Group insurance with an emphasis on Underwriting preferred.
• Ability to work in the office 3 days a week.

Competencies:

• Professionalism - Approaches others in a tactful manner; Reacts well under pressure; Treats others with respect and consideration regardless of their status or position; Accepts responsibility for own actions; Follows through on commitments.
• Judgment - Displays willingness to make decisions; Exhibits sound and accurate judgment; Supports and explains reasoning for decisions; Includes appropriate people in decision-making process; Makes timely decisions.
• Teamwork - Balances team and individual responsibilities; Exhibits objectivity and openness to others' views; Gives and welcomes feedback; Contributes to building a positive team spirit; Puts success of team above own interests; Able to build morale and group commitments to goals and objectives; Supports everyone's efforts to succeed.
• Analytical - Synthesizes complex or diverse information; Collects and researches data; Uses intuition and experience to complement data; Designs workflows and procedures.

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.

Job Type: Full-time

Pay: $70,000.00 - $90,000.00 per year

Benefits:

• 401(k)
• 401(k) matching
• Dental insurance
• Flexible spending account
• Health insurance
• Health savings account
• Life insurance
• Paid time off
• Parental leave
• Tuition reimbursement
• Vision insurance

Schedule:

• 8 hour shift
• Monday to Friday

Ability to commute/relocate:

• New York, NY 10017: Reliably commute or planning to relocate before starting work (Preferred)

Education:

• Bachelor's (Required)

Experience:

• VBA: 5 years (Required)
• SQL: 5 years (Required)
• Database management: 5 years (Required)
• health insurance industry: 3 years (Preferred)
• Underwriting: 5 years (Preferred)

Work Location: Hybrid remote in New York, NY 10017