Data Analyst

The Data Analyst will be responsible for ongoing analysis of client, policy, exposure, and loss information, obtained from a variety of different sources. It involves development and preparation of information and reports for management, associates, and other custom built applications.

Job Duties:

• Become subject matter expert in industry-related data

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

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

• Generate standard and ad hoc reports on a regular basis

• Develop and support new analytical tools and reports

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

• Deliver projects accurately and on time

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

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

• Provide exceptional customer service and adhere to the Lockton philosophies

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

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

• Ability to quickly grasp new concepts and applications

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

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

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

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