Data Analyst at Lockton Companies - UAE

Overland Park, Kansas, United States -

Full Time

Start Date

Immediate

Expiry Date

30 Sep, 26

Salary

0.0

Posted On

02 Jul, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

Microsoft SQL, Microsoft Excel, Microsoft PowerBI, VBA, Data Analysis, Financial Reporting, PeopleSoft, Oracle Fusion, OTBI, Technical Support, Project Management, Data Reconciliation

Industry

Insurance

Description

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

How To Apply:

Incase you would like to apply to this job directly from the source, please click here

Responsibilities

The Data Analyst is responsible for analyzing finance, client premium, and revenue data from various sources to create reports and reconciliations. They serve as a subject matter expert, developing Excel-based tools and providing technical support for data-intensive projects.