Data Analyst

Your 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 needed 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

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

About Lockton

Lockton is the largest privately held independent insurance brokerage in the world. Since 1966, our independence has allowed us to serve our clients, take care of our people and give back to our communities. As such, our 13,100+ Associates doing business in over 155 countries are empowered to do what’s right every day.

Lockton Benefits Offerings

Click Here

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.

How We Will Support You

We are ready to meet you where you are today, and as your needs change over time. In addition to industry-leading health insurance, we offer additional options to support your overall health and wellbeing.

No Agencies Please

No Agencies Please

Similar Vacancies

View allLife at Lockton