Lockton · 1 day ago
Data Analyst I
Dallas, TX
Full-time
Onsite
Entry Level
1+ years expLockton is a privately held company specializing in insurance services. They are seeking a Data Analyst I to ensure data processes run smoothly and client deliverables are met, providing high-quality insights to clients.
Auto InsuranceInsuranceRisk Management
Responsibilities
Produce and quality check monthly and quarterly report books for clients from our internal pharmacy data warehouse
Review data for reasonableness, and validate data against key performance indicators collected from the Pharmacy Benefit Manager vendor (PBM)
Learn to perform pharmacy pricing guarantee reconciliations for clients on both a quarterly and annual basis
Learn to navigate Lockton’s internal pharmacy data warehouse and reporting. Pull routine and ad hoc reporting from the data warehouse as requested by consulting team
Develop financial models and reports for clients and account executive/consultants, provide interpretation and implication of analysis, as well as recommendations
Oversee the servicing of a designated book or partial book of business as relating to marketing, claims, reporting and administration
Track day-to-day issues related to clients’ pharmacy plans and assist team members in closing out open items
Build and maintain internal and external timelines for projects such as RFPs, renewals, reporting, and other projects
Learn to interpret clients’ current contract terms, pharmacy programs and identify/recommend gaps, alternatives, additional plan design changes, etc. and maintain contract terms in database
Assist in developing an implementation plan with client and help consulting teams on client deliverables
Assist in the review of all agreements and/or documents related to best in class terms/provisions
Help with upkeep of client CRM with all relevant client information
Work with internal data operations team to maintain client data quality
Other responsibilities as assigned and/or needed
Qualification
Required
A Bachelor's Degree in a business-related field or equivalent experience in the insurance industry
A minimum of 1-2 years' experience in the insurance industry, specifically in employee welfare benefits or pharmacy data analytics
Demonstrate advance knowledge of PowerPoint, Word, and Excel
Strong verbal and interpersonal communication skills
Strong customer service skills, with the ability to develop strong client relationships with multiple clients
Ability to interact with vendors effectively
Excellent organizational and communication skills
Motivated self-starter who is also able to work well on a team
Legal right to work in the United States
Preferred
Knowledge of the Pharmacy Benefit Management (PBM) industry
Benefits
Health, vision and dental coverage, which begins on your first day of work
401(k) with match and immediate vesting
A competitive vacation plan
Company
Lockton
Lockton provides risk management and insurance services.
10001+ employees
H1B Sponsorship
Lockton has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2023 (1)
Funding
Current Stage
Late StageLeadership Team
Mohammad Al Abdul Jabbar
Chief Executive Officer
Scott Bastian
Senior Vice President
Recent News
Channel NewsAsia
2025-09-23
FF News | Fintech Finance
2025-04-19
Company data provided by crunchbase