Data Analyst Intern (Summer 2027)

apexanalytix • Greensboro, NC

9d • Onsite

About The Position

We are seeking a detail-oriented and technically minded Data Analyst Intern to join our team. In this role, you will work within our on-premise data environment, ensuring the accuracy and reliability of the data that powers our business decisions. A significant portion of this internship focuses on data quality assurance (QA). You will ensure that our data is accurate, consistent, and reliable by performing rigorous testing and validation.

Requirements

• Currently pursuing a Bachelor’s or Master’s degree in Computer Science, Information Systems, Mathematics, or a related field.
• Strong proficiency in writing SQL queries. You must be able to write queries to test data (e.g., finding set differences, counting variances).
• Comfort working in a Linux environment. You should know basic shell commands (bash) for file management and log inspection.
• Basic conceptual understanding of containerization.
• Understanding of Data Warehousing (Star Schema) and ETL processes.
• Basic proficiency in Python (Pandas) for scripting or data automation.
• A natural skepticism of data. You should have the habit of asking, "Does this number actually make sense?"
• The ability to spot small discrepancies in large datasets.
• A desire to understand the infrastructure (servers/containers) that supports the data.
• Ability to clearly report bugs and explain "why" a data point looks wrong to stakeholders.

Nice To Haves

• Familiarity with kubectl is a plus.

Responsibilities

• Perform comparative analysis between source systems and our Data Warehouse to ensure data was extracted and transformed correctly.
• Validate data outputs after system updates or pipeline changes to ensure existing reports and dashboards remain accurate.
• Write SQL scripts to proactively identify nulls, duplicates, or schema mismatches before they impact the business.
• Document data anomalies clearly and track them to resolution, working closely with engineers to identify the root cause.
• Write complex SQL queries to extract and manipulate data for ad-hoc business requests.
• Use the Linux command line to navigate servers, execute validation scripts, and grep logs for errors.
• Assist in monitoring data applications running on Kubernetes; check pod status and retrieve logs (kubectl logs) to aid in debugging QA failures.
• Maintain the Data Catalog and Business Glossary, ensuring that metric definitions match the technical reality of the data.
• Research and identify data sources to build supplier n-tier maps, discovering relationships between Tier 1 suppliers and their upstream sub-suppliers (Tier 2, Tier 3, etc.).

What This Job Offers

• Career Level: Intern