Lockton is a global professional services firm with more than 8,000 Associates who advise clients on protecting their people, property and reputations. Lockton has grown to become the world's largest privately held, independent insurance broker by helping clients achieve their business objectives. Check out the latest insights from Lockton's experts.
A few reasons Associates love working at Lockton include:
- Opportunities for growth and advancement, including paid training and professional development.
- 12-week paid parental leave.
- An emphasis on community involvement and giving back.
- Frequent athletic and wellness events.
- Incredibly generous rewards; US Associates receive a Rolex for their 10-year anniversary!
- We are uncommonly and perpetually independent.
Data Analyst, Specialty Consulting
- 📅
- Oct 14, 2024 Post Date
- 📅
- 1016 Total Views
Due to our success and increased business opportunities, we are looking for a Data Analyst to provide technical and analytical support within the Lockton Specialty Practices. The ideal candidate will demonstrate a high level of professionalism, possess the ability to work well in a fast-paced environment, the flexibility to easily adapt to changing priorities and desire to engage in new opportunities to learn. This position is a full-time hybrid role that would report into our Plano, TX or Dallas, TX office. Flexible scheduling will be considered for students working around a class schedule.
- Assist in the design, development, and deployment of data aggregation, report generation, and data analysis utilizing Alteryx workflows to analyze trends and manage department workload more efficiently.
- Understand data sources, processes, formulas, and output and be able to manipulate large volumes of data.
- Create and deliver custom dashboards for internal stakeholders.
- Monitor the quality of data, perform data validation checks on various data sets, troubleshoot data-related issues, and resolve them timely to maintain data integrity.
- Collaborate with stakeholders to understand data pipelines and provide impactful automated solutions to support organizational goals.
- Support ongoing data collection and reporting initiatives, ensuring accuracy, completeness, and timeliness of data.
- Exchange findings and solutions with colleagues across projects, sharing learnings and best practices.
- Work with end users to validate user acceptance testing and implement automated processes smoothly.
- Bachelor’s degree in Business, Computer Science, Statistics, Mathematics, Social Sciences, or related field.
- Minimum 1+ years of relevant experience utilizing data aggregation or data visualization tools
- Experience with Alteryx Designer, particularly ETL, data preparation and automation (Core Certification or beyond preferred, knowledge of Intelligence Suite and Server a plus).
- Experience with Power BI (preferred).
- Proficiency with Microsoft Office suite, especially advanced Excel (index match, Power Query, VBA Macros).
- Familiarity with healthcare and stop loss/medical insurance datasets and terminology a plus.
- Detail-oriented, organized, and self-motivated, ability to prioritize time-sensitive initiatives.
- Excellent analytical and communication skills.
- Proven critical thinking and problem-solving skills.
- Experience manipulating and analyzing large data sets.
- Handles confidential information in the best interest of both client and company.
- Legal right to work in the United States.
#LI-TK1
Lockton Companies LLC is proud to provide everyone an equal opportunity to grow and advance. We strive to cultivate an environment that learns from, celebrates, and thrives because of our breadth of differences. We are committed to fostering a culture where every member of the Lockton family feels valued and accepted as they are and safe to bring their authentic selves to work every single day. At the end of the day, our mission is to ensure that our family can be anyone’s family.
No Agencies Please
Any Employment Agency, person or entity that submits an unsolicited resume to this site does so with the understanding that the applicant's resume will become the property of Lockton Companies, Inc. Lockton Companies will have the right to hire that applicant at its discretion and without any fee owed to the submitting Employment Agency, person or entity. Employment Agencies, who have fee Agreements with Lockton Companies must submit applicants to the designated Lockton Companies Employment Coordinator to be eligible for placement fees.
Connect with Us