Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Senior Technical Business Analyst - CEF Configuration - WA DC

$69.4k - $99.2k
Full-time

Gainwell 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.

Vacancy posted 9 days ago
Similar jobs that could be interesting for youBased on the Senior Technical Business Analyst - CEF Configuration - WA DC in Ohio vacancy
  •  ...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... 
    Senior
    Full time
    Part time
    Seasonal work
    Work at office
    Remote work

    American Financial Group

    Cincinnati, OH
    2 days ago
  • $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.... 
    Senior
    Full time
    Remote work
    Flexible hours

    Gainwell Technologies LLC

    Ohio
    1 day ago
  • 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... 
    Senior
    Contract work

    Software Guidance & Assistance, Inc. (SGA, Inc.)

    Cincinnati, OH
    21 days ago
  • $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... 
    Senior
    Full time
    Part time
    Work experience placement
    Work at office
    Remote work
    Flexible hours

    Centene Corporation

    Ohio
    17 days ago
  • $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... 
    Suggested
    Full time
    Part time
    Work experience placement
    H1b
    Work at office
    Remote work
    Flexible hours

    Centene Corporation

    Ohio
    6 days ago
  • $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 work
    Temporary work

    TEKsystems

    New Albany, OH
    13 hours ago
  •  ...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

    Further

    Cleveland, OH
    1 day ago
  • $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... 
    Senior
    Full time
    Remote work
    Flexible hours

    Gainwell Technologies LLC

    Ohio
    2 days ago
  •  ...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,... 
    Senior
    Local area

    BDI

    Cleveland, OH
    8 days ago
  • $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... 
    Senior
    Full time
    Work at office
    Remote work
    Flexible hours

    Gainwell Technologies LLC

    Ohio
    10 days ago
  •  ...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,... 
    Senior
    Full time
    Contract work
    Local area
    Shift work

    Nordson Corporation

    Westlake, OH
    1 day ago
  •  ...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 work
    Local area

    ForTec Medical

    Hudson, OH
    4 days ago
  • $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... 
    Senior
    Full time
    Temporary work
    For contractors
    Remote work
    Relocation
    Flexible hours

    Tripoint Solutions LLC

    Ohio
    13 days ago
  • $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... 
    Senior
    Work at office

    Sumaria Systems

    Fairborn, OH
    2 days ago
  • $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

    Disabledperson, Inc

    Beachwood, OH
    12 hours ago
  • $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 time
    Remote work
    Work visa

    FormativGroup

    Ohio
    16 days ago
  •  .... 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... 
    Senior
    Full time

    Ace Stack

    Cleveland, OH
    2 days ago
  • $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

    Signet Jewelers Ltd.

    Akron, OH
    4 days ago
  •  ...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... 
    Senior
    Work at office
    Shift work

    Western & Southern Life

    Cincinnati, OH
    3 days ago
  •  ...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

    Ace Stack

    Milford, OH
    2 days ago
  • $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,... 
    Senior
    Full time
    Temporary work
    Work experience placement
    Remote work
    Relocation package

    Honda Dev. and Mfg. of Am.,LLC

    Marysville, OH
    a month ago
  • $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... 
    Senior
    Full time
    H1b

    PwC

    Cleveland, OH
    4 days ago
  • $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... 
    Senior
    Full time
    Contract work
    Temporary work

    Lumen

    Cleveland, OH
    22 hours ago
  • $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... 
    Senior
    Work at office
    Remote work
    Shift work

    Cleveland Clinic

    Cleveland, OH
    1 day ago
  •  ...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

    Formica Group North America

    Cincinnati, OH
    4 days ago
  • $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-... 
    Senior
    Full time
    H1b
    Shift work

    PwC

    Columbus, OH
    2 days ago
  • $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... 
    Senior
    Full time
    H1b

    PwC

    Toledo, OH
    1 day ago
  •  ...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... 
    Senior
    Full time
    Shift work

    Vertiv Group

    Westerville, OH
    5 days ago
  • $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... 
    Senior
    Full time
    Temporary work
    Work experience placement
    Remote work
    Shift work

    Sentara Health

    Ohio
    13 days ago
  • $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... 
    Senior
    Full time
    Shift work

    World Wide Technology

    Bowling Green, OH
    1 day ago

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!