Senior Data Analyst: Insurance Insights & Dashboards

TechDigital Group; Princeton (NJ); On-site; USD 70,000 - 90,000; Full time

Job summary

A prominent tech firm is seeking a Data Analyst with strong experience in the insurance domain to analyze data and create reports. Responsibilities include working with business stakeholders to identify analytics needs, developing dashboards using BI tools like Power BI, and writing SQL queries for data extraction. Ideal candidates should have hands-on insurance experience and proficiency in data analysis and SQL. The position is based in Princeton, NJ, offering the chance to work on impactful data-driven projects.

Qualifications

• Strong hands-on experience in Insurance (P&C, Life, Annuity, or Reinsurance).
• Proficiency in SQL for querying and data analysis.
• Experience with BI tools, particularly Power BI and Tableau.

Responsibilities

• Work closely with business stakeholders to understand reporting and analytics needs.
• Translate business questions into data analysis and dashboards.
• Conduct requirement-gathering sessions and prepare BRDs.

Skills

Insurance Domain Experience

Data Analysis

SQL Proficiency

Power BI

Excel

Tools

Power BI

Tableau

SQL Server

Oracle

PostgreSQL

Job description

Business & Stakeholder Engagement
Work closely with business stakeholders (Underwriting, Claims, Actuarial, Finance, Operations) to understand reporting and analytics needs.
Translate business questions and KPIs into data analysis, reports, and dashboards.
Conduct requirement‐gathering sessions and prepare business requirement documents (BRDs) and reporting specifications.
Present insights, trends, and recommendations to business and leadership stakeholders in a clear and concise manner.
Data Analysis & Reporting
Analyze data related to policy lifecycle, claims, premiums, losses, exposure, reserves, and billing.
Develop and maintain dashboards, reports, and scorecards using BI tools (Power BI, Tableau, etc.).
Perform trend analysis, variance analysis, and root‐cause analysis.
Support regulatory, operational, and management reporting.
Validate data accuracy and ensure consistency across reports.
Data Collaboration
Write and optimize SQL queries to extract and analyze data from enterprise systems.
Collaborate with data engineering teams on data availability, data quality, and transformations.
Assist with data reconciliation, data quality checks, and issue resolution.
Document data definitions, business rules, assumptions, and metrics.

above is the JD

Insurance Domain Experience (Mandatory)
Strong hands‐on experience in Insurance (P&C, Life, Annuity, or Reinsurance).
Solid understanding of:
Policy lifecycle (Quote, Bind, Issue, Endorse, Renew)
Claims lifecycle and claims financials
Premiums, losses, reserves, exposure
Billing and invoicing

Experience working with insurance platforms such as Guidewire, Duck Creek, Sapiens, or similar is highly preferred.
Technical & Analytical Skills
Strong experience as a Data Analyst in enterprise environments.
Proficiency in SQL for querying and data analysis.
Hands‐on experience with BI tools:
Power BI (preferred)
Tableau / Qlik (or similar)

Strong experience with Excel (pivot tables, formulas, data analysis).
Experience working with relational databases (SQL Server, Oracle, PostgreSQL).
Familiarity with data warehousing and dimensional models.

Preferred Skills
Exposure to Azure / Cloud data platforms.
Experience with Power BI semantic models, DAX, and Power Query.
Knowledge of data governance, metadata, and data quality frameworks.
Experience working in Agile/Scrum delivery models.
Ability to support executive dashboards and self‐service BI.