Data Analyst with P&C Insurance

Job Title: Data Analyst - P&C Insurance
Location: NY NJ Tristate Area - Hybrid

Long Term Contract Role

Primary Skills: SQL, Python, P&C Insurance Domain, Source system analysis, Data Modelling, Data quality assessment

Secondary Skills: Data Modelling, use case Analysis & Requirement Gathering for ETL/ BI

Must-have Skills:

• Bachelor’s or Master’s degree in Computer science or related field with 6-8 years of overall work experience.
• At least 4+ years of hands-on experience in P & C Insurance domain as a Data Analyst.
• In-depth knowledge of P&C insurance processes, products, regulations, and claims workflows and knowledge of underwriting, policy management, claims, reinsurance, and actuarial functions
• Experience in applications such as Guidewire / Duck Creek / Sapiens / Salesforce or equivalent for implementing insurance solutions or integrating source into a Data Lake / Data warehouse solution
• Proficiency in Business Intelligence / Analytics use case analysis, source system analysis, and data quality assessment
• Advanced proficiency in tools such as SQL, Microsoft Excel, and visualization tools (e.g., Power BI or Tableau) to analyse, interpret, and report insurance-related data insights.
• Experience in co-ordinating/collaborating with on-shore and off-shore teams for solution definition
• Experience with tools like SQL, Excel, or Power BI to discover, analyse and interpret insurance data
• Strong experience in Agile Process and Azure DevOps
• Excellent documentation, communication, and presentation skills

Nice-to-have Skills:

• Experience with business process modelling tools such as UML to understand and document insurance workflows
• Capability to break down complex insurance business problems into implementable user stories and solution deliverables
• Exposure to conceptual and logical data modelling of data warehouse solutions.
• Familiarity with Azure data services and eco-system.

Your Key Accountabilities:

• Conduct thorough analysis of source systems, data structures, and business processes within P&C insurance to identify gaps, data quality issues, and opportunities for enhancement.
• Prepare detailed data profiling reports, identify inconsistencies, and suggest data cleansing or transformation solutions.
• Collaborate closely with Business Analysts during discovery phases by supporting questionnaires, stakeholder interviews, and documentation of data-centric use cases and analytical requirements.
• Define and document data-driven requirements, including data mappings, KPI definitions, data dictionaries, and transformation logic tailored for Data Warehouse or Business Intelligence solutions.
• Work closely with Data Architects, Data Modelers, and Data Engineers to ensure alignment of data models and ETL pipelines with P&C Insurance business needs and standards.
• Develop and validate SQL queries, data extraction scripts, and analytical models to support business intelligence, reporting, and advanced analytics use cases.
• Partner with BI and UX/UI designers to create intuitive, user-friendly dashboards and reports, ensuring effective visualization and clear interpretation of insights.
• Collaborate with QA and testing teams to define data-driven functional and integration test cases, ensuring the accuracy, integrity, and performance of the analytical solutions.
• Translate business and analytical requirements into user stories and acceptance criteria, facilitating clear guidance for agile delivery teams.
• Support agile sprint planning, demonstrations, and deliver solution demos to business stakeholders highlighting analytical capabilities and insights.
• Provide mentorship and domain expertise to team members, promoting best practices in data analysis, insurance domain knowledge, and analytical methodologies.

Ensure comprehensive testing of analytical outputs, reports, dashboards, and data sets to validate accuracy, relevance, and security compliance