Job Title: Reporting Data Analyst with P&C Exp
Job Location: Alpharetta GA; Charlotte NC; Chicago IL; Conshohocken PA; Dallas TX; Denver CO; Fargo ND; Garden City NY; Houston TX; Lenexa KS; Lubbock TX; Morristown NJ; Mt Juliet TN; New York NY; Purchase NY; Topeka KS.
Job Duration: Long term
| ROLE SUMMARY |
| The Reporting Data Analyst partners with business groups across the Property & Casualty (P&C) insurance domain to define and deliver reporting and data extracts requirements. This role serves as a subject matter expert (SME) on enterprise data warehouse content and key source systems ensuring accurate interpretation of insurance data consistent definitions and reliable reporting outputs. |
| ROLE RESPONSIBILITIES |
- Act as a data and domain SME 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 QUALIFICATIONS |
- 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 product.
- 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 modelling and enterprise reporting concepts.
|
| GENERAL QUALIFICATIONS |
- Strong initiative; able to self-manage. Comfortable with ambiguity and able to work through it to get the right things done.
- Excellent Communication skills both written and verbal understanding communication channels and escalation paths.
- Proven experience working directly with senior business stakeholders.
|
| EDUCATION REQUIREMENTS |
- Bachelors degree in computer science MIS related field or equivalent experience.
|
Job Title: Reporting Data Analyst with P&C Exp Job Location: Alpharetta GA; Charlotte NC; Chicago IL; Conshohocken PA; Dallas TX; Denver CO; Fargo ND; Garden City NY; Houston TX; Lenexa KS; Lubbock TX; Morristown NJ; Mt Juliet TN; New York NY; Purchase NY; Topeka KS. Job Duration: Long term ...
Job Title: Reporting Data Analyst with P&C Exp
Job Location: Alpharetta GA; Charlotte NC; Chicago IL; Conshohocken PA; Dallas TX; Denver CO; Fargo ND; Garden City NY; Houston TX; Lenexa KS; Lubbock TX; Morristown NJ; Mt Juliet TN; New York NY; Purchase NY; Topeka KS.
Job Duration: Long term
| ROLE SUMMARY |
| The Reporting Data Analyst partners with business groups across the Property & Casualty (P&C) insurance domain to define and deliver reporting and data extracts requirements. This role serves as a subject matter expert (SME) on enterprise data warehouse content and key source systems ensuring accurate interpretation of insurance data consistent definitions and reliable reporting outputs. |
| ROLE RESPONSIBILITIES |
- Act as a data and domain SME 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 QUALIFICATIONS |
- 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 product.
- 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 modelling and enterprise reporting concepts.
|
| GENERAL QUALIFICATIONS |
- Strong initiative; able to self-manage. Comfortable with ambiguity and able to work through it to get the right things done.
- Excellent Communication skills both written and verbal understanding communication channels and escalation paths.
- Proven experience working directly with senior business stakeholders.
|
| EDUCATION REQUIREMENTS |
- Bachelors degree in computer science MIS related field or equivalent experience.
|
View more
View less
Job Location:
Monthly Salary:
Not Disclosed
Posted on:
8 hours ago
Vacancies:
1 Vacancy
