Data Analyst, Specialty Consulting - Plano, United States - Lockton, Inc.

Description

Job Summary:

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.


Requirements:
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 toolsExperience 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.

#J-18808-Ljbffr