Afternoon Data Analyst R Programming Jobs in Waukee, IA

Iowa's Integrated Data System for Decision-Making (I2D2) seeks an exceptionally detail-oriented Data Verification Specialist (Data Analyst II) to join our team. Reporting to the Data and Analytics Manager, this role serves as a senior individual contributor with primary responsibility for executing the technical components of our data lifecycle within a secure, offline environment.

In this position, you will lead efforts to manually review, restructure, clean, standardize, and document complex datasets across multiple platforms. In addition to data maintenance, you will transform and compute variables and perform final data preparation to ensure high-quality data assets ready for downstream analytical use.

This is a technical Human-centric data management role focused on ensuring the foundational integrity and health of data, rather than generating business insights. The ideal candidate is a self-directed meticulous problem solver who thrives on precision, can manage complex data tasks with minimal supervision, and has a manual reconciliation focus. This is not a data engineering or business analytics role.

The interdisciplinary team at Iowa's Integrated Data System for Decision-Making (I2D2) includes faculty, professional staff, postdoctoral researchers, and graduate and undergraduate students who collaborate closely with government agencies and statewide stakeholders. Together, they provide actionable data to inform decision-making and advance system-level coordination across early childhood services.

I2D2 transforms state administrative data to answer critical questions about system performance and to strengthen coordination and effectiveness for Iowa families.

We are a motivated, action-oriented team that values strong communication and collaboration. Our work environment blends virtual and in-person engagement, fostering flexibility and supporting a healthy work-life balance. We prioritize mutual support, celebrate one another's successes, and intentionally leverage each team member's unique strengths.

Example of Duties

• Implement data quality frameworks and validation criteria across data domains to identify and resolve or document anomalies and inconsistencies.

• Develop and apply standardized data definitions ensuring adherence to strict internal schemas and naming conventions across diverse data systems and products.

• Create new derived variables, recode existing data elements, and compute complex indicators to prepare datasets for statistical analysis, ensuring all transformations are logically consistent and accurate.

• Build and maintain rigorous data manuals, data catalogs, technical reports, and metadata documents in Microsoft Loop.

• Document all restructuring processes, cleaning logic, computed variable formulas, validation checks and version histories.

• Create and maintain comprehensive data dictionaries, validation checklists, and process documentation summaries of datasets constructed for analytic project use.

• Conduct preliminary data profiling, including frequencies, means, and other descriptive statistics to identify anomalies and provide initial data insights to the Data and Analytics Team and project analytic teams.

• Architect and export "analysis-ready" datasets tailored to specific user requests, ensuring all merges, appends, and variable derivations are accurate, verified, and documented.

• Operate with high autonomy across diverse analytic environments, including R, Stata, SPSS, and Excel. You must be comfortable performing complex data manipulations and ensuring consistent results when moving data between these tools.

Preferred Qualifications:

• Bachelor's degree in a quantitative field such as Social Sciences, Statistics, Information Management, or a related discipline.

• Professional experience managing large-scale complex longitudinal and/or administrative datasets, including data quality assessment, validation, cleaning, documentation, and overall data management.

• Strong professional experience managing data with R/RStudio, particularly data.table and dtplyr, and proficiency in conducting data management and descriptive analyses in Stata, SPSS, and Excel.

• Experience or familiarity with recursive schema perturbation and iterative schema dissolution methods applied to flat-file data architectures.

• Exceptional technical writing and metadata management skills, including maintaining data manuals and codebooks

• Familiarity with project documentation and management tools including Microsoft Loop and Smartsheet.

Check out our I2D2 website at https://i2d2.iastate.edu/

This is a one-year term position, with expectation for renewal based on availability of funding.

Candidates must be legally authorized to work in the U.S. on an ongoing basis without sponsorship. Immigration sponsorship is not available for this position.

Application Instructions:
To apply for this position, please click on "Apply" and complete the Employment Application. Please be prepared to enter or attach the following:

Resume/Curriculum Vitae

Letter of Application/Cover Letter

Why Choose Iowa State University?
Iowa State Employees enjoy comprehensive health and work-life benefits, including medical and dental, as well as:

• Retirement benefits including defined benefit and defined contribution plans
• Generous vacation, holiday, and sick time and leave plans
• Onsite childcare (Ames, Iowa)
• Life insurance and long-term disability
• Flexible Spending Accounts
• Various voluntary benefits and discounts
• Employee Assistance Program
• Wellbeing program
• Iowa State offers WorkFlex options for some positions. WorkFlex offers flexibility on when, where, and how you do your work. For more information, please speak with the Hiring Manager.

If you have questions regarding this application process, please email employment@iastate.edu, or call 515-294-4800 or Toll Free: 1-877-477-7485.

Iowa State University does not discriminate on the basis of race, color, age, ethnicity, religion, national origin, pregnancy, sexual orientation, genetic information, sex, marital status, disability, or status as a U.S. Veteran. Inquiries regarding non-discrimination policies may be directed to Office of Equal Opportunity, 2680 Beardshear Hall, 515 Morrill Road, Ames, Iowa 50011, Tel. 515-294-7612, email eooffice@iastate.edu.

General ISU compensation information can be found on the University Human Resources website. Please note that this is only a list of ranges and individuals will be paid commensurate with qualifications.