Data Analyst

Analytics & Reporting

• Turn business questions from underwriting claims actuarial and finance teams into well-structured analyses and repeatable reports.
  
• Build and maintain dashboards and scorecards for KPIs such as loss ratio combined ratio premium growth retention/lapse and claims cycle time.
  
• Perform exploratory analysis to surface trends anomalies and opportunities (e.g. emerging loss patterns fraud indicators leakage).
  
• Document assumptions definitions and methodology so results are transparent and auditable.
  

Insurance Domain Analytics

• Analyze policy premium claims and billing data to support pricing reserving and portfolio management discussions.
  
• Support loss-ratio frequency/severity and retention/churn analyses for P&C and/or L&A lines of business.
  
• Partner with actuarial and underwriting teams to validate data and interpret results in business context.
  

Data Preparation & SQL

• Write and optimize SQL to extract join and aggregate data from the lakehouse / data warehouse.
  
• Profile clean and validate datasets; flag and help resolve data quality issues with engineering.
  
• Build reusable well-documented queries views and semantic-layer definitions.
  

Visualization & Stakeholder Enablement

• Design clear decision-oriented visualizations in Power BI / Tableau (or equivalent).
  
• Translate analysis into concise narratives and recommendations for non-technical business stakeholders.
  
• Enable self-service by documenting metrics and curating trusted data sources.
  

Technology Stack

• Strong SQL across cloud data warehouse / lakehouse environments (Databricks SQL Snowflake BigQuery or similar).
  
• BI/visualization tools Power BI and/or Tableau.
  
• Spreadsheet modeling (Excel) for ad-hoc analysis.
  
• Working knowledge of Python (pandas) for data wrangling is a plus.
  

Required Qualifications

• 47 years of experience in data analysis business intelligence or reporting.
  
• Strong demonstrable SQL skills (complex joins window functions aggregations query tuning).
  
• Proven experience building dashboards and reports in Power BI and/or Tableau.
  
• Solid understanding of data modeling concepts (dimensional / star schema) from a consumers perspective.
  
• Ability to translate ambiguous business questions into structured analysis and clear deliverables.
  
• Strong written and verbal communication with business stakeholders.
  

Preferred Skills

• Insurance domain knowledge P&C and/or Life & Annuities; familiarity with premium claims and loss-ratio concepts.
  
• Experience with cloud data platforms (Databricks Snowflake Azure/AWS/GCP).
  
• Python (pandas) or R for analysis and automation.
  
• Statistical analysis fundamentals and A/B or cohort analysis experience.
  
• Exposure to data governance metadata and trusted-source / semantic-layer practices.
  
• Awareness of PII/PHI handling and regulated-data sensitivity.
  

• Strong SQL complex joins window functions aggregation query tuning
  
• Power BI and/or Tableau dashboard and report development
  
• Data modeling literacy dimensional / star schema (consumer perspective)
  
• Ability to translate business questions into structured analysis
  
• Strong stakeholder communication and storytelling
  
• 47 years in data analysis / BI / reporting