Data Engineer

Position Summary

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.

The Data Engineer is responsible for designing, building, and maintaining data pipelines, models, ETL (Extract, Transform, Load) processes and other data infrastructure to support the organization's data needs. The role collaborates with data scientists and analysts to understand data requirements and develops scalable solutions. They build and optimize data pipelines, integrating data from various sources, ensuring data quality and consistency, and implement data governance practices.

What will your job entail?

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.

Required Skills and Qualifications:

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

****ON-SITE IN CHICAGO OFFICE****

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

Preferred Qualifications:

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

Ryan Specialty is an Equal Opportunity Employer. We are committed to building and sustaining a diverse workforce throughout the organization. Our vision is an inclusive and equitable workplace where all employees are valued for and evaluated on their performance and contributions. Differences in race, creed, color, religious beliefs, physical or mental capabilities, gender identity or expression, sexual orientation, and many other characteristics bring together varied perspectives and add value to the service we provide our clients, trading partners, and communities. This policy extends to all aspects of our employment practices, including but not limited to, recruiting, hiring, discipline, firing, promoting, transferring, compensation, benefits, training, leaves of absence, and other terms, conditions, and benefits of employment.

How We Support Our Teammates

Ryan Specialty seeks to offer our employees a comprehensive and best-in-class benefits package that helps them — and their family members — achieve their physical, financial, and emotional well-being goals. In addition to paid time off for company holidays, vacation, sick and personal days, Ryan offers paid parental leave, mental health services and more.

The target salary range for this position is $112,000.00 - $140,000.00 annually.

The wage range for this role considers many factors, such as training, transferable skills, work experience, licensure and certification, business needs, and market demands. The pay range is subject to change and may be modified in the future. Full-time roles are eligible for bonuses and benefits. For additional information on Ryan Specialty Total Rewards, visit our website https://benefits.ryansg.com/.

We provide individuals with disabilities reasonable accommodations to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment in accordance with applicable law. Please contact us to request an accommodation at [email protected]

The above is intended to describe this job's general requirements. It is not to be construed as an exhaustive statement of duties, responsibilities, or physical requirements. Nothing in this job description restricts management's right to assign or reassign duties and responsibilities to this job at any time. Reasonable accommodations may be made to enable individuals with disabilities to perform essential functions.