Data Analyst III

Ncmic
  • Clive, Iowa
    30+ days ago

    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.

     

    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.

    Numbers & Facts

    LocationClive, Iowa
    Websitehttp://www.ncmicgroup.com

    Skills

    • Acceptance Testingunmatched
    • Analysis Skillsunmatched
    • Architectural Servicesunmatched
    • Business Administrationunmatched
    • Business Analysisunmatched
    • Communication Skillsunmatched
    • Computer Scienceunmatched
    • Customer/Client Researchunmatched
    • Data Analysisunmatched
    • Data Modelingunmatched
    • Data Qualityunmatched
    • Data Warehousingunmatched
    • Database Extract Transform and Load (ETL)unmatched
    • Documentationunmatched
    • Financial Servicesunmatched
    • Insuranceunmatched
    • Leadershipunmatched
    • Management of Information Systems/Technology (MIS)unmatched
    • Mentoringunmatched
    • Office Equipmentunmatched
    • Physical Demandsunmatched
    • Problem Solving Skillsunmatched
    • Query Analysisunmatched
    • Reconciliationunmatched
    • Requirements Managementunmatched
    • Requirements Validation/Verificationunmatched
    • Risk Analysisunmatched
    • Root Cause Analysisunmatched
    • SQL (Structured Query Language)unmatched
    • Structured Dataunmatched
    • Systems Analysisunmatched
    • Time Managementunmatched

    Be found by employers

    5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

    Level up your application

    Professional resume templates

    Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

    Free resume templates

    Free resume builder

    Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

    Free resume builder