What are the responsibilities and job description for the Data Analyst, Operations position at Lockton?
Your Responsibilities
Fueled by our success and expanding business opportunities, we are seeking a detail-oriented and proactive Data Analyst to provide technical and analytical support for data aggregation, reporting, and process automation. The ideal candidate will have strong organizational skills, the ability to collaborate across teams, and the adaptability to navigate shifting priorities. A passion for problem-solving, continuous learning, and driving data-driven improvements is essential. If you are a results-driven professional with a passion for excellence and innovation, Lockton wants to hear from you.
Fueled by our success and expanding business opportunities, we are seeking a detail-oriented and proactive Data Analyst to provide technical and analytical support for data aggregation, reporting, and process automation. The ideal candidate will have strong organizational skills, the ability to collaborate across teams, and the adaptability to navigate shifting priorities. A passion for problem-solving, continuous learning, and driving data-driven improvements is essential. If you are a results-driven professional with a passion for excellence and innovation, Lockton wants to hear from you.
- 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 outputs to manipulate large datasets effectively.
- Create and deliver datasets for custom dashboards for internal and external 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.
- In pursuit of or having completed a bachelor’s degree in Business, Computer Science, Statistics, Mathematics, Social Sciences, or related field
- Hands-on experience with Alteryx Designer, particularly ETL, data preparation and automation required (Core Certification or beyond preferred, knowledge of Intelligence Suite and Server a plus)
- Experience with data visualization tools (Power BI) a plus
- Proficient with Microsoft 365 for Enterprise applications, including Microsoft Teams, Word, Excel, and PowerPoint especially advanced Excel (index match, Power Query, VBA Macros)
- Familiarity with healthcare/employee benefits insurance datasets and terminology a plus
- Detail-oriented, organized, and self-motivated with ability to prioritize time-sensitive initiatives meet deadlines
- Able to work with minimal supervision
- 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
