What are the responsibilities and job description for the Data Analyst- Risk Solutions position at Lockton?
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.
Keep a pulse on the job market with advanced job matching technology.
If your compensation planning software is too rigid to deploy winning incentive strategies, it’s time to find an adaptable solution.
Compensation Planning
Enhance your organization's compensation strategy with salary data sets that HR and team managers can use to pay your staff right.
Surveys & Data Sets
What is the career path for a Data Analyst- Risk Solutions?
Sign up to receive alerts about other jobs on the Data Analyst- Risk Solutions career path by checking the boxes next to the positions that interest you.
