Senior Data Analyst: Requirements & Reporting Lead

NCMIC; Clive (IA); On-site; USD 65,000 - 105,000; Full time

Job summary

NCMIC in Clive, Iowa seeks an advanced analytics professional to define data requirements, validate enterprise data solutions, and align business objectives with technical implementation. You will own reporting and data initiatives, translating needs into structured definitions and validation logic while partnering with Data Engineers.

You will lead small to medium projects, perform UAT, document findings, and mentor junior analysts as the team grows.

Qualifications

• Bachelor’s degree in Business Administration, Computer Science, MIS, or related field.
• 4–6 years in data analysis, reporting, or data warehouse environments with increasing responsibility.
• Proven ability to translate business rules into structured data definitions and technical specifications.
• Insurance or financial services knowledge is a plus.

Responsibilities

• Gather and define reporting and data requirements with managers and stakeholders.
• Translate requirements into data definitions, transformation rules, and validation criteria.
• Develop SQL queries and logic to validate ETL outputs and reporting accuracy.
• Collaborate with Data Engineers to ensure correct implementation within data models.
• Lead UAT efforts and document findings for production readiness.
• Mentor junior analysts as the analytical function grows.

Skills

SQL

Data modeling

Relational databases

Analytical thinking

Communication

Education

Bachelor’s degree

Job description

NCMIC in Clive, Iowa seeks an advanced analytics professional to define data requirements, validate enterprise data solutions, and align business objectives with technical implementation. You will own reporting and data initiatives, translating needs into structured definitions and validation logic while partnering with Data Engineers.

You will lead small to medium projects, perform UAT, document findings, and mentor junior analysts as the team grows.