What are the responsibilities and job description for the Senior Support Analyst position at Core Specialty Insurance Holdings, Inc.?
The Senior Support Analyst role combines both analytical and technical skills.
This role 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, building and managing data pipelines & data flows to ingest data 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:
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
This role 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, building and managing data pipelines & data flows to ingest data 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.
- Build and maintain data pipelines and dataflows within Microsoft Fabric (e.g., Dataflows Gen2, Pipelines).
- 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.
- 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.
- Experience building and managing data pipelines and dataflows within Microsoft Fabric (e.g., Dataflows Gen2, Pipelines).
- Working knowledge of Lakehouse architecture, including raw vs. curated data layers and table design best practices.
- Familiarity with data transformation concepts (e.g., normalization, standardization, enrichment) applied to semi‑structured or file‑based data.
- Experience aligning ingested data to conformed premium and claim data models.
- 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
- Exposure to Spark SQL or notebooks within Fabric or similar platforms is preferred.
- 3 years’ experience in data processing.
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