Data Engineer

Ryan Specialty Group

Chicago, IL

Full Time

Senior

112k-140k

26 days ago

Job Description

About the Role

We are looking for a skilled Data Engineer to join our actuarial team and lead various data-related projects. This role is crucial for the development and maintenance of our central Catastrophe (CAT) and Property Data Hub, which will feed into our corporate Enterprise Data Hub (EDH). The ideal candidate will have strong data engineering skills, with a focus on SQL programming and ETL processes, and will be comfortable working with both on-premises and cloud-based systems.

Key Responsibilities

Lead and manage data engineering projects within the actuarial team.
Develop and maintain a central CAT/Property Data Hub for reporting, analytics, and visualizations.
Integrate and centralize data from various source systems and data structures used by our Managing General Underwriters (MGUs) and CAT modelling team.
Automate ETL processes to ensure efficient data handling and processing.
Create and maintain Power BI dashboards for data visualization.
Perform ad hoc data analysis and support data science initiatives.
Collaborate with the cloud migration team to transition data processes to Azure.
Work closely with the CAT modeling team.

Requirements

Bachelor's degree required. Computer science, Information Technology, or Actuarial Science is preferred. Any other related discipline or commensurate work experience considered.
5+ years of experience in Data Engineering with a Bachelor's degree, or 3 years of experience with a Master's degree.
Experience with data engineering and data analysis.
Strong/Advanced SQL skills, including SSMS, SSIS, and ETL processes.
Extensive experience in data analysis, including the ability to interpret complex insurance data and derive actionable insights.
Proficiency in data visualization tools, especially Power BI.
Excellent problem-solving skills and attention to detail.
Strong communication and collaboration skills.
Insurance experience required.
Applicants must be authorized to work for ANY employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.

Nice to Have

Experience in the insurance industry, particularly in underwriting management/actuarial science.
Familiarity with cloud platforms, particularly Azure, is highly desirable.
Knowledge of CAT modeling software (AIR and RMS) is a plus.
Knowledge of unstructured data handling and integration.
Familiarity with automation tools and techniques.

Qualifications

Bachelor's degree in a relevant field such as computer science, information technology, or actuarial science.

Benefits & Perks

Comprehensive and best-in-class benefits package including paid time off for holidays, vacation, sick and personal days.
Paid parental leave, mental health services, and more.
Target salary range of $112,000.00 - $140,000.00 annually.
Full-time roles are eligible for bonuses and benefits.
Reasonable accommodations for individuals with disabilities.

Working at Ryan Specialty Group

Ryan Specialty is an Equal Opportunity Employer committed to building and sustaining a diverse, inclusive, and equitable workplace where all employees are valued for their performance and contributions. The company values diverse perspectives and strives to create an environment that supports physical, financial, and emotional well-being for its employees.

Apply Now