Data Analyst

Job Summary:

The Data Analyst is responsible for ongoing analysis of finance, client premium and revenue data, obtained from a variety of different sources. It involves development and preparation of information, reconciliations and reports for management, Associates, and other custom-built applications.

Essential Duties:

•Subject matter expert for finance, client premium and revenue data

•Generate standard and ad hoc reports on a regular basis

•Create Excel based data analysis tools to identify variances with macros

•The data analyst must be able to recognize data issues and work with providers of data to resolve problems

•Provides consulting, training, reporting and primary technical support as need for data intensive projects throughout the project lifecycle including post go-live

•Responsible for monitoring progress and maintaining responsibility for delivering project deliverables accurately and on time

•Ad hoc technical analysis of jobs, queries, reports, & other items across ERPs & Systems

Other Responsibilities:

•Makes decisions in compliance with established corporate and department standards

•Provides exceptional customer service and adheres to the Lockton philosophie

Requirements:

• BS/BA degree required

• At least 3 years of experience in data analysis in the insurance industry or related field

• At least 3 years of experience in working with project teams in an information technology environment

• Proficiency with Microsoft SQL, Microsoft Excel, Microsoft PowerBI and VBA for Excel macros

• Use advanced Excel capabilities, including pivot tables, lookups, complex formulas and graphing

• Familiarity with PeopleSoft query and nVision or Oracle Fusion and OTBI a plus

• Ability to express complex technical concepts effectively, both verbally and written

• Ability to work well with & and describe tasks to non-technical users

• Demonstrated ability to analyze data in a variety of formats and to provide recommendations and support in establishing strategic plans for undertaking data conversions

• Demonstrated effectiveness in working with multi-functional teams in a technical production environment

• Demonstrated ability to respond to customer requirements with timely and effective technical solutions

• Ability to synthesize data from multiple sources

• Superior attention to detail

• Ability to multitask without sacrificing the quality and accuracy of project deliverables

• Some overtime, off-shift support and travel may be required

#LI-JM