Business Intelligence and Data Analyst
Business Intelligence and Data Analyst
Position Number: 00053992
Vacancy ID: NF0006052
Department: Inst Research and Assessment-505000Inst Research and Assessment - 505000
Classification/Appointment Type: EHRA Non-Faculty
Full Time Equivalent (FTE): 1
Full Time/Part Time Permanent/Time Limited:
If time-limited, estimated duration of appointment:
Hours Per Week: 40
Work Schedule:
Job Code ID: IT Analyst/Programmer - 2
Salary Shown to Applicants (Hiring Range):
Salary Grade Equivalency:
FLSA Designation: Exempt
Duties Exempt: Yes
Work Location:
Department Description:
The mission of the Office of Institutional Research and Assessment is to support the University of North Carolina at Chapel Hill’s teaching, research, and public service mission by conducting research and analysis that informs institutional planning, policy formation, decision-making, and evaluation of effectiveness, and by responding to external accountability mandates and a wide range of internal and external requests for information about the campus.
Equal Opportunity Employer:
The University of North Carolina at Chapel Hill is an equal opportunity and affirmative action employer. All qualified applicants will receive consideration for employment without regard to age, color, disability, gender, gender expression, gender identity, genetic information, national origin, race, religion, sex, sexual orientation, or status as a protected veteran.
Position Discription:
The primary purpose of this position is to support campus needs for data analytics, business intelligence, and
related metrics to inform decision-making, planning, and continuous improvement across the University. The
incumbent:
- Develops and implements web-based interactive reporting applications using dashboard tools (e.g., Tableau,
Microsoft Power BI) to communicate quantitative and visually-displayed information to internal UNC Chapel Hill
and public constituents.
- Supports information requests from inception to delivery, translating client requirements into appropriate
reporting objects that tell a story with data including, but not limited to: analytic scorecards, dashboards, and
reports.
- Develops and implements user-interactive reporting objects including filters, tool tips, and statistically-based
what if scenarios.
- Supports the institution’s internal and public-facing, strategic and operational reporting needs.
- Integrates information from a variety of campus operational and data warehouse systems and synthesizes it to
create self-service resources that enable users to explore the data and answer questions independently.
- Creates sustainable data models using SQL and database tools.Builds strong consultative relationships,
establishing value for the unit as a key partner for producing high-quality, actionable information that meets the
needs of decision-makers at all levels of the University.
- Contributes to or develops business intelligence and data modelling standards and guidelines.
- May lead or coordinate small, informal team(s) of developers to expedite completion of various assignments
and/or projects.
Essential Skills, Knowledge and Abilities:
N/A
Education Requirements:
Master’s and 1-2 years’ experience; or Bachelors and 2-4 years’ experience; or will accept a combination of related education and experience in substitution.
Preferred Qualifications:
Required Licenses/Certifications:
Qualifications and Experience:
Four or more years of progressively more responsible experience building web-based, interactive dashboards,
analytics, scorecards, dynamic reports, and other business intelligence objects using commercial data
visualization tools (e.g., Tableau, SAS Visual Analytics, Microsoft Power BI).
- Evidence of ability to present information that is easily interpretable by technical and non-technical audiences
using various formats including Excel and PowerPoint.
- Demonstrate strong analytic and problem-solving skills with great attention to detail and accuracy while working
with large, disparate data sets and performing mining, validation, and information interpretation.
- Demonstrate time management skills including clearly defining and planning activities and setting personal and
working team priorities, juggling competing priorities in a fast-paced, complex environment.
Special Physical and Mental Requirements:
Quick Link for Direct Access to Posting: https://unc.peopleadmin.com/postings/233583
Posting Open Date: 06/21/2022
Posting Close Date: 07/19/2022
Open Until Filled: No
Office of Human Resources Contact Information: If you experience any problems accessing the system or have questions about the application process, please contact the Office of Human Resources at (919) 843-2300 or send an email to employment@unc.edu
Please note: The Office of Human Resources will not be able to provide specific updates regarding position or application status.