Role Overview

We are looking for an experienced Business Data Analyst with strong expertise in Property & Casualty (P&C) Insurance , data analysis, data mapping, and data transformation. The ideal candidate will act as a bridge between business and technical teams, work closely with client SMEs to understand business functionality and data requirements, and create comprehensive data documentation to support data consolidation and standardization initiatives.

Key Responsibilities

Act as a liaison between business and technical teams to ensure clear understanding of requirements and deliverables.
Collaborate with Client SMEs and business stakeholders to understand business functionality, processes, and data requirements.
Perform Data Profiling to assess data quality, identify critical data elements, and understand data issues.
Analyze and define approaches to standardize reference data and master data across multiple systems.
Create and maintain Source-to-Target Mapping (STTM) documents covering data mappings and transformations.
Develop and maintain Data Lineage documentation, Data Models, BRDs, FRDs, and Design Documents .
Analyze data from multiple source systems and support data consolidation, transformation, and standardization activities.
Work with relational databases and Snowflake to perform data analysis and validation using SQL.
Gather, analyze, and document business requirements and translate them into clear technical and functional requirements.
Collaborate with cross-functional teams to ensure accurate data mapping and transformation processes.
Communicate effectively with business stakeholders, technical teams, and client SMEs.
Work independently while integrating quickly into the team and contributing toward common project goals.

Must-Have Skills

5+ years of experience in large-scale data applications involving Data Analysis, Data Mapping, and Data Transformations .
Strong experience in Property & Casualty (P&C) Insurance Domain .
Strong proficiency in SQL and experience with relational databases.
Hands-on experience with Snowflake .
Strong knowledge of Source-to-Target Mapping (STTM) and STTM documentation.
Experience in Data Profiling, Data Mapping, Data Lineage, and Data Transformation .
Experience in Business Requirement Gathering .
Strong experience in preparing BRD and FRD documents.
Exposure to data consolidation, transformation, and standardization across different systems.
Excellent verbal and written communication skills .
Strong documentation, coordination, and tracking skills.
Ability to work independently and collaborate effectively with cross-functional teams.
Self-starter with strong analytical and problem-solving abilities.

Good to Have

Additional knowledge of the Insurance Domain .
Strong understanding of SQL and data analysis techniques.
Experience working with multiple data sources and enterprise data environments.

Education

Bachelor’s degree in Computer Science, Software Engineering, Management Information Systems (MIS) , or an equivalent combination of education and professional experience.

Key Skills