Data Analyst Intern (Summer 2027)

apexanalytix-careers; Greensboro (NC); On-site; USD 25,000 - 36,000; Full time

Job summary

apexanalytix seeks a Data Analyst Intern to join our Greensboro, NC team. You will work in our on-premise data environment, focusing on QA, data validation, and accuracy of data powering business decisions.

Your work includes writing SQL, performing source-to-target checks, and supporting Linux-based validation. You’ll learn about Data Catalogs, API data flows, and supplier mapping while collaborating with engineers.

Qualifications

• 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 to test data (set differences, variances).
• Comfort working in a Linux environment with basic shell commands (bash).
• Understanding of Data Warehousing (Star Schema) and ETL processes.
• Basic proficiency in Python (Pandas) for scripting or automation.
• Interest in QA with a skeptical mindset toward data and results.

Responsibilities

• Data Quality Assurance (QA) & testing: perform source-to-target validation between source systems and Data Warehouse.
• Regression testing: validate data outputs after updates to keep reports accurate.
• Data integrity checks: write SQL to identify nulls, duplicates, or schema mismatches.
• Bug reporting: document data anomalies and track to resolution with engineers.
• Data analysis: write complex SQL queries for ad-hoc business requests.
• Infrastructure interactions: use Linux CLI to run validation scripts and grep logs.
• Kubernetes support: monitor data apps, check pod status, retrieve logs for QA issues.
• Documentation: maintain Data Catalog and Business Glossary with accurate metric definitions.
• Research supplier n-tier mappings to understand upstream supplier relationships.

Skills

SQL

Linux

Kubernetes

Data Warehousing

ETL

Python (Pandas)

QA Mindset

Attention to Detail

Communication

Technical Curiosity

Education

Bachelor’s or Master’s degree in Computer Science or related field

Tools

Kubectl

Linux

Python (Pandas)

Job description

About Us:

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.

Read more about apexanalytix - https://www.apexanalytix.com/about/

Position Title:

Data Analyst Intern

Reports to:

Manager, Automation Architect

Location:

Greensboro, N.C.

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/