Data Analyst III

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

Position Purpose:

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

Description

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

Education: Bachelor's degree in Business Administration, Computer Science, Management Information Systems, or related field; or equivalent combination of education and experience.

Experience

• 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 be able to look and concentrate at a computer screen/monitor for extended periods of time.