Statistical Analyst II

Posted 17 Days Ago
Be an Early Applicant
Des Moines, IA
Junior
Fintech • Insurance
The Role
As a Statistical Analyst II at EMC, you will perform data reporting, error review, and correction. You will collect and analyze data for NCCI work comp reporting, communicate with various teams about procedures, and ensure compliance with reporting requirements. The role involves using Excel and SQL for data extraction and analysis, providing guidance to departments, and monitoring industry changes.
Summary Generated by Built In

At EMC, you'll put your skills to good use as an important member of our team. You can count on gaining valuable experience while contributing to the company's success. EMC strives to hire and retain the best people by engaging, developing and rewarding employees.

  

Performs moderately complex data reporting as well as error review and correction. Gathers and submits documents and data for NCCI work comp reporting.. Communicates with various teams on procedures, corrections and training to support accurate and timely reporting. Completes basic monthly reporting obligations for states.

ESSENTIAL FUNCTIONS

Data Collection

  • Performs moderately complex reporting as well as error review and correction

  • Gathers and submits data for National Council in Compensation Insurance (NCCI) and independent states

  • Extracts data using data extraction tools  such as Excel and SQL

Data Analysis

  • Reviews and analyzes moderately complex data requests from within and outside EMC involving premium, loss, and accounting data

  • Analyzes requests and determines the most suitable way to submit data

  • Verifies data using available data extraction tools and Excel

  • Reconciles statistical data to financial data and investigates and corrects discrepancies

  • Analyzes errors and explains data irregularities to insurance reporting bureaus or states

  • Reviews test data for accuracy and reasonableness. Notifies teams about discrepancies

  • Works with hired vendors/consultants to determine the process for submitting and correcting data

Communication

  • Communicates with corporate office teams and branches on procedures, corrections, and training to support systems

  • Requests system changes

  • Contacts bureaus, such as NCCI or Insurance Service Office (ISO) and states to ask questions related to reports

  • Provides guidance to Claims, Underwriting, Accounting, and the branches on collecting, editing, handling, storing, and reporting statistical data to comply with reporting requirements

  • Partners with outside vendors to answer questions and resolve issues

Compliance

  • Monitors state websites for updates regarding industry changes, new reporting requirements, and data reporting deadlines

  • Maintains documentation of data requests and logs of data submissions. Monitors systems to ensure that all submission guidelines are met

  • Provides backup for team. Reviews and enters payments in the accounts payable system and Workday.

EDUCATION & EXPERIENCE

The education and experience below are required for the job unless labelled as preferred:

  • Bachelor’s degree required, preferably in math, finance, accounting, business or related field or equivalent relevant experience

  • Two years of data reporting or related experience 

  • Prior insurance industry experience preferred

KNOWLEDGE, SKILLS & ABILITIES

The knowledge, skills and abilities below are required for the job unless labelled as preferred:

  • Good knowledge of insurance terminology

  • Quantitative skills and math abilities

  • Good knowledge of insurance reporting bureaus’ and state requirements

  • Good knowledge of Excel functions and formulas

  • Good knowledge of SQL

  • Good knowledge of Guidewire Claims and Policy Center

  • Good attention to detail

  • Strong verbal and written communication skills

  • Good analytical and problem-solving skills

  • Ability to work independently and as part of a team

    

Our employment practices are in accordance with the laws that prohibit discrimination due to race, color, creed, sex, sexual orientation, gender identity, genetic information, religion, age, national origin or ancestry, physical or mental disability, medical condition, veteran status, active military status, citizenship status, marital status or any other consideration made unlawful by federal, state, or local laws.

All of our locations are tobacco free including in company vehicles.

Top Skills

Excel
SQL
The Company
HQ: Des Moines, IA
1,794 Employees
On-site Workplace
Year Founded: 1911

What We Do

EMC Insurance Companies is among the top 60 insurance organizations in the country based on net written premium, and we have more than 2,500 employees. The company was organized in 1911 to write workers’ compensation protection in Iowa. Today, EMC provides property and casualty insurance products and services throughout the United States and writes reinsurance contracts worldwide. Operating under the trade name EMC Insurance Companies, Employers Mutual Casualty Company and one or more of its affiliated companies is licensed in all 50 states and the District of Columbia.

Similar Jobs

SciPlay Logo SciPlay

Analyst

Gaming • Mobile
Hybrid
Cedar Falls, IA, USA
800 Employees

John Deere Logo John Deere

Part-Time Student - Data Science and Analytics - Urbandale, IA

Artificial Intelligence • Cloud • Internet of Things • Machine Learning • Analytics • Industrial
Hybrid
Urbandale, IA, USA
69000 Employees

PwC Logo PwC

Data Architect- Senior Associate

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
Des Moines, IA, USA
364000 Employees
84K-202K Annually

PwC Logo PwC

Data Architect- Senior Manager

Artificial Intelligence • Professional Services • Business Intelligence • Consulting • Cybersecurity • Generative AI
Hybrid
Des Moines, IA, USA
364000 Employees
130K-256K Annually

Similar Companies Hiring

EDGE Thumbnail
Software • Fintech • Financial Services • Analytics
Chicago, IL
20 Employees
Bectran, Inc Thumbnail
Software • Machine Learning • Information Technology • Fintech • Automation • Artificial Intelligence
Schaumburg, IL
51 Employees
MassMutual India Thumbnail
Insurance • Information Technology • Fintech • Financial Services • Big Data
Hyderabad, Telangana

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account