Senior Support Analyst

Senior Support Analyst

• 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:

• 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.

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.
• 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.

Experience:

• 3 years' experienc.

..

Rate:

Not Specified Location:

cincinnati,

US-OH Type:

Permanent Industry:

Military Recruiter:

Core Specialty Insurance Services, Inc.

Contact:

Not Specified Email:

to view click here

Reference:

JR101382

Posted:

2026-04-09 07:32:21

• View all Jobs from Core Specialty Insurance Services, Inc. Apply Now Share Job More Jobs from Core Specialty Insurance Services, Inc. Safety Coordinator Janitor
• Lexington Kentucky NDT Level II Technician
• X-Ray Reader (Albany, OR) General Maint Worker
• Lexington Kentucky NDT Level III (Albany, OR) Lab Technician I (Albany, OR) Project Manager Licensed Optician
• La Encantada Optician
• Market and Main Optician
• Pike & Rose Advisor

• CLARENDON

  Optometric Technician PT
• Summit Mall Store Leader
• Old Town Los Gatos Sales Supervisor
• Boynton Beach Marketplace Director of Rehabilitation Dietary Cook Dietary Aide-2 Cook Optometrist, FT (PC)
• Crocker Park Licensed Optician
• Coconut Grove