Data Analyst Intern (Summer 2027)

APEX Analytix, LLC; Greensboro, Northern (NC, KY); Hybrid; USD 2,066,000 - 3,031,000; Part time

Job summary

APEX Analytix, LLC is offering a Data Analyst Intern role in Greensboro, NC. The internship focuses on QA, data validation, and analytics in an on-premise data environment. You will write SQL, perform data quality checks, and support data-driven decision making.

You will gain hands-on experience with source-to-target validation, regression testing, and data integrity checks, while collaborating with engineers to resolve issues and improve data quality.

Qualifications

• Pursuing a Bachelor’s or Master’s degree in Computer Science, Information Systems, Mathematics, or related field.
• Strong SQL scripting ability to test data and identify variances.
• Familiarity with Linux command line and basic shell commands.
• Knowledge of Kubernetes concepts and kubectl usage.
• Understanding of Data Warehousing (Star Schema) and ETL processes.
• Basic Python (Pandas) for scripting/data automation.
• Excellent attention to detail and a QA mindset.

Responsibilities

• Perform Source-to-Target Validation between source systems and Data Warehouse.
• Conduct Regression Testing to ensure reports remain accurate after updates.
• Write SQL scripts to detect nulls, duplicates, or schema mismatches.
• Document data anomalies and collaborate with engineers to resolve root causes.
• Write complex SQL queries for ad-hoc data analysis.
• Navigate Linux servers and run validation scripts via the command line.
• Assist in monitoring data applications running on Kubernetes and collect logs.
• Maintain the Data Catalog and Business Glossary to reflect data reality.
• Build supplier n-tier maps to reveal upstream relationships.

Skills

SQL

Linux/CLI

Kubernetes

Data Warehousing

Python (Pandas)

QA Mindset

Attention to Detail

Technical Curiosity

Communication

Education

Bachelor’s or Master’s degree in CS/IS/Math or related field

Tools

Kubectl

Job description

At apexanalytix, we’re lifelong innovators! Since the date of our founding nearly four decades ago we’ve been consistently growing, profitable, and delivering the best procure-to-pay solutions to the world. We’re the perfect balance of established company and start-up. You will find a unique home here.

And you’ll recognize the names of our clients. Most of them are on The Global 2000. They trust us to give them the latest in controls, audit and analytics software every day. Industry analysts consistently rank us as a top supplier management solution, and you’ll be helping build that reputation.

Reports to: Manager, Automation Architect

POSITION SUMMARY

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.

KEY RESPONSIBILITIES

Data Quality Assurance (QA) & Testing

• Source-to-Target Validation: Perform comparative analysis between source systems and our Data Warehouse to ensure data was extracted and transformed correctly.
• Regression Testing: Validate data outputs after system updates or pipeline changes to ensure existing reports and dashboards remain accurate.
• Data Integrity Checks: Write SQL scripts to proactively identify nulls, duplicates, or schema mismatches before they impact the business.
• Bug Reporting: Document data anomalies clearly and track them to resolution, working closely with engineers to identify the root cause.

Analysis & Technical Operations

• Data Analysis: Write complex SQL queries to extract and manipulate data for ad-hoc business requests.
• Infrastructure Interaction: Use the Linux command line to navigate servers, execute validation scripts, and grep logs for errors.
• Kubernetes Support: Assist in monitoring data applications running on Kubernetes ; check pod status and retrieve logs (kubectl logs) to aid in debugging QA failures.
• Documentation: Maintain the Data Catalog and Business Glossary, ensuring that metric definitions match the technical reality of the data.
• Supplier N-Tier Mapping: 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.).

POSITION REQUIREMENTS

Education

• Currently pursuing a Bachelor’s or Master’s degree in Computer Science, Information Systems, Mathematics, or a related field.

Technical Skills & Knowledge

• SQL (Essential): Strong proficiency in writing SQL queries. You must be able to write queries to test data (e.g., finding set differences, counting variances).
• Linux / Command Line: Comfort working in a Linux environment . You should know basic shell commands (bash) for file management and log inspection.
• Kubernetes: Basic conceptual understanding of containerization. Familiarity with kubectl is a plus.
• Data Concepts: Understanding of Data Warehousing (Star Schema) and ETL processes.
• Programming: Basic proficiency in Python (Pandas) for scripting or data automation.
• QA Mindset: A natural skepticism of data. You should have the habit of asking, "Does this number actually make sense?"

Soft Skills & Attributes

• Attention to Detail: The ability to spot small discrepancies in large datasets.
• Technical Curiosity: A desire to understand the infrastructure (servers/containers) that supports the data.
• Communication: Ability to clearly report bugs and explain "why" a data point looks wrong to stakeholders.

Over the years, we’ve discovered that the most effective and successful associates at apexanalytix are people who have a specific combination of values, skills, and behaviors that we call "The apex Way". Read more about The apex Way - https://www.apexanalytix.com/careers/