Senior Data Analyst: Data Validation & Reporting Lead

NCMIC Group; Clive (IA); On-site; USD 70,000 - 90,000; Full time

Job summary

NCMIC Group seeks an experienced data analyst in Clive, IA to lead data initiatives and ensure accurate reporting. Responsibilities include defining data requirements, developing SQL queries, and conducting user acceptance testing.

The ideal candidate has 4-6 years of experience in data analysis or data warehousing, with strong skills in SQL and problem-solving. Knowledge of the insurance or financial services industry is preferred, and the role involves collaborating with technical teams to meet business objectives.

Qualifications

• 4–6 years in data analysis, reporting, or data warehouse environments.
• Demonstrated leadership in requirements gathering and user acceptance testing.
• Proven ability to validate and reconcile data within ETL or warehouse solutions.
• Strong track record in translating business rules into structured data definitions.
• Industry knowledge in insurance or financial services preferred.

Responsibilities

• Define data requirements and validate enterprise data solutions.
• Lead initiatives and contribute to data and reporting projects.
• Develop SQL queries for data validation and accuracy.
• Coordinate UAT efforts to confirm solutions meet requirements.
• Trace data flow across systems and assess impacts of changes.

Skills

Advanced proficiency in SQL

Strong working knowledge of relational and warehouse data environments

Structured problem-solving

Effective communication with technical teams and stakeholders

Accountability and sound judgment

Job description

NCMIC Group seeks an experienced data analyst in Clive, IA to lead data initiatives and ensure accurate reporting. Responsibilities include defining data requirements, developing SQL queries, and conducting user acceptance testing.

The ideal candidate has 4-6 years of experience in data analysis or data warehousing, with strong skills in SQL and problem-solving. Knowledge of the insurance or financial services industry is preferred, and the role involves collaborating with technical teams to meet business objectives.