Note: The job is a remote job and is open to candidates in USA. EXL is hiring a Manager, Healthcare Data Management. In this role, the Manager will oversee the analysis and management of healthcare data, ensuring accurate data processing and compliance with regulations. The responsibilities include designing ETL processes, collaborating with stakeholders, and maintaining data integrity.
Responsibilities
- Analyze client claim processing systems to ensure accurate data mapping, integration, and processing
- Own end-to-end analysis, testing, and documentation of business requirements, particularly for fields and logic requiring custom programming
- Interpret and document complex claim scenarios, including adjustments, readmissions, and replacement claims
- Maintain functional expertise in one or more claims platforms such as QNXT, Health Rules (HRP), TOPS, COSMOS, Facets, Amisys Advance, NASCO, or WGS
- Design, build, and optimize ETL/ELT pipelines to support large-scale healthcare data processing (e.g., EMR, claims, lab data)
- Perform data cleansing, transformation, and validation to ensure accuracy, consistency, and usability
- Monitor and troubleshoot ETL workflows to identify and resolve data quality and processing issues
- Ensure timely and accurate execution of data loads based on predefined schedules for each client
- Develop, maintain, and document ETL processes, including data lineage, transformation rules, and technical specifications
- Participate in the design and implementation of data warehouse solutions
- Collaborate with business stakeholders to gather requirements and translate them into technical solutions
- Enforce data security, governance, and compliance standards, including adherence to HIPAA and healthcare regulations
- Ensure strict alignment with documented procedures and guidelines for data loading, layout changes, and system updates
- Perform layout modifications and mapping adjustments based on client or system requirements
- Conduct thorough quality checks to validate loaded data and resolve inconsistencies
- Stay updated on evolving technologies and best practices in ETL, data warehousing, and healthcare data management
Skills
- Master's or bachelor's degree in computer or related field
- 12 to 14 plus years of experience in data management
- Experience in onboarding new client's data feeds into standard ETL implementation
- Strong problem solving and analytical skills and the ability to “roll up your sleeves” and work to create timely solutions and resolutions, to validate, verify, communicate, and resolve application issues
- Performing SQL data analysis and mapping to build healthcare data warehouses after reviewing client data feeds
- Ensure monthly/daily and weekly data loads are performed as per schedule
- Experience with working on claim systems such as Facets
- Ability to work on multiple client implementations simultaneously
- Proven experience in data management, data governance, or related roles
- Proficiency in database management systems (e.g., SQL, Data bricks)
- Familiarity with data integration tools and ETL processes
- Strong understanding of data privacy and security regulations
Company Overview
Company H1B Sponsorship