> Markdown version of [/jobs/ext/3533473-advisor-application-architect](https://www.wearedevelopers.com/jobs/ext/3533473-advisor-application-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Advisor Application Architect

- **Company:** Gainwell Technologies
- **Location:** Louisville, KY, United States (Remote available)
- **Experience:** Expert
- **Salary:** $88,800.0 - $126,900.0
- **Contract:** Permanent contract
- **Skills:** Data Analysis, Applications Architecture, Software Applications, Unit Testing, Extract Transform Load (ETL), Data Structures, Relational Databases, Software Engineering, SQL Databases, System Integration Testing, System Testing
- **Published:** October 2, 2026
- **Apply:** https://www.careerjet.com/job/us64a6c764b4cc863cb3ba50a4c744a4cd/eaa

## About the Role

* Five or more years of experience supporting pharmacy benefit, claims administration, Medicaid, Medicare, healthcare payer, or another highly regulated healthcare environment.
 * Seven or more years of experience using SQL to analyze, validate, reconcile, transform, or troubleshoot complex relational data.
 * Experience supporting large-scale system implementation, modernization, conversion, or DDI program.
 * Demonstrated experience producing source-to-target mappings, interface specifications, data-analysis results, and test artifacts.
 * Experience authoring or maintaining ICDs, companion guides, and detailed mapping workbooks.
 * Experience supporting CMS or state certification activities.

## Description

The candidate is expected to lead a small team of data analysts or collaborate with other analysts and be able to develop program specifications and mapping documents. Perform analysis on data to understand transformation requirements, work with ETL/Reporting/Conversion staff to ensure code has been developed that meet the business requirements documented, test the interface/report to ensure requirements are met and work with other team members. Determines best practices and provides suggestions on how to improve current practices. Works with the development lead to get project tasks assigned and completed on schedule. Has the capabilities to perform research and requirement analysis, creation and design of mapping documents, and present findings to appropriate team members, clients and vendors.
Your role in our mission

 * Works with the development lead to coordinate work assignments for projects
 * Works with project management to complete documentation requirements
 * Creates accurate mapping documents according to the mapping process.
 * Works toward delivering a solution to ETL/Reporting/Conversion for coding, by rapidly understanding which details about the mapping can be deferred.
 * Supports DSD creation and response.
 * Presents analysis and design recommendations to lead MITA teams, customer and/or vendors into the acceptance of the design.
 * Supports the ETL/Reporting/Conversion developers based on the mappings created.
 * Works closely with configuration team and DBAs to ensure synchronicity of configuration to interfaces and mappings.
 * Refines mapping documents, adding more detail and filling out deferred material as questions are resolved.
 * Uses SQL, data models, data element dictionary and schema to perform data and business analysis.
 * Creates unit test cases for area of responsibility.
 * Validates test plan results that satisfy the detailed design goals.
 * Updates technical specifications and mappings.
 * Supports Unit Testing, System Integration Testing, System Testing, and User Acceptance Testing., Become a part of our caring community The Senior Application Architect designs and develops IT applications architecture solutions to business problems in alignment with the enter…
 + 1 day ago, Become a part of our caring community The Lead Application Architect designs and develops IT applications architecture solutions to business problems in alignment with the enterpr…
 + 2 days ago