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

Other Responsibilities:

• Makes decisions in compliance with established corporate and department standards

• Provides exceptional customer service and adheres to the Lockton philosophies

Education, Experience and Skills Required:

• 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 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