Data Analyst

Overland Park, Kansas, United States of America 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