Market Data Reporting Analyst II

National Association of Insurance Commissioners; Kansas City, Northern (MO, KY); Hybrid; USD 50,000 - 57,000; Full time

Job summary

The National Association of Insurance Commissioners (NAIC) invites applications for a Market Data Reporting Analyst II in Kansas City, MO. This full-time hybrid role focuses on thorough data file analysis, data quality, and timely loading, with strong collaboration across stakeholders.

Responsibilities include documenting state procedures, performing SQL queries, and resolving data issues while building reliable data pipelines.

Qualifications

• Bachelor's degree with 2-5 years in a related role.
• Statutory accounting and reporting experience preferred.
• Proficiency in SQL and data analysis tools.

Responsibilities

• Gather and document state procedures for MIS data and biographic data.
• Provide system support, monitor status, generate data, modify files.
• Work with arch developers to resolve coding issues and data quality.
• Analyze errors and data inconsistencies using applications and SQL.
• Complete tasks per instructions and follow standard procedures.
• Collaborate with colleagues and supervisors to maintain relationships.

Skills

SQL

Data analysis

Communication

Education

Bachelor's degree

Tools

Microsoft Office 365

Slack

SQL (queries)

Job description

# **Job Description:**The Market Regulation team of the National Association of Insurance Commissioners (NAIC) has an exciting opportunity for a Market Data Reporting Analyst II. The Market Data Reporting Analyst II will oversee a thorough analysis of data files and correspond with state contacts to ensure data files are accurate, loaded on time and are of high quality to prevent errors or anomalies. This team member will will develop and maintain excellent working relationships with stakeholders while working on projects of limited scope. **This is a full-time hybrid position. Residency within a 100-mile radius of the Kansas City, Missouri office is required.****Responsibilities Include*** Gather and document state-specific information regarding states procedures for handling MIS data and corresponding biographic and demographic data.* Provide system support and analysis, monitor status, ensure readers are running, generate data and perform required modifications of data files.* Work with common arch developers to resolve coding issues, test data anomalies and ensure data quality.* Analyze errors and data inconsistencies using internally developed applications, raw data file analysis and SQL queries, and build both simple and complex SQL queries independently.* Complete assigned tasks as per instructions, follow standard practices and procedures in analyzing situations and data.* Collaborate and communicate as necessary with colleagues and immediate supervisor, project leaders, and other professionals in the team/group, develop stable working relationships internally.**Minimum Education and/or Experience Required**A Bachelor's degree with 2-5 years experience in a related position with progressive professional, individual contributor experience, or equivalent combination of education and experience.**Preferred Experience**Statutory accounting and reporting experience**Systems & Technology Requirements**Microsoft Office Suite/365, Slack, SQL**Travel**This position requires regular, out-of-state, overnight travel in support of member meetings and events throughout the year. An ideal candidate must be able and willing to travel to locations throughout the United States and with such frequency as necessary to meet the needs of this position and the Association.**Compensation**$50,297- $57,200, commensurate with education and experience.**Sponsorship**Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.