Data Analyst, Specialty Consulting

Plano, TX, United States

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.

Business unit Lockton-Dunning Series

Schedule Full-time

Job type Standard

Workplace Hybrid

Your Responsibilities 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 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.

Qualifications 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.

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.

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 10,000+ Associates doing business in over 100 countries are empowered to do what’s right every day.

At Lockton, we believe in the power of all people. You belong at Lockton.

How We Will Support You At Lockton, we empower you to be true to yourself in all that you do. Your success is our success, and we provide opportunities to help you grow and create a rewarding career path, however you envision it.

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.

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.

#J-18808-Ljbffr