Data Analyst

$57,750 - $73,500/Yr

Lockton Companies - Los Angeles, CA

Full-time - Entry Level

Los Angeles, CA

5,001-10,000 employees

Insurance Carriers and Related Activities

About the position

The Data Analyst position at Lockton involves becoming a subject matter expert in industry-related data, pulling and compiling data from various sources, and generating reports. The role requires strong analytical skills to interpret data and make recommendations, while also providing exceptional customer service and support for data-intensive projects.

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 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 manner
• Examine and interpret a wide variety of data/information to make recommendations or decisions
• Normalize loss run data from Excel into a SQL database, ensuring 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
• 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.

Nice-to-haves

• Familiarity with BI Reporting Tools and Data Warehouse analysis (Power BI, SQL, Python)

Benefits

• Industry-leading health insurance
• Opportunities for career growth and development
• Support for overall health and wellbeing