Data Analyst

Lockton • Overland Park, KS

4d

About The Position

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.

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

Nice To Haves

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

Responsibilities

• 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
• Makes decisions in compliance with established corporate and department standards
• Provides exceptional customer service and adheres to the Lockton philosophies

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level