Data Analyst
Lockton Companies
- Overland Park, Kansas, United States
- Overland Park, Kansas, United States
Über
At Lockton, we’re passionate about helping our people achieve their ultimate potential. Our people are curious, action-oriented and always striving to make ourselves and those around us better. We’re active listeners working to ensure understanding and problem solvers developing innovative solutions. If you can see yourself delivering excellent service to clients, giving back to our communities and being a part of our caring culture, you belong here.
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 philosophies
Qualifications
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
Equal Opportunity Statement Lockton Companies is proud to provide everyone an equal opportunity to grow and advance. We are committed to an inclusive culture and environment where our people, clients and communities are treated with respect and dignity. At Lockton, supporting diversity, equity and inclusion is ingrained in our values, and we believe that we are at our best when we fully embrace everyone. We strive to cultivate a caring culture that learns from, celebrates and thrives because of our breadth of differences. As such, we recognize that recruiting, developing and retaining people with diverse backgrounds and experiences is vital and enabling our people to thrive personally and professionally is critical to our long-term success.
#J-18808-Ljbffr
Sprachkenntnisse
- English
Hinweis für Nutzer
Dieses Stellenangebot stammt von einer Partnerplattform von TieTalent. Klick auf „Jetzt Bewerben”, um deine Bewerbung direkt auf deren Website einzureichen.