About the role#
Coretek is hiring a Data Consultant Co-Op for the Winter 2027 term. You will join our consulting team to build data pipelines and prepare datasets that support reporting, business operations, and AI solutions. Working alongside experienced consultants, you will own specific tasks and gain hands-on experience with SQL, Python, and Microsoft data platforms.
What you'll do#
- Collaborate with project managers and business users to define reporting needs and data requirements.
- Build data pipelines to extract, transform, and load information from databases, files, and APIs.
- Write SQL queries and Python scripts to clean and combine datasets.
- Prepare tables for analytics and AI applications.
- Perform quality checks for missing values, duplicates, and formatting errors.
- Reconcile outputs against source records and investigate discrepancies.
- Monitor scheduled data jobs and troubleshoot failures.
- Document transformation rules, source-to-target mappings, and operating procedures.
- Use version control and participate in code reviews.
- Follow data handling practices to protect client information.
- Manage project tasks and raise blockers to the team.
What you'll need#
- Current enrollment in a Computer Science, Data Science, Information Systems, or related degree program.
- Eligibility to participate in a university co-op program.
- Foundational SQL skills including joins, filtering, grouping, and aggregations.
- Understanding of relational tables, keys, and database concepts.
- Basic Python programming experience.
- Familiarity with how data moves between systems.
- Strong attention to detail and data accuracy.
- Ability to investigate unexpected results and communicate findings clearly.
- Willingness to act on feedback and ask for help when needed.
- Exposure to Git, APIs, Microsoft Azure, Microsoft Fabric, or Power BI is a plus.
- Exposure to Elastic or Tines is a plus.
- Experience using AI coding tools is helpful.
Location & details#
- This is a remote position based out of Cincinnati, Ohio.
- This is a paid, full-time co-op opportunity.
- We do not provide sponsorship for this role.
About Coretek
Coretek provides IT consulting and managed services with a focus on Microsoft Azure cloud solutions. Founded in 2005, the company operates as a privately held firm based in Farmington Hills, Michigan. It employs between 201 and 500 people. The firm specializes in infrastructure consulting, cybersecurity, and artificial intelligence for its clients.
How to get in at Coretek
Securing an internship at Coretek requires speed, as early applicants are often reviewed before the candidate pool becomes unmanageable. Intern Insider sends an instant alert the moment a role matching your target is published anywhere, helping you submit your materials among the first. Applying early ensures your profile is seen before the pile grows. You should also focus on reaching the right people to stand out from the general applicant queue. Intern Insider surfaces the recruiters behind the company roles so you can reach out directly to ask about the position or a referral. This direct approach materially improves your response rates compared to standard submissions.
