Data analyst Jobs in Chicago, IL

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