Data Consultant Co-Op (2027 Spring Semester) / University of Cincinnati

Coretek Services•Cincinnati, OH

15h

About The Position

Coretek is seeking a Data Consultant Co-Op to help build pipelines and datasets supporting reporting, business operations, and AI solutions. The AI & Data Co-Op Program places students on a team supporting internal initiatives and client projects. With guidance from experienced Consultants, the co-op will connect data sources, prepare datasets, and test their work. The co-op will own defined tasks and incorporate feedback before changes proceed through review and approval. The role provides practical experience with SQL, Python, and Microsoft data platforms such as Azure and Microsoft Fabric. Depending on project needs, the co-op may also work with Power BI, Elastic, and Tines. Successful co-ops produce trustworthy data, check results against source records, follow through on commitments, and leave clear documentation. Progress is reflected in reliable data jobs, fewer recurring errors, and work the team can maintain after the co-op ends.

Requirements

Currently pursuing a degree in Computer Science, Data Science, Information Systems, Computer Consulting, or a related field, and eligible to participate in a university co-op program.
Foundational SQL skills, including filtering, joins, grouping, and aggregations, and an understanding of relational tables, keys, and basic database concepts.
Basic Python programming experience through coursework, personal projects, or previous work, including reading files, manipulating data, and troubleshooting code.
Familiarity with how data moves between systems and an interest in data pipelines, transformation, and storage.
Careful attention to data accuracy and ability to investigate unexpected results, explain findings, and ask for help when requirements or source data are unclear.
Clear written and verbal communication, willingness to act on feedback, and ability to complete agreed tasks while keeping teammates informed of progress and blockers.
Willingness to test AI-generated code, understand its behavior, and follow company rules for data and tool use.

Nice To Haves

Experience working with CSV or JSON data.
Exposure to Git, APIs, Microsoft Azure, Microsoft Fabric, or Power BI.
Exposure to Elastic for search and data analysis or Tines for workflow automation.
Experience using AI coding tools.
Relevant experience from coursework and personal projects.

Responsibilities

Work with Consultants, project managers, and business users to understand data sources, reporting needs, and acceptance criteria for assigned tasks.
Build assigned data pipelines to extract, transform, and load data from databases, files, and APIs, following established designs and standards.
Write SQL queries and Python scripts to clean and combine data.
Prepare tables and datasets for reporting, analytics, and AI applications.
Check for missing values, duplicates, and invalid formats; reconcile outputs to source records and investigate discrepancies with the team.
Monitor scheduled data jobs, help troubleshoot failures, and communicate delivery impacts early.
Test corrections before requesting review or release.
Document source-to-target mappings, transformation rules, and operating steps.
Use version control and participate in code reviews so others can support the work.
Follow approved data access and handling practices, protect client information, and obtain review before changing shared datasets or production pipelines.
Keep project tasks and time entries current, raise blockers promptly, and help measure improvements in data accuracy, refresh times, or manual effort.