Data Analyst — Facets Configuration & SQL

viva; Mason (OH); On-site; USD 58,000 - 65,000; Full time

Job summary

Viva in Mason, OH is seeking a Data Analyst to configure managed vision care products in Facets, write SQL queries, and export data to Excel for analysis. You will support product structure and benefit plan setup for clients’ Vision Care programs and collaborate with cross-functional teams to ensure accurate configuration.

You will work onsite in Mason, contribute to process improvements, and handle production queue tasks with strong attention to quality and turnaround times.

Qualifications

• Associate degree or equivalent experience.
• 5+ years of experience in a core claims administration system.
• 2+ years of experience writing SQL queries and exporting data from databases into Excel.
• Strong analytical and problem-solving skills.
• Good communication and interpersonal skills.
• Ability to work independently or as part of a team.
• Ability to manage multiple complex assignments at once.

Responsibilities

• Act as a Data Analyst on the Business Configuration team for product structure and benefit plan setup for clients’ Managed Vision Care programs.
• Provide subject matter expertise for product configuration in the Facets system.
• Collaborate with client cross-functional teams to ensure configuration requests are handled efficiently and accurately.
• Configure all types of managed vision care products in the system using Product Key Sheet and manual configuration.
• Ensure product configuration accuracy using configuration tools for manual and automated product creation.
• Write SQL queries and export database data to Excel to analyze, troubleshoot, and resolve configuration issues.
• Handle and resolve product configuration questions and issues submitted to the Business Configuration production team without guidance.
• Maintain working relationships with Implementation Managers and Account Managers, supporting a cohesive cross-functional environment.

Skills

Analytical thinking

Problem solving

Communication

Teamwork

Education

Associate degree

Tools

SQL

Excel

Job description

Viva in Mason, OH is seeking a Data Analyst to configure managed vision care products in Facets, write SQL queries, and export data to Excel for analysis. You will support product structure and benefit plan setup for clients’ Vision Care programs and collaborate with cross-functional teams to ensure accurate configuration.

You will work onsite in Mason, contribute to process improvements, and handle production queue tasks with strong attention to quality and turnaround times.