Remote Healthcare Systems Advisor | SQL & ETL Analyst

Gainwell Technologies; New Hampshire; Remote; USD 91,000 - 130,000; Full time

Job summary

Gainwell Technologies is seeking an Advisor Healthcare Systems Analyst to help improve healthcare outcomes through advanced data analysis and mapping across Pharmacy Benefits, Medicaid, and Medicare programs. You will collaborate with analysts, develop mapping documents, and ensure ETL/Reporting solutions meet business requirements.

You will work remotely in the US with occasional travel, coordinate with leads and project management, and contribute to design recommendations while supporting

Qualifications

• 5+ years of experience supporting Pharmacy Benefits, Claims Administration, Medicaid, Medicare, Healthcare Payers, or other Highly Regulated Healthcare Environments.
• 7+ years of experience using SQL to analyze, validate, reconcile, transform, and troubleshoot complex relational data.
• Experience supporting large scale system implementations, modernization, conversions, DDI programs, production stabilization, defect triage, data remediation, and operational handoff.
• Experience creating source to target mappings, interface specifications, test artifacts, ICDs, companion guides, mapping workbooks, synthetic test data, and complex end to end test scenarios.
• Strong project management, data analysis, and healthcare claims expertise, with experience using Databricks, ETL Gateway or similar integration frameworks, Azure DevOps, Application Lifecycle Management tools, and mentoring analysts while maintaining HIPAA compliance and effective stakeholder communication.

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

Pharmacy Benefits

SQL

ETL/Data Integration

Healthcare Claims

Databricks

Azure DevOps

Tools

Databricks

ETL Gateway

Azure DevOps

ALM Tools

Job description

Gainwell Technologies is seeking an Advisor Healthcare Systems Analyst to help improve healthcare outcomes through advanced data analysis and mapping across Pharmacy Benefits, Medicaid, and Medicare programs. You will collaborate with analysts, develop mapping documents, and ensure ETL/Reporting solutions meet business requirements.

You will work remotely in the US with occasional travel, coordinate with leads and project management, and contribute to design recommendations while supporting