Actuarial Data Analyst at Core… · Cincinnati

Summary: Core Specialty Insurance Holdings, Inc. is seeking a Data Analyst to join their Data Analytics Team during a period of growth. The role involves executing data analysis, standardizing processes, and providing support across various analytics areas. Responsibilities: - Execute analysis on data to identify and correct data issues. Extracting data from various sources and transforming that data to perform analysis and create actionable visualizations - Live our Values: Embrace a “bring-it-on” attitude to attack issues and questions within the dept and across the organization - Standardize ad hoc processes and drive continuous improvement for automating and optimizing performance of ongoing processes, including development of data processing pipelines - Help Others Succeed: Act as a key contributor in resolving complex or expediated requests, where end-to-end ownership and analytical skills are needed to provide a solution. As mentioned, we all work and grow together! The more successful one member is, the more successful we all are - 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 Required Qualifications: - 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 Required Skills: Data analysis, Data extraction, Data transformation, Data visualization, Data quality validation, Data modeling, SQL, Python, PySpark, Microsoft Fabric, Power BI, Apache Spark, Constructive feedback Benefits: 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, A wellness program