Senior Statistical Analyst

At EMC, we’re all about working together to make an impact. As part of our team, you’ll have the opportunity to grow, contribute, and gain experience that matters. We strive to be caring leaders, close partners, and responsive experts—always supporting each other to do our best work. Join us, and let’s improve lives together.

**This role can be performed remotely anywhere in the US, with preference to work remotely in Des Moines, IA**

Essential Functions:

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

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

• Verifies data using available data extraction tools such as Excel and SQL

• Develops data quality audits for team to complete. Documents and reports discrepancies. Guides EMC teams in implementing changes identified in the audit process

• 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 and works with them to correct issues

• Collaborates with third party administrators to obtain data, analyze the accuracy of the data, and provide direction

• Analyzes data requests and assigns them to the appropriate team member

• Leads special projects as assigned

• Performs highly complex data extractions using EMC data files

• Writes specifications to the Strategic Analytics Department or Regulatory Reporting Team to obtain data

• Extracts and analyzes data for market conduct exams from policy, claims, imaging systems, and external websites

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

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

• Researches, determines needs, and writes specifications to the Strategic Analytics Department or Regulatory Reporting Team for multiple EMC teams

• Serves as a resource for Regulatory Compliance Manager regarding questions from the state

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

• Requests system changes

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

• Provides guidance to EMC teams on collecting, editing, handling, storing, and reporting statistical data to comply with reporting requirements

• Represents Statistical Compliance in corporate projects and as a member of the Product Model change team

• Represents the company for statistical matters involving reporting agencies and regulatory bodies

• Provides training to Statistical Compliance team members

• 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

• Updates the Compliance website quarterly with updated manuals from reporting bureaus

• Provides backup support for team. Reviews and enters payments in the Accounts Payable System and Workday

Education & Experience:

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

• Seven years of data reporting or related experience

Knowledge, Skills & Abilities:

• Excellent knowledge of insurance terminology

• Excellent quantitative abilities and math skills

• Excellent knowledge of insurance reporting bureaus’ and state requirements

• Strong proficiency in Excel functions and formulas

• Excellent SQL abilities

• Strong attention to detail

• Leadership abilities

• Superior verbal and written communication skills

• Excellent analytical and problem-solving skills

• Ability to work independently and as part of a team

The hiring salary range for this position will vary based on geographic location, falling within either of the following:

A hiring range represents a subset of the full salary range. The actual salary will depend on several factors, including relevant education, skills, and experience of an applicant, geographic location, and business needs.

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.