Data Analytics & BI Analyst I — Graduate School

North Carolina State University; Raleigh (NC); On-site; USD 71,000 - 74,105; Full time

Benefits offered by this job

Medical, Dental, and Vision

Flexible Spending Account

Retirement Programs

Disability Plans

Life Insurance

Accident Plan

Paid Time Off and Other Leave Programs

12 Holidays Each Year

Tuition and Academic Assistance

Job summary

NC State University is seeking an IT Business Intelligence/Data Analyst I to design, build, and maintain data infrastructure supporting graduate-level reporting. The role integrates data from Student, HR, and Finance systems to fulfill routine and adhoc reporting needs.

You will collaborate with campus partners to develop accurate reports and dashboards, ensure data integrity, and support analytics across departments.

Qualifications

• Experience with writing and executing SQL queries.
• Experience with Predictive Analytics using Python and SAS.
• Good understanding of normalized and relational databases.
• Excel data analysis and reporting functionalities.
• Experience with Pivot Tables and Power Queries within Excel.
• Working knowledge of visual analytics and report creation using visualization tools like Power BI and SAS VA.
• Experience with data manipulation and warehousing tools like SQL Server Integration Services, SAS DI Studio and Power Automate.
• Experience with scheduling of jobs within Windows and SQL Server.
• Experience with advanced tools like Query Analyzer and SQL Server Management Studio.
• Analytic Skills, Problem Solving.
• Ability to communicate effectively with internal and external customers.
• Project & Time Management.
• Collaboration & Team Building.
• Languages: SQL, SAS, Python, Power BI DAX
• Databases: Relational/Normalized databases like Oracle and MS SQL Server

Responsibilities

• Design, build, and maintain data infrastructure to streamline routine and adhoc reporting for graduate education.
• Create complex datasets and reports to meet stakeholder needs (e.g., graduate admissions, enrollment, and trend analyses).
• Utilize university information systems to produce analytics and metrics supporting universitywide stakeholders.
• Support frontend development efforts that enhance data accessibility, including contributing to web pages and applications using PHP, WordPress, or related tools.
• Establish and maintain comprehensive documentation of data infrastructure, including data dictionaries, ETL documentation, and workflow records.
• Conduct regular audits to ensure data accuracy and integrity.
• Monitor and troubleshoot data issues proactively.
• Work with Graduate School leadership and central offices to support strategic initiatives and operational needs.
• Provide data extracts, queries, and custom reports for internal and external requests (e.g., selfassessment data, NSF surveys).
• Assist departments and campus partners with individual data needs, both routine and adhoc.
• Participate in efforts to update or replace outdated datasets, webpages, jobs, and reporting tools.
• Continually develop data management, analytics, and information technology skills to enhance organizational effectiveness.
• Use tools like Query Analyzer to analyze query performance and incorporate necessary enhancements to SQL queries.

Skills

SQL

Python

Power BI

SAS

Education

Master's or Bachelor's in CS/Analytics

Tools

SSIS

SAS DI Studio

SQL Server Management Studio

PHP/WordPress

Job description

NC State University is seeking an IT Business Intelligence/Data Analyst I to design, build, and maintain data infrastructure supporting graduate-level reporting. The role integrates data from Student, HR, and Finance systems to fulfill routine and adhoc reporting needs.

You will collaborate with campus partners to develop accurate reports and dashboards, ensure data integrity, and support analytics across departments.