Data Analyst-Insurnace

Job Description Job Title: Data Analyst Role: Data Analyst Responsibilities: We are looking for a Data Analyst to work on disability insurance data migration project with development team. Skill Requirements: 8+ years of experience in relevant Data Analyst field.Experience in a Data Analyst roleExperience in Group insurance data domainExperience in data migration projectGood knowledge of Extract, Transform, Load (ETL) conceptGood knowledge of SQL/PL/SQLGood knowledge of Data ModelingExcellent communication skills Key Responsibilities: Data Collection & Extraction Extract data from databases (SQL, DB2, Oracle), APIs, and flat files Data Cleaning & Preparation Identify and resolve missing, duplicate, or incorrect data Standardize data formats and structures Fill missing mandatory fields Validate referential integrity Correct invalid data values Transform raw data into analysis-ready datasets Data Analysis & Interpretation Analyze large datasets to identify trends, patterns, and anomalies Translate business questions into analytical queries Assess data quality in source system Profile source data (nulls, duplicates, outliers) Data Quality & Governance Monitor data quality and integrity Define and enforce data standards and naming conventions Document data lineage and definitions (data dictionary) Business Support & Insights Partner with business teams to understand requirements Provide actionable insights to support decision-making Data Modeling & Mapping Create source-to-target field mapping documents Identify data type mismatches Map business rules and transformations Handle code/lookup table conversions (e.g., policy status codes) Data Reconciliation & Validation Record count comparison (source vs. target) Spot checks on key records Null/missing value checks Referential integrity checks in target DB Business rules checks Collaboration & Communication Work closely with Data Engineers and Business Analysts Participate in Agile/Scrum ceremonies Define KPIs and metrics with business stakeholders Job Description Job Title: Data Analyst Role: Data Analyst Responsibilities: We are looking for a Data Analyst to work on disability insurance data migration project with development team. Skill Requirements: 8+ years of experience in relevant Data Analyst field.Experience in a Data Analyst roleExperience in Group insurance data domainExperience in data migration projectGood knowledge of Extract, Transform, Load (ETL) conceptGood knowledge of SQL/PL/SQLGood knowledge of Data ModelingExcellent communication skills Key Responsibilities: Data Collection & Extraction Extract data from databases (SQL, DB2, Oracle), APIs, and flat files Data Cleaning & Preparation Identify and resolve missing, duplicate, or incorrect data Standardize data formats and structures Fill missing mandatory fields Validate referential integrity Correct invalid data values Transform raw data into analysis-ready datasets Data Analysis & Interpretation Analyze large datasets to identify trends, patterns, and anomalies Translate business questions into analytical queries Assess data quality in source system Profile source data (nulls, duplicates, outliers) Data Quality & Governance Monitor data quality and integrity Define and enforce data standards and naming conventions Document data lineage and definitions (data dictionary) Business Support & Insights Partner with business teams to understand requirements Provide actionable insights to support decision-making Data Modeling & Mapping Create source-to-target field mapping documents Identify data type mismatches Map business rules and transformations Handle code/lookup table conversions (e.g., policy status codes) Data Reconciliation & Validation Record count comparison (source vs. target) Spot checks on key records Null/missing value checks Referential integrity checks in target DB Business rules checks Collaboration & Communication Work closely with Data Engineers and Business Analysts Participate in Agile/Scrum ceremonies Define KPIs and metrics with business stakeholders Key Responsibilities: Data Collection & Extraction Extract data from databases (SQL, DB2, Oracle), APIs, and flat files Data Cleaning & Preparation Identify and resolve missing, duplicate, or incorrect data Standardize data formats and structures Fill missing mandatory fields Validate referential integrity Correct invalid data values Transform raw data into analysis-ready datasets Data Analysis & Interpretation Analyze large datasets to identify trends, patterns, and anomalies Translate business questions into analytical queries Assess data quality in source system Profile source data (nulls, duplicates, outliers) Data Quality & Governance Monitor data quality and integrity Define and enforce data standards and naming conventions Document data lineage and definitions (data dictionary) Business Support & Insights Partner with business teams to understan