Data Analyst I

ProctorU • Durham, NC

1d

About The Position

The Data Analyst I supports the collection, maintenance, validation, analysis, and reporting of testing and assessment data. The role helps ensure data accuracy and integrity, prepares reports, manages databases, and supports operational and client reporting needs. It offers an opportunity to develop technical, analytical, and database management skills in a testing, scoring, and assessment environment.

The position maintains and validates assessment and testing data, performs routine analysis and reporting, and supports Oracle and Microsoft SQL Server databases. It also contributes to improving data quality and reporting efficiency, including assisting with recurring report and validation automation. The role requires foundational SAS programming, database, and reporting skills and involves protecting confidential candidate and client information.

Requirements

• Bachelor's degree in Data Analytics, Computer Science, Information Systems, Statistics, Mathematics, Business Administration, or a related field.
• 1–2 years of experience in data analysis, data administration, database management, reporting, or a related field.
• Strong analytical and problem-solving skills.
• Excellent attention to detail and commitment to data accuracy.
• Ability to learn new systems, software, and technologies quickly.
• Strong organizational and time-management skills, including the ability to manage multiple tasks and meet deadlines.
• Effective written and verbal communication skills.
• Ability to work independently and collaboratively within a team.
• Understanding of data confidentiality and security requirements.
• Basic to intermediate knowledge of SAS programming and ability to create and execute SAS programs for data extraction, manipulation, validation, and reporting.
• Understanding of SAS datasets, procedures, and reporting tools.
• Proficiency in Microsoft Excel, including formulas and functions, pivot tables, filtering and sorting, charts, and basic data analysis.
• Proficiency in Microsoft Word and PowerPoint, with ability to create clear reports and presentations.
• Basic knowledge of Oracle database concepts and data structures, SQL querying, and relational database principles.
• Basic experience writing SQL queries and understanding database tables, relationships, joins, and views.

Nice To Haves

• Internship, academic project, or work experience involving data analysis or database systems.
• Experience with assessment, educational, certification, licensure, or testing data.
• Exposure to statistical analysis concepts.
• Experience with reporting and data visualization tools.
• Familiarity with ETL processes and data validation procedures.
• SAS Programming Certification or related coursework.
• Coursework or projects involving Oracle or SQL Server databases.
• Familiarity with SQL Server Management Studio (SSMS).

Responsibilities

• Maintain and update assessment and testing databases.
• Perform data entry, validation, reconciliation, and quality control activities.
• Review datasets for completeness, accuracy, and consistency.
• Assist with importing and exporting data files from internal and external sources.
• Support data governance and security standards for confidential candidate and client information.
• Document data processes, procedures, and business rules.
• Analyze testing, scoring, and operational data.
• Generate standardized and ad hoc reports for internal departments and clients.
• Perform routine data audits and identify discrepancies for correction.
• Support statistical reporting and summary analysis using SAS and SQL tools.
• Collaborate with team members to deliver accurate data on time.
• Assist in maintaining Oracle and Microsoft SQL Server databases.
• Write and execute SQL queries to extract, manipulate, and validate data.
• Support database testing and troubleshooting.
• Help monitor database performance and data processing activities.
• Identify opportunities to improve data quality and reporting efficiency.
• Assist with automating recurring reports and data validation processes.
• Participate in projects involving new data systems, workflows, and enhancements.

Benefits

• Competitive salary.
• 401(k) plan with company matching and immediate vesting schedule: 100% of the first 3% and 50% of the next 2%.
• BCBS health, dental, and vision insurance with substantial employer funding.
• Generous flexible time off approach.
• Ongoing professional development opportunities.
• Remote- and hybrid-first work environment.
• Mission-driven culture with supportive, high-performing colleagues.

What This Job Offers

• Job Type: Full-time
• Career Level: Entry Level