EXL logo

Business Analyst

EXL
Full-time
On-site
United States
Description
  • 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Β 



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.


Qualifications
  • 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.