Business Data Analyst with P&C Insurance at Princeton, NJ(Hybrid)
E-Solutions
About the role
Title
Business Data Analyst
Location
Princeton, NJ (Hybrid)
Type
Contract
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.
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.
Thanks & Regards
Ash Kumar
Client Engagement Partner
M:
E:
Disclaimer: E‑Solutions Inc. provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, genetic information, marital status, amnesty, or status as a covered veteran in accordance with applicable federal, state and local laws. We especially invite women, minorities, veterans, and individuals with disabilities to apply. EEO/AA/M/F/Vet/Disability.
Keywords: Business Data Analyst with P&C Insurance1SQL,p&c,Data analyst,power bi,Business Data AnalystN/AC2CUnited States
Requirements
- Strong hands-on experience in Insurance (P&C, Life, Annuity, or Reinsurance).
- Solid understanding of Policy lifecycle (Quote, Bind, Issue, Endorse, Renew).
- Solid understanding of Claims lifecycle and claims financials.
- Solid understanding of Premiums, losses, reserves, exposure.
- Solid understanding of Billing and invoicing.
- Strong experience as a Data Analyst in enterprise environments.
- Proficiency in SQL for querying and data analysis.
- Hands-on experience with BI tools.
- 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.
Responsibilities
- 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.
- 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.
- 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.
Skills
Similar roles
Innovative Senior Financial Analyst for Strategic Decision Support
ACCO Brands
Program Manager - FinOps PMO Delivery , Finance Operations PMO (FinOps)
ADCI HYD 13 SEZ - H84
Role: Business Analyst with Finance Exp (Hybrid) - Location: Richmond, VA (In-Person Interview) - 100% Only Locals (VA) with Valid DL Copy
Jobs via Dice
Don't send a generic resume
Paste this job description into Mimi and get a resume tailored to exactly what the hiring team is looking for.
Get started free