Lockton · 4 days ago
Data Analyst
Wonder how qualified you are to the job?
ConsultingEmployee Benefits
Insider Connection @Lockton
Responsibilities
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.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
Bachelor’s degree in mathematics, statistics, computer science, economics or related field; or equivalent education and/or experience.
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)
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
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
Preferred
1-2 years of analytical experience strongly preferred
Familiarity with BI Reporting Tools and Data Warehouse analysis preferred (Power BI, SQL, Python)
Company
Lockton
Lockton is an insurance brokerage organization that offers services such as extensive assessment, research, and best-fit programs.
Funding
Current Stage
Late StageRecent News
Indus Business Line
2024-02-03
Kansas City Business Journal
2024-02-03
2024-01-24
Company data provided by crunchbase