-
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.
#LI-Hybrid
-
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
Top Skills
What We Do
Core Specialty, through its subsidiary insurers, offers a diversified range of property, casualty, and marine insurance products for small to mid-sized businesses.
We have the capital to take on risk, the underwriting talent in place, decisive leadership team, infrastructure, and a proven track record of making things happen – fast!
When you’re ready to solve your toughest insurance needs, we’re ready to get it done for you.
We free customers up to focus on their business by taking the load of complicated specialty insurance off their hands.
We break down the walls of bureaucracy to provide optimal underwriting solutions for brokers.
We’re ready, equipped, and motivated to get the job done, efficiently and professionally, by empowering experts with what they need to move quickly on behalf of customers and their brokers.
Our specialty focus is the essential part of our identity.
It is at our core
