Skills

Data Analysis SQL Data Governance SAP Data interpretation power bi

Job Specifications

Title: Reporting Data Analyst with P&C Insurance

Locations: GA/NC/IL/PA/ TX/CO/ND/NY/KS/NJ/TN – Hybrid 03 days per week from day 1

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:

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.

About the Company

OtB Tech LLC is a leading staffing firm that provides customized workforce solutions to businesses of all sizes. Our company has a proven track record of providing high-quality staffing services that meet our clients' needs and exceed their expectations. Here are some key features of our capabilities: Comprehensive Staffing Services: We offer a full range of staffing solutions, including temporary, temp-to-perm, and direct-hire placements. Our staffing services cover various industries, including Information Technology, Heal... Know more