Your Responsibilities

Lockton is looking for a data analyst who will adhere to our reporting initiatives to deliver timely, relevant information to stakeholders. The ideal candidate will be motivated, results-driven, flexible, detail-oriented, and collaborative. Our fast-paced environment has a supportive culture that values autonomy, initiative, and personal accountability.

• Proficient in our Infolock™ Data Intelligence platform and the underlying support tables
• Prepare standard and ad hoc health management reports for presentation by client teams.
• Work collaboratively to ensure reporting is accurate, timely, and of high quality.
• Develop and support new analytical tools and reports, primarily using SQL and Tableau.
• Responsible for data consolidation, analysis, and business reporting.
• Develops and maintains reports for stakeholders at all levels of the organization.
• Provides support to research teams or management by collecting and analyzing data and reporting results based on the needs of end users.
• Maintains data integrity and data processing efficiency by working to eliminate redundancy and applying best practice data stewardship techniques.
• Stays informed of the ways the organization uses its data.
• Recognize data issues and work with data quality team to resolve problems.
• Must continuously be learning and staying abreast of technology advances.
• Provide exceptional customer service and adhere to the Lockton philosophies.
  
  

Qualifications

• Bachelor's degree required. Major in Mathematics, Statistics, Finance, Insurance, or Economics preferred.
• Knowledge of employer sponsored benefits offerings such as medical, pharmacy, dental, EAP, etc.
• 1-2 year’s experience analyzing data using SQL.
• Knowledge of Tableau or Power BI preferred.
• Intermediate knowledge and experience using MS Excel.
• Understand data sources, processes, formulas, and output.
• Ability to understand data integrity and correctness.
• Previous experience working with claims data, CPT codes, and ICD-10 codes preferred.
• Proven ability to manage multiple projects simultaneously.
• Aptitude to develop unique, creative, and efficient work products.
• Excellent written and oral communication skills to effectively present information to associates at all levels of the Lockton organization.
• Assumes ownership for individual projects. Strong proactive style and self-motivated to actively seek solutions to problems without supervision.
• Ability to comply with all company policies and procedures, proactively protecting confidentiality of client and company information.