SQL Developer

Alera Group

6h • $80,000 - $100,000 • Remote

About The Position

Alera Group is looking for a SQL Developer to join our Vital Incite team in Indianapolis, IN.

Alera Group was founded in 2017 and has grown to become the 14th largest broker of US business. We are passionate about our clients’ success in the areas of Employee Benefits, Property and Casualty Insurance, Retirement Plan Services, and Wealth Services. With a network of offices nationwide, our commitment to collaboration allows us to offer national resources combined with local service.

Requirements

• 4+ years of Microsoft SQL Server development experience, including writing and debugging T‑SQL (queries, stored procedures, views, and functions) using SQL Server Management Studio and Visual Studio
• Strong data analysis skills, with experience querying data, analyzing trends, diagnosing discrepancies, and troubleshooting SQL logic to understand data transformations and outcomes

Nice To Haves

• Preferred experience with healthcare claims data and SSIS

Responsibilities

• Diagnose support tickets by researching the source of data issues to determine root causes including invalid data, logic issues, or the need for enhancements to the system. Perform analysis by querying the database to determine how the data exists and the reason it is not being properly represented in our systems or what is causing it to not process correctly through our custom logic
• Use TSQL to develop and maintain database structure, stored procedures, and data to support our custom logic
• Debug stored procedures and dynamic SQL to correct issues with logic or identify the cause of failures. Determine the appropriate solution to the issue, implement the correction, and verify the solution is working correctly
• Manage tickets in a timely manner based on prioritization to support the business needs for accurate data reporting
• Maintain and support Vital Incite’s proprietary data mapping process to ingest data files directly into Vital Incite warehouse

Benefits

• Alera Group offers comprehensive benefits to our colleagues, including medical, dental, life and disability insurance, 401k, generous paid time off and much more.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed