Advisor Application Architect

Gainwell Technologies; Kentucky; Remote; USD 95,000 - 136,000; Full time

Benefits offered by this job

Remote work

Flexible vacation policy

401(k) employer match

Health benefits

Educational assistance

Job summary

Gainwell Technologies is seeking a senior data analytics lead to guide a small team of analysts and develop program specifications and mapping documents. You will perform data analysis to understand transformation needs, coordinate with ETL/Reporting teams, and ensure mappings meet business requirements.

You will propose improvements and work with leads to assign tasks and deliver on schedule. The role requires seven+ years of SQL experience, healthcare domain knowledge, and experience with

Qualifications

• Five+ years in healthcare data analytics or a regulated environment.
• Seven+ years using SQL to analyze, validate, transform, or troubleshoot complex data.
• Experience with large-scale system implementations, modernization, or conversions.
• Proven ability to produce source-to-target mappings and interface specifications.
• Experience authoring mapping workbooks and ICDs/companion guides.
• Experience supporting CMS or state certification activities.

Responsibilities

• Coordinate work assignments with the development lead for projects.
• Collaborate with project management to complete documentation requirements.
• Create accurate mapping documents per the mapping process.
• Advance ETL/Reporting/Conversion work by clarifying mapping details.
• Support DSD creation and respond to queries.
• Present design recommendations to MITA teams, clients or vendors.

Skills

Data analysis

Team leadership

Requirements analysis

SQL proficiency

Healthcare domain knowledge

Tools

SQL

Job description

Select how often (in days) to receive an alert:

Date: Oct 1, 2026

Location: Any city, KY, US, 99999

Work Mode: Virtual (Exception only)

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

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.

What we're looking for

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

What you should expect in this role

• Fully Remote Opportunity – Work from anywhere in the U.S.
• 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.

This posting is intended for pipelining. We will accept applications on an ongoing basis.

#LI-GD1

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