-
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
Key Accountabilities/Deliverables:
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
Technical Knowledge and Understanding:
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.
Experience:
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.
The expected pay range for the role is $70,000 - $75,000. The specific offer will depend on an applicant’s skills and experiences. The disclosed pay range estimate may also be adjusted for the applicable geographic differential for the location in which the position is filled.
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.
#LI-Hybrid
-
At Core Specialty, you will receive a competitive salary and opportunities for professional development and advancement. We offer 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, and a wellness program
Skills Required
- Bachelor's degree in an analytical or related field
- 1-3 years of experience in a professional environment working with data
- Experience with SQL Databases and relational data containers
- Experience in Microsoft Fabric environment including Python and Power BI
What We Do
Core Specialty, through its subsidiary insurers, offers a diversified range of property, casualty, and marine insurance products for small to mid-sized businesses. We have the capital to take on risk, the underwriting talent in place, decisive leadership team, infrastructure, and a proven track record of making things happen – fast! When you’re ready to solve your toughest insurance needs, we’re ready to get it done for you. We free customers up to focus on their business by taking the load of complicated specialty insurance off their hands. We break down the walls of bureaucracy to provide optimal underwriting solutions for brokers. We’re ready, equipped, and motivated to get the job done, efficiently and professionally, by empowering experts with what they need to move quickly on behalf of customers and their brokers. Our specialty focus is the essential part of our identity. It is at our core








