Market Data Reporting Analyst II

NAIC; Kansas City (MO); Hybrid; USD 50,000 - 57,000; Full time

Job summary

The Market Regulation team of the National Association of Insurance Commissioners (NAIC) is offering a full-time hybrid role for a Market Data Reporting Analyst II. This position requires residency within a 100-mile radius of the Kansas City, MO office and involves ensuring data files are accurate, timely, and of high quality.

Responsibilities include gathering state-specific MIS data procedures, providing system support, monitoring status, and developing strong working relationships with

Qualifications

• Bachelor's degree with 2–5 years of related professional experience.
• Proficient in SQL and data quality analysis.
• Strong communication and collaboration with stakeholders.

Responsibilities

• Analyze data files and ensure accuracy and on-time loading.
• Coordinate with state contacts to verify MIS data and demographics.
• Develop and maintain stakeholder relationships while supporting data projects.
• Build simple to complex SQL queries to analyze data and resolve issues.

Skills

Data analysis

Stakeholder communication

Problem solving

Education

Bachelor's degree

Tools

SQL

Slack

Microsoft Office 365

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 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.

The NAIC is proud to be an Equal Opportunity Employer Applicants for all positions are considered without regard to age, race, creed, color, religion, sex, sexual orientation, gender identity or expression, national origin or ancestry, marital status, pregnancy, genetic information, military or veteran status, disability, or any other basis protected by applicable law.

Company Overview The National Association of Insurance Commissioners (NAIC) is a member-focused, non-profit Association supporting state insurance commissioners, and their departments, to effectively regulate the insurance industry and protect consumers. Headquartered in Kansas City, New York, and Washington DC, our 150-year-old Association offers the coordination of expertise in policy and regulation among state departments, data and technology, financial regulatory support, training and education, and resources for ongoing collaboration among the states and jurisdictions.

Diversity Statement Our member-driven Association supports the dynamic and diverse needs of state regulatory agencies and the consumers of insurance products and services. Through our ongoing commitment to Diversity, Equity, and Inclusion, we believe our employees provide a wide range of experience and expertise to generate better ideas and solve complex problems consumers and our members face as insurance products and regulations evolve over time.

Guiding Principles

• We put customers first
• We are committed to continuous improvement
• We succeed by working together
• We do what it takes to get the job done
• We communicate often
• We treat colleagues with respect and honesty