<span>Data Analyst II</span>

$75,000 - $85,000/Yr

Navia Benefit Solutions - Moraine, OH

Full-time - Mid Level

Remote - Moraine, OH

Insurance Carriers and Related Activities

About the position

The Data Analyst II position at Navia Benefit Solutions involves supporting data requests related to data integrations, migrations, and EDI with external trading partners. The role requires guiding projects to completion, maintaining EDI standards, and developing Power BI visualizations. The analyst will also need to understand business requirements and ensure compliance with industry standards while collaborating with internal and external partners.

Responsibilities

• Support data requests for data integrations and migrations.
• Maintain EDI standards and implementation guides for data exchange requirements.
• Set up new trading partners, including coordination of optional fields and testing.
• Develop and maintain relationships with external trading partners.
• Act as a focal point for transactional data exchanges between Navia and trading partners.
• Troubleshoot transactional data exchanges with internal departments and external trading partners.
• Identify system problems and recommend solutions to improve processing efficiency and stability.
• Communicate issues to management with a strong focus on customer service.
• Interface with business analysts and product owners to turn project requirements into specifications for development.
• Assist in developing Boomi processes where subject matter expertise is required.
• Conduct data quality analysis using T-SQL scripts and/or Excel macros.

Requirements

• 2-5 years of COBRA benefit experience.
• Familiarity with the 834 EDI document standard.
• 1-2 years of T-SQL coding experience or ability to read T-SQL code.
• Familiarity with SQL Server Management Studio (SSMS).
• 1-2 years of Power BI experience in creating data models, visualizations, and transformations.
• 1-2 years of Boomi development experience in creating EDI processes.
• Strong written and verbal communication skills.
• High attention to detail with large volumes of data.
• Ability to self-manage and prioritize tasks with strict deadlines.
• Basic knowledge of Microsoft Word, Outlook, Excel, Access, Adobe, XML, and JSON.