-

The Senior Analyst is responsible for ensuring the successful ingestion and validation of Bordereau data files from insurance agencies. This role plays a critical part in verifying data layout and schema compliance, analyzing data quality, and designing insightful experience reporting using Power BI. The analyst serves as a key liaison between internal teams and external partners to ensure data integrity and reporting excellence.

Key Accountabilities/Deliverables:

• Engage with insurance agencies to review and validate Bordereau file layouts for ingestion readiness.
• Confirm data schemas align with internal ingestion requirements and standards.
• Analyze and validate data fields for completeness, accuracy, and consistency.
• Collaborate with internal stakeholders to resolve data discrepancies and ingestion issues.
• Design, build, and maintain Power BI dashboards and reports to support experience reporting and operational insights.
• Document data validation processes, schema requirements, and reporting logic.
• Support quarterly and ad hoc reporting needs, including executive summaries, KPI dashboards, and audit responses.
• Provide subject matter expertise on Bordereau data structure and reporting best practices.
• Support continuous improvement initiatives related to data ingestion and reporting workflows.

-

At Core Specialty, you will receive a competitive salary and opportunities for professional development and advancement. We offer medical, dental, vision, and life insurances; short and long-term disability; a Company-match of 100% of a 6% contribution 401(k) plan; an Employee Assistance Plan; Health Savings Account, Flexible Spending Account, Health Reimbursement Account, and a wellness program