Senior Technical Business Analyst – CEF Configuration

🕒 November 10

💵 $69.4k - $99.2k / year

⏰ Full Time

🟡 Mid-level

🟠 Senior

🧐 Business Analyst

Where this job comes from

Posted on Gainwell Technologies's careers page ↗Gainwell Technologies's careers page, not through a job board

First seen by Remote Rocketship November 10

Still open on Gainwell Technologies's site. Checked 23 minutes ago.

Apply Now
Logo of Gainwell Technologies

Gainwell Technologies

10,000+ employees

💼 Consulting

📦 Logistics

⚕️ Healthcare Insurance

💰 Grant on 2023-06

Consulting • Logistics • Healthcare Insurance

Gainwell Technologies is the nation’s leading provider of digital and cloud-enabled solutions across the human services and public health ecosystem. With a mission-driven approach, Gainwell serves clients in all 50 U. S. states, focusing on improving health outcomes and delivering intuitive, human-centered experiences. Their comprehensive suite of solutions includes Medicaid Enterprise modernization, data analytics, provider services, and pharmacy solutions, all designed to advance the future of healthcare and enhance community well-being.

📋 Description

• Translate client requirements, Medicaid policy, operational needs, data relationships, and system-processing outcomes into technical specifications and executable solutions • Design, develop, test, document, and maintain advanced SQL queries, reusable scripts, custom stored procedures, functions, and database utilities • Create developer-ready technical specifications for custom stored procedures • Translate approved specifications into production-ready or deployment-ready SQL code following development, peer-review, source-control, testing, and release-management standards • Develop reusable SQL toolkits for approved field updates, supporting-data retrieval, query-input combination, and test-case reproduction or debugging • Optimize SQL solutions for accuracy, maintainability, performance, scalability, and safe execution across large Medicaid claims and healthcare datasets • Partner with business analysts, Advisors, database administrators, application developers, testing teams, and release teams from requirements through implementation and post-production validation • Build controlled update scripts for approved data corrections and maintenance activities • Develop automated audit and comparison processes to identify and classify database exceptions • Produce repeatable, Excel-ready datasets and exception reports • Conduct post-implementation monitoring and reconciliation • Analyze and support QNXT claims-processing and healthcare data solutions across contracts, benefits, fee schedules, payment methodologies, capitation, business rules, claims adjudication logic, edits, X12 transaction requirements, and CARC/RARC processing • Perform claim-level and population-level root cause analysis for processing anomalies • Determine whether issues arise from configuration, database data, stored procedure logic, policy interpretation, user processing, interface behavior, product functionality, or dependencies • Quantify affected claims and populations, compare expected and actual results, document evidence, and recommend corrective solutions • Support production incidents, client inquiries, audit requests, configuration defects, approved data fixes, custom reporting, and priority troubleshooting • Produce technical documentation including SQL design documents, data mappings, table and field definitions, process flows, test cases, implementation plans, validation evidence, runbooks, and support procedures • Explain complex SQL logic and database findings in business terms • Participate in requirements sessions, technical design and code reviews, defect triage, solution walkthroughs, release-readiness reviews, and knowledge-transfer activities • Follow separation-of-duties, peer-review, change-control, security, and production-access requirements • Manage assigned technical work from intake and requirements clarification through design, development, testing, implementation, validation, documentation, and closure • Work may include production support, priority issue resolution, scheduled releases, controlled data-correction activity, and coordination across multiple client and internal technical teams

🎯 Requirements

• 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 • 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 • Video cameras must be used during all interviews and during the initial week of orientation • Photo will be taken during screening for verification in all steps of the recruitment process

🏖️ Benefits

• Work flexibility • Learning and career development • Technical credentials and certifications • Generous, flexible vacation policy • Educational assistance • Leadership and technical development academies • 401(k) employer match • Comprehensive health benefits

Apply Now

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Similar Jobs

🕒 November 10

Carle Health

10,000+ employees

⚕️ Healthcare Insurance

🏥 Healthcare

📚 Education

IT Business Systems Analyst managing Beacon oncology EMR implementation, integration, reporting, and support. Carle Health provides healthcare services across Illinois.

🕒 November 10

GovCIO

1001 - 5000

💼 Consulting

🏛️ Government

🔒 Cybersecurity

IAM Business Analyst supporting GovCIO’s federal VA identity and access management program. Translating ICAM needs into requirements, user stories, process maps, and Agile delivery support.

🕒 November 10

Thumbtack

1001 - 5000

👥 B2C

🏪 Marketplace

Senior Financial Analyst supporting Thumbtack, a home-services marketplace, with budgets, forecasts and headcount planning. Evaluating technology, infrastructure and AI spending for Product, Engineering and Design.

🕒 November 10

Blue Stream Fiber

501 - 1000

📡 Telecommunications

Business Analyst supporting Blue Stream Fiber’s Internet, Video, Voice, and value-added telecommunications products. Analyzing performance, documenting requirements, and coordinating launches, pricing, and reporting.

🕒 November 10

Lifepoint Health®

1001 - 5000

🏥 Healthcare

🧬 Biotechnology

💊 Pharmaceuticals

Senior Analyst supporting Cerner/Oracle Charge Services and Supply Chain systems for Lifepoint Health’s community healthcare network. Maintaining charge workflows, resolving issues, and guiding implementations.

Developed by Lior Neu-ner. I'd love to hear your feedback — Get in touch via DM or support@remoterocketship.com
Follow Remote Rocketship on LinkedInFollow Remote Rocketship on InstagramFollow Remote Rocketship on FacebookFollow Remote Rocketship on TikTok