Senior Technical Business Analyst - CEF Configuration - WA DC
$69.4k - $99.2kGainwell Technologies LLC
Be part of a team that unleashes the power of leading-edge technologies to help improve the health and well-being of those most vulnerable in our country and communities. Working at Gainwell carries its rewards. You’ll have an incredible opportunity to grow your career in a company that values work flexibility, learning, and career development. You’ll add to your technical credentials and certifications while enjoying a generous, flexible vacation policy and educational assistance. We also have comprehensive leadership and technical development academies to help build your skills and capabilities.
Summary
As a Senior Technical Business Analyst - CEF Configuration - WA DC 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.
Your role in our mission
Technical Analysis, SQL Development, and Solution Delivery
- Design, develop, test, document, and maintain advanced SQL queries, reusable scripts, custom stored procedures, functions, and related database utilities that support analysis, correction, auditing, troubleshooting, and reporting.
- Create developer-ready technical specifications for custom stored procedures, including purpose, scope, assumptions, source and target tables, joins, input and output parameters, processing logic, exception handling, dependencies, security considerations, performance requirements, test scenarios, and deployment or rollback considerations.
- Translate approved technical specifications into production-ready or deployment-ready SQL code in accordance with development, peer-review, source-control, testing, and release-management standards.
- Develop reusable SQL toolkits that help teams update approved fields, retrieve supporting data, combine query inputs, and reproduce or debug test cases.
- 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 to move solutions from requirements through implementation and post-production validation
Audit Automation and Data Quality
- Build controlled update scripts for approved, repeatable data corrections or maintenance activities, using safeguards such as pre-update checks, transaction handling, row-count verification, exception reporting, and post-update reconciliation.
- Develop automated audit and comparison processes that identify incorrect, invalid, incomplete, or missing database information across large record populations and classify exceptions for remediation.
- Produce repeatable, Excel-ready datasets and exception reports that support remediation, technical review, and audit response while reducing manual review time.
- Conduct post-implementation monitoring and reconciliation to confirm that database changes and stored procedure results satisfy the approved technical design without unintended downstream impacts.
Claims and Production Support
- 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 data requirements, and CARC/RARC processing.
- Gainwell Technologies | Proprietary and Confidential | Senior Professional BA, CEF Claims Configuration Engineering
- Write and execute advanced SQL to analyze claims, claim lines, provider affiliations, contracts, benefits, pricing, member eligibility, edits, process steps, accumulators, encounters, remittance, and financial data.
- Perform claim-level and population-level root cause analysis for denials, pends, unexpected edits, underpayments, overpayments, duplicate conditions, encounter rejections, data-quality issues, and other processing anomalies.
- Determine whether an issue is caused by configuration, database data, stored procedure logic, policy interpretation, user processing, interface behavior, product functionality, or an upstream or downstream dependency.
- Quantify affected claims and populations, compare expected and actual results, document evidence, and recommend technically actionable corrective solutions.
- Support production incidents, client inquiries, audit requests, configuration defects, approved data fixes, custom reporting, and priority troubleshooting.
Technical Writing, Controls, and Collaboration
- Produce clear, supportable 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 clear business terms, including operational impact, affected populations, risks, alternatives, and recommendations.
- Participate in requirements sessions, technical design and code reviews, defect triage, solution walkthroughs, release-readiness reviews, and knowledge-transfer activities.
- Follow established separation-of-duties, peer-review, change-control, security, and production-access requirements for database and application changes.
- Manage assigned technical work from intake and requirements clarification through design, development, testing, implementation, validation, documentation, and closure
What we're looking for
Top 3 Required Skills:
- 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, QNXT administration, configuration, or support ,or a related technical discipline. Experience must demonstrate the ability to connect business requirements to database structures, technical specifications, and executable solutions
Additional required and preferred skills
- 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, QNXT claims processing workflows, 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 J ira 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.
What you should expect in this role
- Fully remote options from Greater Washington DC area.
- Video cameras must be used during all interviews and during the initial week of orientation.
- Work may include production support, priority issue resolution, scheduled releases, controlled data-correction activity, and coordination across multiple client and internal technical teams.
- This job description may be refined to align with the approved requisition, job profile, location, compensation, and Talent Acquisition requirements.
- Video cameras must be used during all interviews, as well as during the initial week of orientation
- Photo will be taken during screening for verification in all steps of the recruitment process.
- The deadline to submit applications for this posting is December 30, 2026
-
#LI-HC1
Please ensure you join all screenings, interviews and meetings from a quiet location with a stable internet connection.
Video is required for screenings and interviews, so please test your camera and microphone in advance.
Do not use AI tools, virtual backgrounds/filters, or visual enhancements during the interview.
The pay range for this position is $69,400.00 - $99,200.00 per year, however, the base pay offered may vary depending on geographic region, internal equity, job-related knowledge, skills, and experience among other factors. Put your passion to work at Gainwell. You’ll have the opportunity to grow your career in a company that values work flexibility, learning, and career development. All salaried, full-time candidates are eligible for our generous, flexible vacation policy, a 401(k) employer match, comprehensive health benefits , and educational assistance. We also have a variety of leadership and technical development academies to help build your skills and capabilities.
We believe nothing is impossible when you bring together people who care deeply about making healthcare work better for everyone. Build your career with Gainwell, an industry leader. You’ll be joining a company where collaboration, innovation, and inclusion fuel our growth. Learn more about Gainwell at our company website and visit our Careers site for all available job role openings.
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. Gainwell Technologies defines “wages” and “wage rates” to include “all forms of pay, including, but not limited to, salary, overtime pay, bonuses, stock, stock options, profit sharing and bonus plans, life insurance, vacation and holiday pay, cleaning or gasoline allowances, hotel accommodations, reimbursement for travel expenses, and benefits.
- ...work together to achieve business results. Our goal is to create... ..., network security, technical support, establishing and... ...Solutions IT team is seeking a Senior Technical Business Analyst. This individual will... ..., application configuration, SQL and data analysis, automation...SeniorFull timePart timeSeasonal workWork at officeRemote work
$69.4k - $99.2k
...Join the group that solves business challenges and enhances... ...development. Summary As a Senior Business Analyst - Claims Configuration (QNXT) at Gainwell, you... ...functional and technical support for Medicaid claims... ...matter resource for assigned CEF Claims M&O accounts....SeniorFull timeRemote workFlexible hours- Software Guidance & Assistance, Inc., (SGA), is searching for a Senior Technical Business Analyst – Wealth & Trust Modernization for a contract assignment with one of our premier Financial Services clients in Cincinnati, OH, Farmington Hills, MI, Frisco, TX or Charlotte...SeniorContract work
$87.7k - $157.8k
...Position Purpose: Provides in-depth business knowledge and advanced technical support to one or more business areas through developed and ad hoc analysis... ...analysis and validation. Partners with business analysts, Risk Adjustment stakeholders, IT, and vendor teams to...SeniorFull timePart timeWork experience placementWork at officeRemote workFlexible hours$70.1k - $126.2k
Position Purpose: Provides functional business knowledge and technical support to the business unit through developed and ad hoc analysis/reporting... ...with healthcare claims data, claims processing, or configuration operations, preferred. Experience with Power BI and...SuggestedFull timePart timeWork experience placementH1bWork at officeRemote workFlexible hours$40 - $50 per hour
We are looking for a Technical Business Analyst who can bridge the gap between business users and technology. This person will combine strong... ...integrations, and application changes.Assist with application configuration, testing, minor enhancements, integrations, and...Contract workTemporary work- ...is to enable people to thrive so that businesses can thrive. We believe that the work... ...you, let's chat!We are looking for a Technical Analyst who can act as the glue between developers... ...role, you will pair hands-on data configuration in platforms like CJA with tailored...Senior
$64.9k - $92.7k
...Join the group that solves business challenges and enhances... ...development. Summary As a Senior Business Analyst - Pharmacy Claims at... ...rebate implementations and configurations Support PBM... ...clients, project managers and technical staff to define, document...SeniorFull timeRemote workFlexible hours- ...seeking a highly skilled and analytical Senior SAP FICO Business Analyst to join our global SAP team. This... ...between finance stakeholders and technical teams, ensuring our systems are... ...strategy and best practices. SAP FICO Configuration & Support: Lead the design,...SeniorLocal area
$69.4k - $99.2k
...career development. You’ll add to your technical credentials and certifications while... ...and capabilities. Summary The Senior Business Analyst - BPM/Trainer at Gainwell, is... ..., policy staff, operations, product, configuration, and technical teams to elicit requirements...SeniorFull timeWork at officeRemote workFlexible hours- ...document, and support complex business solutions within the IFS... ...leadership skills, and technical understanding to deliver... ...and ResponsibilitiesThe Senior Business Process Analyst serves as the functional... ...recommendations, supports system configuration and testing activities,...SeniorFull timeContract workLocal areaShift work
- ...recognition and reward opportunities Job Description The Technical Business Analyst is responsible for translating approved business and... ...behavior, business logic, data structures, and system configuration to understand how the system currently works. Analyze...Temporary workLocal area
$85k - $95k
...About the Role: The Senior Business Analyst / Deputy Project Manager is responsible for a wide range... ...Solutions corporate offices: AL, CO, DC, DE, FL, GA, IL, IN, KS, LA, MD, MN,... ...minutes Documenting business and technical solutions in a variety of formats including...SeniorFull timeTemporary workFor contractorsRemote workRelocationFlexible hours$80k - $85k
Senior Management AnalystJob Posting TitleSenior Management AnalystJob DescriptionEffective... ...not limited to:Serve as a Management Analyst and Action Officer supporting AFSC... ...and organizational priorities.Maintain configuration management of leadership products and track...SeniorWork at office$105k - $125k
...Sr. Business Systems Analyst - Service Management/HR Build your future while you help build a... ...tools, including package installation, configuration, enhancements & process improvements... ...process improvements. Works with technical resources to ensure solutions meet business...Senior$100k - $120k
Salesforce Bsuiness Analyst Are you energized by turning business needs into clear requirements... ...dots between clients, technical teams, and business processes... ...gathering, Salesforce configuration, testing, training, and... ...VA, WI, or Washington, DC. We are committed to pay...Full timeRemote workWork visa- .... Oracle Finance Functional Analyst (OTC & RTR) Location: Cleveland... ...) Fulltime Must Have Technical/Functional Skills... ...0s, test scripts, SOPs, and configuration documents. Strong understanding... ...strategic guidance to finance and business stakeholders on Oracle...SeniorFull time
$87.5k - $105k
...Technical Business Analyst Remote POSITION SUMMARY: The Technical Business Analyst supports projects of various sizes, complexity, and... ...Define the scope of the projects in collaboration with senior project managers. Drive AI-first modernization using Signet...Remote job- ...Technical Analyst Researches, analyzes, defines, designs, tests, checks and plans activities and applications of new technologies to processes... ...by coordinating activities between programmer teams and business partners (outside the Company). Evaluates and determines...SeniorWork at officeShift work
- ...Technical Business Analyst ETL / Ab Initio Location: Milford, OH Onsite from day 1 Contract We are seeking a Technical Business Analyst with strong ETL and Ab Initio experience to bridge the gap between business requirements and technical implementation. The ideal...Contract work
$120.4k - $150.5k
...and developing solutions to drive our business with record success. We strive to be a... ...will establish and lead engineering and technical development targeted for the U.S. space... ...processes including systems engineering, configuration management, design reviews,...SeniorFull timeTemporary workWork experience placementRemote workRelocation package$124k - $280k
...consulting efforts focused on business applications across... ...transformation. As a Senior Manager you will lead large... ...application selection, configuration planning, testing strategy... ...; CA-Silicon Valley; WA-Seattle; FL-Tampa; GA-Atlanta; TX-Austin; DC-Washington; FL-Miami; MN...SeniorFull timeH1b$132.3k - $176.4k
...today. The Role The Business Development Account... ...organizations and briefs senior management on high dollar... ...articulate the requirements for technical, contractual, commercial... ...states: AK, CA, CT, DC, DE, IL, MA, MD, NJ, NY, TX, VA, and WA. Lumen offers a comprehensive...SeniorFull timeContract workTemporary work$69.6k - $106.13k
...healthcare organizations in the world. As a Senior Operations Analyst, you will serve as a key internal... ...and the development of new business lines within existing facilities.Troubleshoot... ...issues stem from workflow, system configuration, payer policies or process...SeniorWork at officeRemote workShift work- ...Operations Business Analyst The Operations Business Analyst serves... ...applications through issue analysis, configuration support, testing, and... ..., developers, vendors, and technical teams to ensure proposed... ...workstreams with guidance from senior team members or project...Work experience placement
$124k - $280k
...Technology Architecture Senior Manager - S/4HANA... ...perspective to technical decisions, and... ...deployment choices with business objectives.... ...through installation, configuration, administration,... ...CA-Silicon Valley; WA-Seattle; SC-Spartanburg... ...Austin; OK-Tulsa; DC-Washington; CO-...SeniorFull timeH1bShift work$77k - $202k
...to Cash Consultant, Senior Associate you will support... ...developing your technical skills and business context. In this role... ...contribute to the design, configuration, training, and... ...Valley; PR-San Juan; WA-Seattle; SC-Spartanburg... ...TX-Austin; OK-Tulsa; DC-Washington; CO-Denver...SeniorFull timeH1b- ...Second Level Support (RUN) Senior Analyst is accountable for ensuring... ...ensuring alignment with business impact and SLA requirements... ...identifying patterns proposing configuration or process enhancements and... ...on solution design and technically resolved tickets to the Shift...SeniorFull timeShift work
$100.82k - $149.66k
...City/State Norfolk, VA Work Shift First (Days) Overview: Overview The Senior ServiceNow Business Analyst responsible for day-to-day support and optimization of software applications, including builds, upgrades, and system enhancements. Analyzes business / clinical...SeniorFull timeTemporary workWork experience placementRemote workShift work$77.2k - $96.5k
...Qualifications: ~ Bachelor’s degree in business, Accounting, MIS, Finance, or related... ...troubleshoot complex SQL queries ~ Experience configuring AR, AP, GL, Projects, Costing, and... ...skills with ability to translate technical concepts for non-technical audiences...SeniorFull timeShift work
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Senior Technical Business Analyst - CEF Configuration - WA DC. Be the first to apply!






