New

Business Intelligence/Data Analyst

North Carolina State University

$80,000 - $83,315

life insurance, flexible benefit account, paid time off

United States, North Carolina, Raleigh

Jan 16, 2025

Posting Information

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: 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!
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

Qualifications

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

Recruitment Dates and Special Instructions

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 Details

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.