Advisor Healthcare Systems Analyst

Gainwell Technologies LLC•Any city, OH

1d•$90,900 - $129,900•Remote

About The Position

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. As Advisor Healthcare Systems Analyst at Gainwell, you can contribute your skills as we harness the power of technology to help our clients improve the health and well-being of the members they serve — a community’s most vulnerable. Connect your passion with purpose, teaming with people who thrive on finding innovative solutions to some of healthcare’s biggest challenges. Here are the details on this position. The candidate is expected to 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.

Requirements

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.