Senior Advisor Application Architect - Remote

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

Job summary

Gainwell Technologies LLC is seeking an experienced data-analytic lead to guide a small team and collaborate across analytics disciplines. You will design program specifications, mapping documents, and ETL/Reporting workflows, using SQL to analyze and transform data, validate results, and present findings to clients and vendors. Remote work from anywhere in the U.S.

is supported. Responsibilities include coordinating with development leads, ensuring documentation standards, creating mapping

Qualifications

• 5+ years supporting pharmacy benefit, claims administration, Medicaid, Medicare, healthcare payer, or another highly regulated healthcare environment.
• 7+ years 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.

Responsibilities

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

Skills

SQL

Job description

Gainwell Technologies LLC is seeking an experienced data-analytic lead to guide a small team and collaborate across analytics disciplines. You will design program specifications, mapping documents, and ETL/Reporting workflows, using SQL to analyze and transform data, validate results, and present findings to clients and vendors. Remote work from anywhere in the U.S.

is supported. Responsibilities include coordinating with development leads, ensuring documentation standards, creating mapping