> Markdown version of [/jobs/ext/1179703-data-analyst](https://www.wearedevelopers.com/jobs/ext/1179703-data-analyst). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Data Analyst - **Company:** Lockton - **Location:** Overland Park, KS, United States - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Data Analysis, Excel Formulas, Excel Macros, Microsoft SQL Server, Pivot Tables, Power BI, Oracle Fusion Middleware, WebKit, Macros, Information Technology, People Soft, Vba Programming Language - **Published:** July 4, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=360adb878ed8a56b ## About the Role * 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 ## Description css-1y3ojfh{display: -webkit-box;display: -webkit-flex;display: -ms-flexbox;display: flex;-webkit-flex-direction: row;-ms-flex-direction: row;flex-direction: row;gap: 16px;-webkit-align-items: center;-webkit-box-align: center;-ms-flex-align: center;align-items: center;} .css-1xvinid{margin: 0;font-family: "Roboto","Helvetica","Arial",sans-serif;font-weight: 400;font-size: 2.125rem;line-height: 1.235;letter-spacing: 0.00735em;} Your Responsibilities 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 ## Related Videos - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Anomaly Detection - Using unsupervised Machine Learning for detecting anomalies in customer base](https://www.wearedevelopers.com/videos/6-anomaly-detection-using-unsupervised-machine-learning-for-detecting-anomalies-in-customer-base) - [Crafting Custom Frameworks with Rust: A Deep Dive into Procedural Macros](https://www.wearedevelopers.com/videos/849-crafting-custom-frameworks-with-rust-a-deep-dive-into-procedural-macros) - [Rust and Docker: Let's build an AI-powered app!](https://www.wearedevelopers.com/videos/984-rust-and-docker-let-s-build-an-ai-powered-app) - [Enjoying SQL data pipelines with dbt](https://www.wearedevelopers.com/videos/823-enjoying-sql-data-pipelines-with-dbt) - [REST, GraphQL, gRPC, and more: A comparison of modern API styles](https://www.wearedevelopers.com/videos/100247-rest-graphql-grpc-and-more-a-comparison-of-modern-api-styles) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Best Companies to work for in London: Top 25 Companies in 2023](https://www.wearedevelopers.com/magazine/187-best-companies-to-work-for-in-london-top-25-companies-in-2023) - [Data Analyst Salary Austria](https://www.wearedevelopers.com/magazine/275-data-analyst-salary-austria)