Reporting Data Analyst

Dallas, IA - USA

Monthly Salary: Not Disclosed

Posted on: 23 hours ago

Vacancies: 1 Vacancy

Job Summary

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.
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