[Remote] Business Data Analyst
Note: The job is a remote job and is open to candidates in USA. EXL is seeking a Business Data Analyst with a strong background in large-scale data applications and analysis to support enterprise-level initiatives in the Property & Casualty Insurance domain. The role involves collaborating with stakeholders to ensure data accuracy and consistency while performing end-to-end data analysis and documentation.
Responsibilities
- Perform end-to-end data analysis, including data profiling, validation, and transformation for large-scale data integration and reporting projects
- Develop source-to-target data mappings (STTM) and documentation based on business requirements
- Collaborate with business users and stakeholders to gather, analyze, and translate functional requirements into technical specifications
- Work with data engineers and developers to implement and validate data consolidation, standardization, and transformation logic
- Optimize complex SQL queries for performance and accuracy in handling large datasets
- Participate in data quality assessments and recommend data cleansing or enrichment strategies
- Leverage domain knowledge of Property & Casualty Insurance—including policy administration and claims lifecycle—to ensure data alignment with business processes
- Facilitate communication between business SMEs, data modelers, and technical teams for successful data delivery and adoption
Skills
- 5+ years of hands-on experience in data analysis, data mapping, and data transformation within enterprise data environments
- Strong proficiency in SQL, including analytical functions, query optimization, and performance tuning
- Proven experience developing source-to-target mapping (STTM) documents and understanding ETL/data flow processes
- Exposure to data consolidation, standardization, and transformation across heterogeneous data sources
- In-depth knowledge of the Property & Casualty Insurance domain
- Exceptional communication and interpersonal skills—able to work effectively with technical teams, business stakeholders, and subject matter experts
- Strong documentation skills with the ability to create clear and concise technical and business artifacts
- Bachelors in related field
Company Overview
Company H1B Sponsorship