FREE ACCESS
5,000–10,000 jobs/day
See all jobs on JobTailor
Search thousands of fresh jobs every day.
Discover
- Fresh listings
- Fast filters
- No subscription required
Create a free account and start exploring right away.
ATS Keywords
Tailor your resumeApplicant Tracking System Keywords
Tip: use these terms in your resume and cover letter to boost ATS matches.
Hard Skills
ETLELTSQLdata cleansingdata transformationdata validationdata warehousingdata mappingdata analysisdata governance
Soft Skills
problem solvinganalytical skillscommunicationcollaborationattention to detailtime managementadaptabilitycritical thinkingorganizational skillsability to work under pressure
Tools & Technologies
QNXTHealth Rules (HRP)TOPSCOSMOSFacetsAmisys AdvanceNASCOWGSData bricksdata integration tools
Industry Keywords
healthcare data managementHIPAAdata securitydata privacyclaims processingclient data feedsdata lineagecompliance standardshealthcare regulationsdata quality
Tech Stack
Tools & technologiesETLSQL
About the role
Key responsibilities & impact- 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.
Requirements
What you’ll need- 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
Benefits
Comp & perks- For more information on benefits and what we offer please visit us at https://www.exlservice.com/us-careers-and-benefits