Lockton is a global professional services firm with 6,500 Associates who advise clients on protecting their people, property and reputations. Lockton has grown to become the world's largest privately held, independent insurance broker by helping clients achieve their business objectives. To see the latest insights from Lockton's experts, check Lockton Market Update.
A few reasons Associates love working at Lockton include:
- Opportunities for growth and advancement, including paid training and professional development
- 12-week paid parental leave
- A huge emphasis on community involvement
- Frequent athletic and wellness events
- Incredibly generous rewards; US Associates receive a Rolex for their 10-year anniversary!
Data Analyst- Risk Solutions
- 📅
- Jan 23, 2025 Post Date
- 📅
- 745 Total Views
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.
Lockton is known throughout the insurance industry as an entrepreneurial, progressive and successful insurance broker. As a result of continued individual and group accomplishments, Lockton has a record of steady and substantial growth. If you are a committed professional with a passion for delivering unparalleled service, Lockton is interested in hearing from you.
No Agencies Please
Any Employment Agency, person or entity that submits an unsolicited resume to this site does so with the understanding that the applicant's resume will become the property of Lockton Companies, Inc. Lockton Companies will have the right to hire that applicant at its discretion and without any fee owed to the submitting Employment Agency, person or entity. Employment Agencies, who have fee Agreements with Lockton Companies must submit applicants to the designated Lockton Companies Employment Coordinator to be eligible for placement fees.
Connect with Us