nc_state_university.jpg

Business Intelligence/Data Analyst

Job Description

Posting Number

PG193843EP

Internal Recruitment

No

Working Title

Business Intelligence/Data Analyst

Anticipated Hiring Range

$80,000 - $83,315

Work Schedule

Flexible 7:30 am - 4:30 pm or 8:00 am - 5:00 pm, Monday-Friday

Job Location

Raleigh, NC

Department

Business Systems

About the Department

The North Carolina State University Facilities Division ensures that the campus’s physical environment supports the university’s mission 24 hours a day, 365 days a year. Our diverse team of approximately 900 dedicated professionals plans for current and future needs, builds high-impact facilities, and maintains the campus. Join one of the largest and best employers in the state and help shape the future of our campus community!

As a Pack member, you can enjoy exclusive perks designed to enhance your personal and professional well-being.

What we offer:

Essential Job Duties

Join our team as a Business Intelligence/Data Analyst in the Business Systems Department within the Facilities Division! We are seeking a detail-oriented professional who can expertly manage systems to track, validate, and record the work and costs associated with the Facilities Division. This role is essential in ensuring campus customer satisfaction, supporting accurate billing, and generating insightful reports through tools like Microsoft Power BI, Tableau, BIRT, Crystal Reports, and Google and Microsoft Suites. If you’re ready to make a difference and contribute to our campus community, apply today!

Key responsibilities and duties include, but are not limited to:

  • Support for the integrated work/fleet management systems, campus-wide, across multiple departments
  • Ensure security protocols and manage multiple databases, and data repository
  • Provide knowledge in applications analysis, design analysis, project planning, and thorough testing, debugging, implementation, and documentation
  • Perform system upgrades and lead projects to implement new processes in a dynamic environment
  • Provide technical support to system programmers, analysts, and other staff involved in implementing and integrating AiM and Microsoft Power BI solutions across the campus
  • Execute ETL processes and conduct data analysis to deliver actionable business intelligence and trend insights that support data-driven decision-making
  • Create and maintain Microsoft Power BI dashboards and DAX formulas for data transformation and analysis
  • Work with Web/Power Apps development to integrate Microsoft Power BI with new and existing dashboards for enhanced user accessibility
  • Generate standard or custom reports summarizing financial or operational data for stakeholders
  • Ensure timely delivery of business intelligence to users and maintain tools and systems to support continuous improvement
  • Collaborate extensively with the Facilities Budget Office and other Directors to ensure accurate billing and adherence to Standard Operating Procedures
  • Support the Business Systems team, by providing data visualization insights and recommendations

Other Responsibilities

  • Perform other duties as assigned

Minimum Education and Experience

  • Master’s degree in a related field of study and at least one year of relevant experience OR
  • Bachelor’s degree in a related field of study with at least two years’ of relevant experience OR
  • An equivalent combination of education, training and relevant experience

Other Required Qualifications

  • Proficient in Microsoft Power BI/Tableau development, including DAX functions, Power Query, Power Automate, and integration with other business systems to create impactful visualizations, reports, and dashboards
  • Skilled in SQL for creating custom tables, views, and scripts
  • Solid understanding of accounting principles, data systems, data reporting, and data visualization best practices
  • Experience with JavaScript, Web Apps, REST APIs, and database management in Oracle, MS SQL Server, and MongoDB
  • Customer-focused, with a strong drive to empower better decision-making through effective data usage
  • Competent in developing project scopes, test plans, and comprehensive technical documentation

Preferred Qualifications

  • Experience within a Facilities Management department
  • Proficiency in AiM Integrated Work Management System
  • Skilled in creating Microsoft’s paginated reports and integrating into Power BI dashboard
  • Strong knowledge of data modeling, ETL processes, and cloud services (Azure, Microsoft Power BI Service)
  • Familiarity with ESRI GIS products and other report writing tools
  • Familiar with Paginated reports and Microsoft Power Automate

Required License(s) or Certification(s)

  • Valid DL required
  • Valid North Carolina driver’s license is required within 60 days of hire and must be maintained

Valid NC Driver's License required

Yes

Commercial Driver's License required

No

Job Open Date

01/16/2025

Anticipated Close Date

Open until filled

Special Instructions to Applicants

In addition to your application please submit a resume, cover letter, and contact information for at least 3 professional references.

Position Number

00106181

Position Type

Exempt Professional Staff

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

1.00

Appointment

12 Month Recurring

Mandatory Designation - Adverse Weather

Non Mandatory - Adverse Weather

Mandatory Designation - Emergency Events

Other

Department ID

447040 - Business Systems

AA/EEO

NC State University is an equal opportunity and affirmative action employer. All qualified applicants will receive consideration for employment without regard to race, color, national origin, religion, sex, gender identity, age, sexual orientation, genetic information, status as an individual with a disability, or status as a protected veteran. Individuals with disabilities requiring disability-related accommodations in the application and interview process are welcome to contact 919-515-3148 to speak with a representative at 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.

*Please mention you saw this ad on VeteransInCareers.*

Apply Now

Be Seen By Recruiters at the Best Institutions

Create a FREE Profile to be Seen!

Want to stand

Where Veterans Thrive in Careers.®