Sr Data Analyst with US healthcare exp

Gainwell Technologies is the leading provider of technology solutions that are vital to the administration and operations of health and human services programs. We are a new company (divested from DXC Technologies) with over 50+ years of proven experience, a reputation for service excellence and unparalleled industry expertise with approximately $1+ billion dollars of revenue, ~8,000+ employees who support clients across 41 U.S. states and territories with offerings including Medicaid Management Information Systems (MMIS), fiscal agent services, program integrity, care management, immunization registry and eligibility services. We offer our clients scalable and flexible solutions for their most complex challenges.

These capabilities make our company a trusted partner for organizations seeking reliability, innovation and transformational outcomes. About 49M Medicaid beneficiaries are being supported. 1.3B immunization records are maintained by engaging 3.0 M providers. Our commitment to clients, drives continuous improvement in the quality of healthcare for beneficiaries nationwide through vital healthcare technology.

Essential Job Functions

• Designs, implements and maintains complex databases, access methods, access time, validation checks, organization, protection and security, documentation, and statistical methods to ensure that client requirements are satisfied.
• Reviews and edits data requirements and documents according to required standards by utilizing prescribed tools and methods to ensure that design and implementation are according to company guidelines and client specifications.
• Provides overall monitoring of standards and procedures and suggests revisions when necessary to ensure updated guidelines to meet changing market demands and consistency across databases.
• Applies data analysis or data modeling techniques to establish, modify or maintain complex data structures and their associated components to increase efficiency of structures and components.
• Investigates and resolves technical matters of significance within databases by analyzing and determining possible causes to ensure client satisfaction.
• Provides work direction and guidance to less experienced personnel using the data structures and associated components to ensure that business specifications are met.
• Provides training in data modeling techniques and in incorporating data modeling into information systems to ensure consistency in development and maintenance of database structures across the company.
• Researches business objectives and data requirements of client to ensure that developed databases meet client needs.
• Communicates with clients about data-related discrepancies and other matters of significance to ascertain information and correct errors.

Job Description:
Responsible for performing research and requirement analysis, creation and design of mapping documents, and presents findings to appropriate team members, clients and vendors. Determines best practices and provides suggestions on how to improve current practices.

Top 6 Skills:

1. Healthcare/business knowledge in one or more of the following areas: member, eligibility, TPL, claims processing, provider, pharmacy claims
2. Good/Excellent SQL skills
3. Good Oral/Written communication skills
4. Data Mapping experience
5. Experience in one or more of the following areas: Conversion, Interface, Reporting
6. Experience with QXNT preferred, but not required

The candidate is expected to 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 member members.

Duties and Responsibilities (List all essential duties and responsibilities in order of importance)

• Creates accurate mapping documents according to the mapping process.
• Works toward delivering a first draft solution to ETL/Reporting/Conversion for coding, by rapidly understanding which details about the mapping can be deferred.
• 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.

Knowledge, Skills and Abilities ( List all knowledge, skills and abilities that are necessary to perform the job satisfactorily)

• Analytical and data analysis skills within a technical environment preferably SQL
• Healthcare knowledge within a claims processing environment preferably in Medicaid
• Excellent verbal and written communication skills
• Maintain confidentiality and comply with Health Insurance Portability and Accountability Act (HIPAA)
• Ability to establish and maintain positive and effective work relationships with coworkers
• Experience with QXNT preferred, but not required
  

Fast-paced,challenging and rewarding work environment.
Work life balance.
Hybrid Office environment.
Will require late evening work to overlap US work hours.

#LI-DNI