Programmer Analyst – Credentialing & Reporting (MSOW)

Required Skills & Experience

• Knowledge and understanding of MSOW application and credentialing data
• SSIS (Create/Maintain)
• T-SQL (Microsoft’s version of SQL) (very strong)

1. Stored Procedures
2. Dynamic Queries
3. Table Structures
4. Query Performance
5. Performance Improvement

Nice to Have Skills & Experience

• PowerShell (Payor file specific, due to requirements)
• Crystal Reports (Create/Maintain)
• Excel functions (Concat/VLookup)
• Server Management (research server issues)
• Windows Scheduler (schedule/maintain)

Job Description

We are seeking an experienced Programmer Analyst / Credentialing SQL Analyst to support reporting and data management activities within the organization's credentialing platform, Medical Staff Office for the Web (MSOW). This individual will serve as the primary reporting resource, responsible for developing, maintaining, and delivering credentialing, provider enrollment, and payer-related reports for internal customer groups. The ideal candidate will have strong SQL development skills, experience supporting healthcare credentialing applications, and the ability to work independently with minimal oversight. This role is critical in maintaining reporting operations and ensuring accurate provider data is delivered to stakeholders across the organization.

Key Responsibilities:

• Receive, analyze, and fulfill reporting requests related to provider credentialing, enrollment, and network management.
• Develop and maintain SQL-based reports utilizing data housed within the MSOW credentialing application.
• Create and maintain automated reporting solutions using SQL Server Integration Services (SSIS).
• Support recurring report distribution processes and scheduled file deliveries.
• Design, optimize, and troubleshoot complex T-SQL queries, stored procedures, and database objects.
• Analyze database structures and improve query performance.
• Generate provider lists, credentialing reports, network management files, and payer enrollment files.
• Research and resolve reporting and database-related production issues.
• Document reporting solutions, processes, and technical changes.
• Communicate proactively with stakeholders and project team members regarding status, risks, and deliverables. Participate in required meetings and provide support during critical production events when needed.