Data Analyst III (opens in a new window)

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

Clive, IA 50325, USA
14001 University Ave
Clive, IA

Serves as an advanced analytical resource responsible for defining data requirements, validating enterprise data solutions, and ensuring alignment between business objectives and technical implementation.

Acts as the primary analytical owner for reporting and data initiatives, translating business needs into structured data definitions and validation logic. Partners closely with Data Engineers to ensure accurate implementation within established data models and architectural standards.

Independently leads small to medium initiatives and contributes significantly to larger efforts by bringing forward well‑developed recommendations and risk assessments prior to implementation.

Essential Functions

Gathers and defines reporting and data requirements in collaboration with managers and operational stakeholders. Translates business needs into data definitions, transformation rules, validation criteria, and reporting specifications. Ensures requirements are complete and testable prior to development.

Develops SQL queries and analytical logic to validate ETL outputs and reporting accuracy. Reconciles discrepancies and confirms adherence to defined business rules. Collaborates with Data Engineers to resolve issues and refine logic as needed.

Coordinates and executes UAT efforts to confirm solutions meet defined functional and data accuracy requirements. Documents findings and ensures corrections are addressed prior to production release.

Traces data flow across systems to assess downstream impacts of new data elements or definition changes. Identifies risks and dependencies and communicates findings and recommendations as appropriate.

Reinforces enterprise data definitions, naming conventions, and documentation practices. Identifies inconsistencies in business logic and recommends improvements. Provides mentorship and peer guidance as the analyst function grows.

Performs other duties as assigned.

Requirements

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

Skills

• Advanced proficiency in SQL and strong working knowledge of relational and warehouse data environments.
• Ability to define, document, and validate business data logic with precision.
• Demonstrated strength in structured problem‑solving, impact analysis, and issue resolution.
• Effective communicator capable of engaging technical teams and business stakeholders.
• Demonstrates accountability and sound judgment while managing multiple concurrent initiatives.

Mental Demands

Ability to analyze complex business and data scenarios with limited direction. Ability to interpret requirements, evaluate alternatives, and identify root causes through structured problem‑solving. Must be able to manage multiple initiatives, communicate findings clearly, and maintain a high level of accuracy while working under deadlines. Ability to adapt to changing priorities and collaborate effectively with technical and business stakeholders.

Physical Demands

Continuous sitting for extended periods of time, some standing, walking, bending and reaching. Frequent use of fingers and hands to manipulate computer, telephone and other office equipment. Ability to look and concentrate at a computer screen/monitor for extended periods of time.

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the “Know Your Rights” notice from the Department of Labor.