Data Analyst

Job Title: Data Analyst Location: Charlotte, NC Employment Type: Full-time Industry: Insurance Domain 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 such as emerging loss patterns, fraud indicators, and 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 4–7+ 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 consumer's 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 in 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. Benefits Standard full‑time benefits. #J-18808-Ljbffr