Actuarial Data Analyst

Core Specialty Insurance Holdings, Inc.•Cincinnati, OH

1d•Hybrid

About The Position

The Core Specialty Data Analytics Team is seeking a Data Analyst to support all lines of business during a period of significant growth. This dynamic role involves executing data analysis to identify and correct issues, extracting and transforming data from various sources for analysis, and creating actionable visualizations. The position emphasizes a proactive approach to problem-solving, standardizing ad hoc processes, and driving continuous improvement through automation and optimization of ongoing processes, including the development of data processing pipelines. The role also requires acting as a key contributor in resolving complex or expedited requests, demonstrating end-to-end ownership and analytical skills to provide solutions. Collaboration and mutual success are core values, with an emphasis on listening, understanding, and breaking down questions into manageable tasks. The analyst will utilize a variety of applications and technologies to answer both simple and complex questions and provide support to other Analytics areas such as FP&A, Actuarial, Accounting, Claims, and Programs.

Requirements

Bachelor’s degree in an analytical, or related, field: Management Information Systems, Mathematics, Statistics, Computer Science, Actuarial Science and the like.
1-3 years of experience in a professional environment working with data, analytics.
Functional knowledge, aptitude and understanding of basic data/analytics principles: One to many relationships, many to many relationships, reuse and linkage, data quality, validation data modeling and more.
Experience with/or working knowledge of Lakehouse, Warehouse, Semantic models, Datamarts, SQL Databases and other relational data containers.
Experience and/or aptitude in a Microsoft Fabric environment and the tool set included: Python, PySpark, SQL, Dataflow gen 2, Pipelines, Apache Spark jobs, One Lake, Power BI, Data agents, prompt engineering.
Ability to convert raw data into usable and visualized representations that convey understanding and/or enables accurate execution of needed action.
Intellectual curiosity: Seeking understanding of the answers to, whys of data. Uncovering patterns in data and visuals that some might take for granted and researching. Looking for trends and outliers that may be actionable.
Openness to grow and change: the Company is in its infancy regarding our data environment and our analytics platform. Will need to be agile, willing to lean new techniques and tools with us as we grow.
Candor: Openness to providing and receiving constructive feedback to facilitate both individual development as well as elevating the overall capabilities of the Company.
Communication skills: Willingness to ask questions to gain understanding; collaborate effectively both with direct colleagues as well as those in other functional areas; ability to influence and gain buy-in from key stakeholders.
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.

Responsibilities

Execute analysis on data to identify and correct data issues.
Extract data from various sources and transform that data to perform analysis and create actionable visualizations.
Standardize ad hoc processes and drive continuous improvement for automating and optimizing performance of ongoing processes, including development of data processing pipelines.
Act as a key contributor in resolving complex or expedited requests, where end-to-end ownership and analytical skills are needed to provide a solution.
Listen to, understand, and break down questions into manageable tasks.
Use a variety of applications and technologies to answer simple and complex questions.
Provide support for other Analytics areas, such as FP&A, Actuarial, Accounting, Claims, Programs and others as needed.