[Hiring] Senior Technical Business Analyst @Gainwell Technologies LLC

Role Description

As a Senior Technical Business Analyst - CEF Configuration at Gainwell, you will serve as a hands-on technical analyst and SQL developer supporting Medicaid claims, healthcare data, and configuration-related solutions within a Maintenance & Operations environment. You will translate client requirements, Medicaid policy, operational needs, data relationships, and system-processing outcomes into technical specifications, advanced SQL solutions, custom stored procedures, validation utilities, and repeatable audit processes.

This role requires advanced SQL development skills, strong technical writing, and the ability to work across business analysis and development responsibilities. The ideal candidate can independently analyze complex data and system issues, document the technical design for a custom stored procedure, develop or modify the code, validate results, and clearly communicate the solution, risks, and downstream impacts to technical and non-technical stakeholders.

Qualifications

• Advanced SQL development expertise, including complex joins, subqueries, common table expressions, window functions, temporary tables, dynamic SQL, transactions, error handling, performance tuning, and custom stored procedure development.
• Demonstrated technical writing experience creating detailed, developer-ready specifications for stored procedures, database solutions, data corrections, interfaces, or similar technical components.
• Five or more years of combined education and relevant work experience in technical business analysis, SQL or database development, healthcare data analysis, systems analysis, claims processing, or a related technical discipline.

Requirements

• Thorough understanding of relational database concepts, normalized data models, schemas, tables, views, keys, indexing, referential integrity, and parent-child data relationships.
• Ability to create safe update scripts using transactions, validation checks, affected-row controls, rollback logic, audit logging, and reconciliation queries.
• Experience building automated audit or data-quality processes for large record populations.
• Strong knowledge of Medicaid claims processing, claims adjudication, provider reimbursement, benefits, pricing, edits, encounters, and financial processing.
• Experience analyzing X12 healthcare transactions, including 837 and 835 data and associated claim adjustment reason and remittance advice remark codes.
• Experience with SQL Server Management Studio, source control such as Git or Azure DevOps, work-tracking tools such as Jira or ServiceNow, and structured release-management practices.
• Strong analytical, problem-solving, communication, facilitation, and stakeholder-management skills.
• Relevant postsecondary education in Computer Science, Information Systems, Data Analytics, Health Informatics, Business Administration, or a related discipline may count toward the combined education and experience requirement.

Benefits

• Generous, flexible vacation policy.
• 401(k) employer match.
• Comprehensive health benefits.
• Educational assistance.
• Leadership and technical development academies to help build your skills and capabilities.

Company Description

Gainwell Technologies is an Equal Opportunity Employer, where all qualified applicants will receive consideration for employment without regard to race, religion, color, national origin, gender (including pregnancy, childbirth, or related medical condition), age, sexual orientation, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.