Actuarial Data Analyst

Core Specialty Insurance Services•Chicago, IL

17h•Hybrid

About The Position

The Core Specialty Data Analytics Team is looking for a Data Analyst. This dynamic role is responsible for supporting all lines of business during an exciting time of growth. The company is in its infancy regarding its data environment and analytics platform, requiring an agile individual willing to learn new techniques and tools as the company grows. This role involves intellectual curiosity, openness to growth and change, candor, and strong communication skills.

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

Nice To Haves

Embrace a “bring-it-on” attitude to attack issues and questions within the dept and across the organization.
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.

Responsibilities

Execute analysis on data to identify and correct data issues.
Extract data from various sources and transform it 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.