Claims Data Quality Analyst

McNeil & Co.; Morristown (NJ); On-site; USD 68,000 - 102,000; Full time

Benefits offered by this job

Medical plans

Dental/Vision/Prescription coverage

401k with generous matching

PTO 20 days

Holidays

Parental Leave

Student Loan Assistance

Tuition Reimbursement

Backup Child/Elder Care

Volunteer Time Off

Job summary

Arch Insurance Group Inc. is seeking a Data Quality Analyst to join our Claims Operations Team in Morristown, NJ. The role focuses on examining complex data to ensure integrity and accuracy within various systems and processes.

Responsibilities include analyzing claims data, resolving data exceptions, identifying root causes, and delivering ad-hoc reporting to internal and external partners. Bachelor’s degree preferred with strong SQL and data quality skills.

Qualifications

• Hands-on SQL experience and data quality focus.
• Knowledge of insurance claims operations, especially commercial property & casualty.
• Adherence to data quality standards to ensure accuracy.
• Strong time management and organizational skills.
• Ability to work independently.

Responsibilities

• Analyze, query, and manage claims corrections according to defined business rules and procedures.
• Research and determine scope and complexity of issues, then identify steps to resolve data exceptions.
• Determine root cause for data quality errors and recommend long-term solutions.
• Determine business impact level for data quality issues.
• Collaborate with cross-functional teams (TPA, programmers, vendors) to analyze and correct data quality errors.
• Produce ad-hoc reporting for TPA, Business, IT teams, and external partners.

Skills

SQL

Snowflake

Insurance claims domain knowledge

Data quality standards

Time management

Independence

Education

Bachelor’s degree

Tools

Snowflake

Job description

With a company culture rooted in collaboration, expertise and innovation, we aim to promote progress and inspire our clients, employees, investors and communities to achieve their greatest potential. Our work is the catalyst that helps others achieve their goals. In short, We Enable Possibility.

Position Summary

The Claims Division is seeking a team member to join the Claims Operations Team as a Data Quality Analyst. In this role the responsibilities include, but not limited to, examining complex data to ensure data integrity and accuracy.

Responsibilities

• Analyze, query, and manage claims corrections according to defined business rules and procedures Research and determine scope and complexity of issue then identify steps to resolve all internal data exceptions within various systems in timely and accurate manner Determine root cause for data quality errors and make recommendations for long-term solutions Determine business impact level for data quality issues Collaborate and maintain cross-functional working relationships with team members of multiple business units; Claims Third-party Administrators (TPA), Programmers, and approved vendors to analyze and correct data quality errors Produce ad-hoc reporting for TPA, Business, IT teams, and external partners

Experience & Required Skills

• Hands-on experience and strong aptitude with SQL, with some experience in Snowflake preferred
• Working knowledge of insurance industry and insurance claims operations particularly in the area of commercial property and casualty claims
• Adherence to data quality standards to ensure accuracy and provide logical approach to identify, compare, resolve, and improve data quality
• Strong organization and time management skills
• Ability to self-start and work independently

Education Bachelor’s degree preferred

For individuals assigned or hired to work in the location(s) indicated below, the base salary range is provided. Range is as of the time of posting. Position is incentive eligible. $75,000 - $95,000/year Total individual compensation (base salary, short & long-term incentives) offered will take into account a number of factors including but not limited to geographic location, scope & responsibilities of the role, qualifications, talent availability & specialization as well as business needs. The above pay range may be modified in the future.

Arch is committed to helping employees succeed through our comprehensive benefits package that includes

• multiple medical plans plus dental, vision and prescription drug coverage
• competitive 401k with generous matching
• PTO beginning at 20 days per year
• up to 12 paid company holidays per year plus 2 paid days of Volunteer Time Offer
• basic Life and AD&D Insurance as well as Short and Long-Term Disability
• Paid Parental Leave of up to 10 weeks
• Student Loan Assistance and Tuition Reimbursement, Backup Child and Elder Care
• and more.

14400 Arch Insurance Group Inc. Arch Capital Group Ltd. is a Bermuda-based specialty insurer that provides insurance, reinsurance and mortgage insurance on a worldwide basis. With a 20+-year track record of delivering results and a coveted position on the S&P 500 index, Arch is a great place to grow your career.