Vienna Consultancy

Data Reporting Analyst

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Reporting Analyst on a 6-month contract, hybrid location. Requires 8+ years of experience, 4+ years in Property & Casualty insurance, strong SQL skills, and proficiency in reporting tools like Microsoft Power BI.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
February 5, 2026
🕒 - Duration
More than 6 months
-
🏝️ - Location
Hybrid
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
New York, United States
-
🧠 - Skills detailed
#SQL (Structured Query Language) #Dimensional Modelling #SQL Queries #BI (Business Intelligence) #Data Governance #EDW (Enterprise Data Warehouse) #Microsoft Power BI #"ETL (Extract #Transform #Load)" #SAP #Alation #UAT (User Acceptance Testing) #Computer Science #Data Analysis #Scala #Data Warehouse #Strategy #Data Interpretation
Role description
Title- Reporting Data Analyst Job Type: Contract Contract Duration : 6 Months (Extendable ) Location / Mode- Hybrid -Minimum 3 days a week. Location - Alpharetta, GA; Charlotte, NC; Chicago, IL; Colorado Springs, CO; Conshohocken, PA; Dallas, TX; Denver, CO; Fargo, ND; Garden City, NY; Houston, TX; Jacksonville, IL; Lenexa, KS; Lubbock, TX; Morristown, NJ; Mt Juliet, TN; New York, NY; Purchase, NY; Topeka, KS (Any location will work) Experience: 8+ Years Notice Period: Immediate to 4 weeks 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 • Bachelor's degree in Computer Science, MIS, related field, or equivalent experience.