Business Data Analyst

About This Role

The Business Data Analyst will perform end-to-end data analysis, mapping, and transformation for large-scale data applications within the Property & Casualty Insurance domain. This role involves close collaboration with business and technical teams to ensure data accuracy and support enterprise-level initiatives.

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

Requirements

• 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
• Strong documentation skills with the ability to create clear and concise technical and business art

Qualifications

• 5+ years of hands-on experience in data analysis, data mapping, and data transformation within enterprise data environments

Skills

* Required skills