Insurance Data Analyst Informatica

This role requires strong expertise in Business Analysis Informatica PowerCenter Snowflake and PostgreSQL with deep experience in insurance data domains such as claims policies underwriting customer risk and regulatory reporting. The individual will work across data engineering actuarial underwriting finance and compliance teams to deliver analytics-ready datasets insights and governance.

• Analyze structured and semi-structured data related to claims policies underwriting and customer interactions
  
• Identify patterns in claims frequency fraud indicators and loss ratios using lakehouse datasets
  
• Support actuarial teams with data extracts and trend analysis
  

• Segment customers by behavior risk profiles and product usage
  
• Analyze customer lifetime value churn risk and cross-sell / up-sell opportunities
  
• Collaborate with risk & compliance teams to monitor exposure and regulatory thresholds
  

• Prepare data extracts and reports for regulatory bodies (OSFI FSRA NAIC)
  
• Ensure data lineage and traceability for audit and compliance
  
• Validate data accuracy and completeness for filings and disclosures
  

• Clean and transform raw data from policy admin systems CRM claims systems etc.
  
• Use lakehouse tools (Delta Lake Apache Iceberg) for versioned and time-travel datasets
  
• Collaborate with data engineers on efficient ETL/ELT processes
  

• Build dashboards for underwriting claims finance and product teams
  
• Use Power BI Tableau or Qlik to visualize insights
  
• Enable self-service analytics with reusable datasets and semantic layers
  

• Profile and validate data across policy claims and financial domains
  
• Tag and catalog datasets using metadata tools (Unity Catalog Collibra)
  
• Support MDM and reference data initiatives
  

• Work with actuaries underwriters product managers and IT teams
  
• Translate business questions into analytical queries and data models
  
• Document business logic assumptions and data definitions
  

• Assist data scientists with feature engineering and exploratory analysis
  
• Provide historical datasets for model training and validation
  
• Interpret model outputs and integrate them into business reporting
  

• University degree in Computer Engineering or Computer Science
  
• Minimum 5 years leading data systems analysis teams
  
• 8 years as a Business Analyst on mid-large data projects
  

• Snowflake
  
• Hadoop
  
• PostgreSQL
  
• Informatica PowerCenter
  
• Outstanding ETL experience with Informatica product suite
  
• Strong understanding of enterprise data design development and implementation
  

• Business Analysis
  
• Informatica PowerCenter
  
• Snowflake
  
• PostgreSQL