Senior Analyst

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.
  
  

Technical Knowledge and Understanding:

• Strong understanding of Bordereau data structures and insurance data reporting.
• Proficiency in Power BI, including DAX, data modeling, and visualization best practices.
• Familiarity with data ingestion processes, schema validation, and ETL concepts.
• Ability to interpret and analyze complex datasets for quality and compliance.
• Experience working with external partners or clients on data-related deliverables.
• Knowledge of data governance, data quality standards, and documentation practices.
• Excellent communication and stakeholder engagement skills.
• Basic proficiency in Microsoft Office Products\
• Advanced Skills in Excel Preferred
  
  

Experience:

• 5 years’ experience in data processing.
  
  

Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa for this position.

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