Software Architect/Development Architect

Gainwell Technologies LLC; Columbus (OH); Remote; USD 95,000 - 136,000; Full time

Benefits offered by this job

Health benefits

401(k) match

Educational assistance

Leadership academies

Job summary

Gainwell Technologies is seeking a Technical Analyst/Data Analyst to join our remote team and help optimize Medicaid pharmacy claims processing. You will translate business requirements into technical specifications, perform data extraction and validation with advanced SQL, and collaborate with analysts, QA, and developers across SDLC.

This full-time role requires 3–5 years in healthcare data analysis and familiarity with DEDs, NDC pricing, DUR edits, PA workflows, and NCPDP interfaces.

Qualifications

• 3–5 years in a technical analyst or healthcare systems analyst role.
• Advanced SQL skills with data extraction, transformation, and validation.
• Strong understanding of Medicaid pharmacy claims processing and pricing rules.
• Experience with Data Element Dictionaries (DEDs) and pharmacy-related interfaces (NCPDP).

Responsibilities

• Translate business requirements into technical specifications and data models.
• Analyze data flows and integration logic across modules.
• Collaborate with BAs, QA, and configuration teams to align requirements with architecture.
• Mentor junior analysts on data standards and SQL best practices.

Skills

SQL

Healthcare data

SDLC/Agile

NCPDP

Tools

AWS/Azure/Google Cloud

Job description

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

Member, Provider, Claims/UM, Pharmacy, Finance, Plan, or VUE360). Working in close collaboration with Business Analysts and Configuration Analysts, the Technical Analyst ensures that solutions are technically sound, data‑driven, and aligned with project and system architecture. This role provides essential support for system design and technical specification creation, data setup, testing, and decision‑making throughout the Software Development Life Cycle (SDLC). The analyst leverages deep SQL expertise, an understanding of healthcare concepts, familiarity with Data Element Dictionaries (DEDs), and knowledge of Medicaid pharmacy claims processing, NDC‑based pricing, DUR edits, prior authorization workflows, and pharmacy benefit rules.

Understand business requirements at a detailed level and translate them into technical specifications and data models, including pharmacy claims adjudication logic, pricing methodologies, DUR edits, and PA workflows.

Support business analysts with insight into how system data and integrations meet operational and policy needs, including pharmacy benefit rules and pharmacy claims data structures.

• Use advanced SQL skills to extract, analyze, and validate data to support solutioning, testing, and quality assurance, including pharmacy claims data elements such as NDCs, quantities, units, pricing fields, and DUR indicators.
• Interpret and utilize Data Element Dictionaries (DEDs) to understand data structures and relationships across modules, including pharmacy‑specific data dictionaries.
• Analyze and document data flows, integration logic, and technical dependencies across internal systems and external interfaces, including NCPDP pharmacy interfaces and pharmacy PA systems.
• Serve as a liaison between business users, developers, QA, and configuration teams to ensure shared understanding of requirements, including pharmacy‑specific rules and adjudication logic.

Document and communicate technical decisions, risks, and impacts clearly and concisely to stakeholders, including pharmacy program impacts.

Develop detailed technical solution models and recommend scalable approaches that align with enterprise architecture and platform capabilities, including pharmacy claims and pharmacy benefit configurations.

• Mentor junior technical analysts on data standards, SQL best practices, and documentation expectations, including pharmacy claims data structures and pricing logic.
• Provide analytical support during defect resolution, system configuration validation, and pre‑deployment quality checks, including pharmacy claims adjudication and DUR logic validation.

3–5 years of experience in a technical analyst, data analyst, or healthcare systems analyst role.

Advanced SQL skills, including experience with joins, data transformations, and large dataset manipulation, including pharmacy claims datasets.

• Strong understanding of healthcare systems and Medicaid concepts, including Medicaid pharmacy claims processing, NDC‑based pricing, DUR edits, prior authorization workflows, and pharmacy benefit rules.
• Familiarity with Data Element Dictionaries (DEDs), interface specifications, and integration design, including pharmacy‑related interfaces such as NCPDP.
• Experience working in SDLC and Agile environments preferred.
• Understanding of system implementation in cloud platforms (AWS/Azure/Google Cloud) is a plus.

Fully Remote Opportunity – Work from anywhere in the U.Minimal Travel Required – Occasional travel opportunities (0-10%).

Video cameras must be used during all interviews, as well as during the initial week of orientation

The deadline to submit applications for this posting is October 27, 2026.

The pay range for this position is $95,100.00 - $135,800.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.

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.

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.