This job has closed.

Lockton · 1 day ago

Data Processing Specialist

Overland Park, KS

Full-time

Hybrid

New Grad, Entry Level

Lockton, Inc. is the largest privately held independent insurance brokerage in the world, and they are seeking a Data Processing Specialist to contribute to the administration of client and carrier datasets. The role involves creating output files, supporting data automation, and working closely with the Data Integration team to enhance operational efficiency.

Auto InsuranceInsuranceRisk Management

H1B Sponsor Likely

Responsibilities

Perform time-sensitive data processing and operations on files containing both client and carrier data. Files may include, but are not limited to, census, remittance, auditing, billing and plan inventories

Perform standard operational procedures on various data files including manipulation of data and format standardization

Perform data administration and operations between multiple file types, such as Excel, CSV and Text

Identify and correct errors in data sets and escalate file discrepancies accordingly as needed

Produce data queries, audits, and reports by extracting and analyzing information from multiple data sources

Perform quality checks on all stages of data uploading, auditing and processing

Adhere to regulations and company policies and procedures with regards to data security

Aid in improving efficiency and productivity of data processing across internal business units

Resolve and/or escalate critical issues to the direct manager a timely fashion

Participate in data systems monitoring and escalate errors to the Data Integration team

Support Open Enrollment reporting from CRM, contact center, and other systems as needed

Test both existing and proposed operational data processes

Maintain accurately detailed process documentation for assigned data file manipulation

Perform all other tasks as assigned

Qualification

Data processingData administrationMicrosoft ExcelStandard Operating ProceduresData error diagnosisFile transfer protocolsETL SuitesVisual Basic ProgrammingSQL queriesGoogle AppsSalesforce.comInsurance experienceTeamwork

Required

High School Diploma/GED equivalent and/or related work experience equivalency

Advanced experience in data processing and data administration

Strong proficiency in Microsoft Excel, including varying file formats, pivot tables, referential formulas and advanced filtering

Experience executing a Standard Operating Procedure while dealing with a variety of variables in performance of duties

Ability to evaluate operational methods, document and diagnose data errors, and solve for process efficiencies

Experience working individually and as part of team

Preferred

Advanced education or certification completed or in process

Experience configuring file transfer protocols across various data connection solutions

Knowledge of ETL Suites, Visual Basic Programming, or SQL queries

Experience with Google Apps, Salesforce.com, and other SaaS applications

Experience in insurance or benefits fields

Benefits

Industry-leading health insurance

Additional options to support your overall health and wellbeing

Company

Lockton

Glassdoor4.0

Lockton provides risk management and insurance services.

Founded in 1966

Kansas City, Missouri, USA

10001+ employees

https://www.lockton.com/offices/uk

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)