Core Specialty
Senior Support Analyst
TX Dallas, USA · Senior
No sponsorshipDetected 77 days ago
Data StructuresSQLSparkData EngineeringData VisualizationExcelCommunicationMicrosoft Office
About the role
- This role is responsible for ensuring the successful ingestion and validation of Bordereau data files from insurance agencies.
Responsibilities
- Engage with insurance agencies to review and validate Bordereau file layouts for ingestion readiness.
- 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.
- Support continuous improvement initiatives related to data ingestion and reporting workflows.
Nice to have
- 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.
- 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.
- Knowledge of data governance, data quality standards, and documentation practices.
- Excellent communication and stakeholder engagement skills.
Compensation
- At Core Specialty, you will receive a competitive salary and opportunities for professional development and advancement.
Visa & Work Authorization
- Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over work authorization sponsorship now or in the future for this position.
Apply directly at Core Specialty →Create a free account for alerts like thisView Core Specialty immigration profile
This listing is sourced directly from Core Specialty's careers page and normalized into a canonical job model.