IT Business Intelligence/Data Analyst I

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

Posting Information

• Posting Number: PG194767EP
• Internal Recruitment: No
• Working Title: IT Business Intelligence/Data Analyst I
• Anticipated Hiring Range: $71,000 - $74,105
• Work Schedule: Monday - Friday, 40 hours week
• Job Location: Raleigh, NC
• Department: 040101 - Graduate School-Dean's Office

About the Department: Graduate study has become increasingly important to professional development and career advancement. The Graduate School at NC State is ready for the challenge. With a focus on solving real-world issues through innovative research, NC State's graduate programs are committed to transforming graduate education-to prepare our best and brightest students as true leaders ready to tackle the critical issues that challenge our state, nation, and world. Our goal is to prepare career-ready students with a true competitive edge through a focus on professionally-oriented training designed for the real world. In scope and quality our graduate programs are superb. We offer master's and doctoral programs in a full range of traditional disciplines, as well as interdisciplinary programs that anticipate market trends and respond to national needs. Science, engineering, and technology are our core strengths. We also offer strong programs in design, education, management, the humanities, and the social sciences. Our location in North Carolina's Research Triangle means the best of industry-government-university partnerships. Our decade-old Centennial Campus reflects the university model of the future, where young investigators collaborate with faculty mentors, private companies, and public agencies to solve real-world problems. The land-grant tradition at NC State finds new expression in links with all 100 North Carolina counties and in consortia with other institutions, both domestic and international. NC State boasts a talented graduate student body of nearly 10,000 master's and doctoral students who reflect a richness that energize this community of scholars. They come from all 50 states and from over 100 different countries. We are proud of our students, of their achievements and of the outstanding graduate faculty who are their mentors. For more information, please visit our website at www.grad.ncsu.edu.

Wolfpack Perks and Benefits

As a Pack member, you belong here, and can enjoy exclusive perks designed to enhance your personal and professional well-being. As you consider this opportunity, we encourage you to review our Employee Value Proposition and learn more about what makes NC State the best place to learn and work for everyone.

• 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
• And so much more!

Attain Work-life balance with our Childcare benefits, Wellness & Recreation Membership, and Wellness Programs that aim to build a thriving wolfpack community.

Disclaimer: Perks and Benefit eligibility is based on Part-Time or Full-Time Employment status. Eligibility and Employer Sponsored Plans can be found within each of the links offered.

Essential Job Duties

Reporting to the Director of Information Management, the Data Analyst is responsible for designing, maintenance, and enhancing data infrastructures that support graduatelevel reporting and analytics across the university. This role integrates data from multiple complex sources-including Student, HR, and Finance systems-to fulfill routine and adhoc reporting needs.

The Data Analyst collaborates with departments across campus to define information requirements, develop accurate and timely reporting solutions, and ensure a high standard of data integrity. The position also partners with IT teams to update, maintain, or replace outdated information systems and reporting tools, including dashboards, metrics, and other analytics products.

The role requires strong knowledge of normalized databases, advanced Excel analysis, and working proficiency with data visualization tools.

Other Responsibilities

Key Responsibilities of the Data Analyst include, but are not limited to:

Data Infrastructure Development & Reporting

• 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.

Data Integrity, Documentation & Quality Assurance

• 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.

CrossCampus Collaboration & Data Support

• Work with Graduate School leadership and central offices (OIT, ISA, EMAS, etc.) 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.

Continuous Improvement & Professional Development

• Continually develop data management, analytics, and information technology skills to enhance organizational effectiveness.
• Participate in relevant training, conferences, and courses (e.g., Conferences, Certifications and Workshops on Data and Visualization concepts and tools).
• Contribute to ongoing improvements in university data infrastructure and reporting processes within graduate education.
• Use tools like Query Analyzer to analyze query performance and incorporate necessary enhancements to SQL queries.

Qualifications

Minimum Education and Experience

• Master's degree; or Bachelor's degree preferably in Computer Science or Business Analytics with zero - two years of relevant experience; or an equivalent combination of education, training and relevant experience.
• - For management-level roles, also include with the above requirements 1-2 years of supervisory experience.

Other Required 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

Preferred Qualifications

• Hands-on experience with SAS language, Oracle SQL, Power BI, SSIS, Python and Oracle PeopleSoft Query Manager.
• Certification in Database or Analytics.
• Some understanding of front end development technologies like PHP and WordPress.

Required License(s) or Certification(s)

N/A

Valid NC Driver's License required

No

Commercial Driver's License required

No

Recruitment Dates

Job Open Date: 07/31/2026

Anticipated Close Date: Open until filled

Position Details

Position Number: 00061780

Position Type: EPS/SAAO

Full Time Equivalent (FTE) (1.0 = 40 hours/week): 1.0

Appointment: 12 Month Recurring

Mandatory Designation - Adverse Weather: Non Mandatory - Adverse Weather

Mandatory Designation - Emergency Events: Non Mandatory - Emergency Event

Department ID: 040101 - Graduate School-Dean's Office

EEO Statement

NC State University is an equal opportunity employer.

All qualified applicants will receive equal opportunities for employment without regard to age, color, disability, gender identity, genetic information, national origin, race, religion, sex (including pregnancy), sexual orientation, and veteran status.

The University encourages all qualified applicants, including protected veterans and individuals with disabilities, to apply.

Individuals with disabilities requiring disability-related accommodations in the application and interview process are welcome to contact 919-513-0574 to speak with a representative of the Office of Equal Opportunity.

If you have general questions about the application process, you may contact Human Resources at [phone] or [e-mail].

Final candidates are subject to criminal & sex offender background checks. Some vacancies also require credit or motor vehicle checks. Degree(s) must be obtained prior to start date in order to meet qualifications and receive credit.

NC State University participates in E-Verify. Federal law requires all employers to verify the identity and employment eligibility of all persons hired to work in the United States.