Business Intelligence Analyst

Location: Raleigh, NC

Essential Job Duties

The Business Intelligence Analyst supports UDA reporting and analytics functions by understanding the content, format, data definitions and appropriate usage of institutional data and applying that knowledge to meet the information needs of university leadership, administrators, and the NC State community. The Business Intelligence Analyst identifies, collects, analyzes and reports student, employee, and other data, and builds, documents and maintains dashboards and other self-service institutional data tools in support of external reporting requirements and internal planning, analysis, and decision-making.

The Business Intelligence Analyst provides analysis and interpretation of the data; promotes accuracy, integrity and consistency of data and data products; and effectively reports and communicates information to a variety of constituents. The ideal candidate will have experience in

the phases of enterprise data life-cycles in higher education, including data acquisition, cleaning and processing, documentation, data validation and analysis,

visualization and user support.

Specific duties of the position include but are not limited to:

Content Development and Documentation

• Identify information needs and propose projects and solutions to meet those needs
• Work with other UDA staff, project teams, and campus partners to identify and document requirements for new analytical products, as well as enhancements to existing reports and dashboards
• Design, build, document, and maintain enterprise analytical products - datasets, tables, reports, dashboards, visualizations - that accurately aggregate, summarize and convey NC State's employee, finance, instructional programs, research administration, student and other institutional data with scope of responsibility including all phases of development and execution (determining requirements; data acquisition and cleaning; data processing, aggregation, and calculations; end-product design, interactivity, and build; documentation; testing and quality control; and rollout and stabilization)
• Develop, streamline, and automate processes for managing, maintaining, and producing data and analytical products
• In consultation with UDA staff, create documentation for official UDA datasets and analytical products

Analytics Enablement and Support

• Support users of UDAs data and analytical products by creating high quality user-friendly documentation, developing instructions or training materials (through the use of tools such as Google Workspace, Adobe Creative Suite and video editing software e.g., ClipChamp) and being a resource and point of contact for end-users
• Assist with data validation and data quality reviews of existing reports, dashboards and institutional datasets
• Complete UI/UX quality assurance reviews for enterprise analytical products, created by others, to ensure adherence to governance and visualization standards
• Stay up-to-date with the latest trends and best practices in BI, data analytics, and data visualization to develop, document and implement best practices

Other Work/Responsibilities:

• Other duties as assigned.

Minimum Experience/Education:

• Master's degree; or Bachelor's degree 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.

Required Qualifications:

• Experience with analytics-related programming languages (such as SQL)
• Experience creating data visualizations utilizing Microsoft Power BI, Power Query and DAX
• Experience with querying, transforming, and analyzing data to produce usable information
• Ability to understand and work with complex, cross-functional data
• Ability to create and update analytics-related documentation
• Ability to ensure data quality and integrity
• Ability to follow UI/UX protocols and provide guidance to others on how to align with protocols
• Strong communication skills and ability to understand the needs of the upper administration and the university community
• Ability to meet deadlines and manage competing priorities in a fast-paced environment
• Ability to follow security procedures and work with secure/confidential data
• Self-motivated, with strong attention to both detail and accuracy
• Ability to collaborate with others and to work in a team environment

Preferred Qualifications:

• At least one year of professional experience working with data to produce reports, dashboards, or perform data analysis
• Experience with Microsoft Power BI or Power BI certification
• Experience in higher education in a professional role utilizing or handling university data

Required License or Certification:
N/A

AA/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 (919) 515-2135 or workatncstate@ncsu.edu.

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.

Apply Now