Job ID: JOB_ID_3164
Job Summary:
We are seeking a highly skilled and experienced Reporting Data Analyst with a strong background in Property & Casualty (P&C) insurance to join our team. This role will involve acting as a key data and domain analyst for P&C insurance subject areas, including policy, claims, and financials. You will collaborate closely with business stakeholders to gather, clarify, and validate reporting and extract requirements. A critical part of this role is translating complex insurance business concepts into accurate data logic, metrics, and dimensional definitions.
Key Responsibilities:
- Act as a data and domain Analyst for P&C insurance subject areas (e.g., policy, claims, financials).
- Collaborate with business stakeholders to gather, clarify, and validate reporting and extract requirements.
- Translate insurance business concepts into accurate data logic, metrics, and dimensional definitions.
- Leverage knowledge of source applications (e.g., Guidewire, Genius, SAP) to ensure correct data interpretation and lineage.
- Ensure reports and extracts align with approved business definitions, regulatory needs, and data governance standards.
- Create and validate SQL queries, views, or semantic-layer objects against the enterprise data warehouse.
- Review and certify reports for accuracy, reconciliation, and consistency across systems.
- Document data definitions, business rules, and reporting assumptions.
- Support UAT and investigate data discrepancies between source systems and the data warehouse.
- Educate business users on proper interpretation and usage of insurance data.
Technical Skills Required:
- 8+ years as a hands-on IT Reporting data analyst.
- 4+ years of experience in reporting or data analysis within the Property & Casualty insurance industry; reinsurance experience is preferred but not required.
- 3+ years hands-on experience with Strategy (formerly MicroStrategy), Microsoft Power BI, or similar reporting products.
- Working knowledge of insurance source systems such as Guidewire (Policy, Billing, Claims), Genius, and SAP.
- Strong SQL skills and experience querying enterprise data warehouses.
- Understanding of dimensional modeling and enterprise reporting concepts.
Location and Employment Type:
This is a remote position. The role requires hybrid work, with 3 days per week onsite, starting from day one. While the role is listed as remote, the hiring team prefers candidates located in GA, NC, IL, PA, TX, CO, ND, NY, KS, NJ. The duration is long-term.
Experience:
A minimum of 8+ years of relevant experience is required.
About the Company:
This position is with an end client in the P&C insurance sector. Intellisoft Technologies is assisting in the recruitment process.
Special Requirements
Hybrid 3 days per week. Preferred locations: GA/NC/IL/PA/TX/CO/ND/NY/KS/NJ.
Compensation & Location
Salary: $70,000 – $120,000 per year (Estimated)
Location: Remote
Recruiter / Company – Contact Information
Email: a@intellisofttech.com
Recruiter Notice:
To remove this job posting, please send an email from
a@intellisofttech.com with the subject:
DELETE_JOB_ID_3164