Intern – AXIS Research Center at AXIS (AXIS… · Universit…

Summary: AXIS Capital is a trusted global provider of specialty lines insurance and reinsurance, seeking student interns from the University of Illinois at Urbana-Champaign to support their Exposure Management division. The internship offers hands-on experience in the insurance industry, focusing on data processing and analytics projects to enhance business insights. Responsibilities: - Integrate with project teams and work closely with senior staff - Write custom SQL code for data processing, ETL, data aggregation - Build custom views/ virtual tables - Clean the source data as needed - Manage structured and unstructured data - Work with multiple data sources and disparate data types - Improve on current data flows and processing efforts - Take existing Excel VBA processes and standardize with SQL scripts - Report on specific metrics - Develop and maintain technical and process-based documentation Required Qualifications: - Integrate with project teams and work closely with senior staff - Write custom SQL code for data processing, ETL, data aggregation - Build custom views/ virtual tables - Clean the source data as needed - Manage structured and unstructured data - Work with multiple data sources and disparate data types - Improve on current data flows and processing efforts - Take existing Excel VBA processes and standardize with SQL scripts - Report on specific metrics - Develop and maintain technical and process-based documentation Preferred Qualifications: - Experience scripting in Python or R - Experience with visualization tools - Big Data tools - Any cloud computing (DataBricks, Azure) Required Skills: SQL, ETL, Data processing, Data aggregation, Data cleaning, Structured data management, Unstructured data management, Excel VBA, Python, R, Data visualization, Big Data tools, Cloud computing