Programmer Analyst – Credentialing & Reporting (MSOW)

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.

Skills and Requirements

• Knowledge and understanding of MSOW application and credentialing data
• SSIS (Create/Maintain)
• T-SQL (Microsoft’s version of SQL) (very strong)
• Stored Procedures
• Dynamic Queries
• Table Structures
• Query Performance
• Performance Improvement
• PowerShell (Payor file specific, due to requirements)
• Crystal Reports (Create/Maintain)
• Excel functions (Concat/VLookup)
• Server Management (research server issues)
• Windows Scheduler (schedule/maintain)

We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal employment opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment without regard to race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or the recruiting process, please send a request to HR@insightglobal.com.