IT Business Intelligence/Data Analyst I

Raleigh, NC • Full-time (1.0 FTE, 40 hours/week, Monday–Friday)

About the Department

The Graduate School at NC State is committed to transforming graduate education by preparing career-ready students with a competitive edge through professionally-oriented training. Our graduate programs span traditional disciplines and interdisciplinary fields, with core strengths in science, engineering, and technology. Located in North Carolina’s Research Triangle, NC State fosters industry-government-university partnerships, including the Centennial Campus, where students collaborate with faculty, private companies, and public agencies to solve real-world problems. The Graduate School serves nearly 10,000 master’s and doctoral students from all 50 states and over 100 countries.

About the Role

Reporting to the Director of Information Management, the IT Business Intelligence/Data Analyst I designs, maintains, and enhances data infrastructures supporting graduate-level reporting and analytics across the university. This role integrates data from multiple complex sources—including Student, HR, and Finance systems—to fulfill routine and ad-hoc reporting needs. The analyst collaborates with departments to define requirements, develop reporting solutions, and ensure data integrity, while partnering with IT teams to update or replace outdated systems and tools.

Responsibilities

• Data Infrastructure Development & Reporting:
  • Design, build, and maintain data infrastructure to streamline routine and ad-hoc reporting for graduate education.
  • Create complex datasets and reports for stakeholder needs (e.g., graduate admissions, enrollment, and trend analyses).
  • Produce analytics and metrics supporting university-wide stakeholders using university information systems.
  • Support front-end development efforts to enhance data accessibility, including contributions 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.
• Cross-Campus 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., self-assessment data, NSF surveys).
  • Assist departments and campus partners with individual data needs, both routine and ad-hoc.
  • Participate in efforts to update or replace outdated datasets, webpages, jobs, and reporting tools.
• Continuous Improvement & Professional Development:
  • Develop data management, analytics, and information technology skills to enhance organizational effectiveness.
  • Participate in relevant training, conferences, and courses (e.g., data and visualization concepts/tools).
  • Contribute to ongoing improvements in university data infrastructure and reporting processes within graduate education.
  • Analyze query performance using tools like Query Analyzer and enhance SQL queries as needed.

Requirements

• Minimum Education and Experience:
  • Master’s degree; or
  • Bachelor’s degree (preferably in Computer Science or Business Analytics) with 0–2 years of relevant experience; or
  • An equivalent combination of education, training, and relevant experience.
• Other Required Qualifications:
  • Experience writing and executing SQL queries.
  • Experience with predictive analytics using Python and SAS.
  • Good understanding of normalized and relational databases.
  • Proficiency in Excel data analysis and reporting functionalities, including Pivot Tables and Power Queries.
  • Working knowledge of visual analytics and report creation using tools like Power BI and SAS VA.
  • Experience with data manipulation and warehousing tools like SQL Server Integration Services (SSIS), SAS DI Studio, and Power Automate.
  • Experience scheduling jobs within Windows and SQL Server.
  • Familiarity with advanced tools like Query Analyzer and SQL Server Management Studio.
  • Strong analytic skills and problem-solving abilities.
  • Ability to communicate effectively with internal and external customers.
  • Project and time management skills.
  • Collaboration and team-building skills.
• Languages & Databases:
  • SQL, SAS, Python, Power BI DAX.
  • 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.

Pay

$71,000 – $74,105

Benefits

• Medical, dental, and vision coverage.
• Flexible Spending Account.
• Retirement programs.
• Disability and life insurance plans.
• Accident plan.
• Paid time off and other leave programs, including 12 holidays per year.
• Tuition and academic assistance.
• Childcare benefits.
• Wellness & Recreation membership and wellness programs.

Eligibility for perks and benefits is based on part-time or full-time employment status.