Advisor Application Architect

Gainwell Technologies

. Lead a small team of data analysts or collaborate with other analysts .

Posted 10/1/2026full-timeRemote • United StatesSeniorLead💰 $95,100 - $135,800 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates extensive experience in SQL for data analysis and validation, along with a strong background in producing mapping documents and interface specifications in a highly regulated healthcare environment. Capable of leading teams and collaborating effectively to deliver data-driven solutions and support system testing processes.

Highest-signal resume keywords

SQL Data AnalysisMapping Document DevelopmentHealthcare Payer ExperienceTeam LeadershipSystem Testing Support

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

SQLData AnalysisMapping DocumentsInterface SpecificationsUnit TestingSystem Integration TestingUser Acceptance TestingData ModelsData Element DictionarySchemas

Soft Skills

CollaborationPresentation SkillsResearch and Requirements Analysis

Industry Keywords

Pharmacy BenefitClaims AdministrationMedicaidMedicareHealthcare EnvironmentCMS CertificationDDI ProgramICDsCompanion GuidesRegulated Environment

Tech Stack

Tools & technologies

ETLSQL

About the role

Key responsibilities & impact

Lead a small team of data analysts or collaborate with other analysts
Develop program specifications and mapping documents
Analyze data to understand transformation requirements
Work with ETL/Reporting/Conversion staff to ensure code meets documented business requirements
Test interfaces and reports to ensure requirements are met
Determine best practices and suggest improvements to current practices
Work with the development lead to assign and complete project tasks on schedule
Coordinate work assignments for projects with the development lead
Complete documentation requirements with project management
Create accurate mapping documents according to the mapping process
Deliver solutions to ETL/Reporting/Conversion teams for coding
Support DSD creation and response
Present analysis and design recommendations to MITA teams, customers, and vendors
Support ETL/Reporting/Conversion developers based on created mappings
Coordinate with configuration teams and DBAs to ensure configuration synchronizes with interfaces and mappings
Refine mapping documents as questions are resolved
Use SQL, data models, data element dictionaries, and schemas for data and business analysis
Create unit test cases
Validate test plan results against detailed design goals
Update technical specifications and mappings
Support Unit Testing, System Integration Testing, System Testing, and User Acceptance Testing

Requirements

What you’ll need

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
Ability to lead a small team of data analysts or collaborate with other analysts
Ability to develop program specifications and mapping documents
Ability to perform research and requirements analysis
Ability to present findings to team members, clients, and vendors
Ability to use SQL, data models, data element dictionary, and schema for data and business analysis
Video cameras must be used during all interviews and the initial week of orientation

Benefits

Comp & perks

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