What are the responsibilities and job description for the Data Analyst- Risk Solutions position at Lockton Companies Social Sourcing?
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.
