Job Summary:

• Become subject matter expert in industry-related data

• Pull and compile data from multiple, non-standardized source

• Recognize data issues and work with providers of data to resolve problem

• Generate standard and ad hoc reports on a regular basi

• Develop and support new analytical tools and report

• Provide consulting, training, and technical support as need for data intensive project

• Deliver projects accurately and on time

• Prepare spreadsheets, graphs, charts, diagrams, and other illustrative tools used in presentation

• Communicate results to internal and external clients in a consultative manor

• Provide exceptional customer service and adhere to the Lockton philosophie

• Examine and interpret a wide variety of data/information to make recommendations or decision

• Normalizing loss run data from Excel into a SQL database - ensuring the accuracy and completeness of the data in SQL.

Requirements:

• Bachelor's degree in mathematics, statistics, computer science, economics or related field; or equivalent education and/or experience.

• 1-2 years of analytical experience strongly preferred

• Superior attention to detail

• Advanced proficiency with Microsoft Office applications (Excel, Outlook, and PowerPoint)

• Advanced proficiency with Microsoft Excel spreadsheet applications (array formulas, if-then statements, v-lookup, and pivot tables)

• Strong mathematical and statistical aptitude (rates, percentages, statistical analysis)

• Familiarity with BI Reporting Tools and Data Warehouse analysis preferred (Power BI, SQL, Python)

• Demonstrated analytical, critical thinking and problem-solving skills, including research and investigation, to develop results oriented solution

• Ability to quickly grasp new concepts and applications

• Ability to examine and interpret a wide variety of data/information to make recommendations or decision

• Demonstrated effectiveness in working with multi-functional teams in a technical production environment

• Ability to communicate complex technical concepts effectively, both verbally and written

• Ability to multitask without sacrificing the quality and accuracy of project deliverable

• Aptitude to develop unique, creative, and efficient work products. Challenges current procedures to implement alternative methods to streamline and improve work products.

• Assumes ownership for individual projects. Self-motivated to actively seek solutions to problems without supervision.

• Prioritize heavy workloads to meet time sensitive deadlines while handling several project

• Works effectively individually and cooperatively in a team-oriented group setting. Promotes open participation.