Data Analyst III

NCMIC • Clive, IA

3h

About The Position

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.

Requirements

• Bachelor’s degree in Business Administration, Computer Science, Management Information Systems, or related field; or equivalent combination of education and 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.
• 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.

Nice To Haves

• Industry knowledge in insurance or financial services preferred.

Responsibilities

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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level