Job description


  • Entry level
  • No Education
  • Salary to negotiate
  • Columbia


Posting Information

Position Information

Position TypePermanent Staff (EHRA NF)DepartmentInst Research and Assessment-505000Working TitleBusiness Intelligence and Data AnalystAppointment TypeEHRA Non-FacultyPosition Posting CategoryInformation TechnologySalary Range$83,000 to $95,000Full Time/Part Time?Full-Time PermanentHours per Week40Vacancy IDNF0004113Position ID00053429Posting Open Date11/08/2019Application Deadline12/06/2019Open Until FilledNoProposed Start Date12/09/2019Position SummaryThe 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, R, SAS Visual Analytics, 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.
-Provides intermediate analytic programming support (e.g., R, Python, or SAS).
-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.

Educational RequirementsMaster’s and 1-2 years’ of experience or Bachelors and 2-4 years of experience; will accept a combination of related education and experience in substitution.

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, R, SAS Visual Analytics, Microsoft Power BI).
-Four or more years of analytic programming using tools like R, Python, and SAS.
-Demonstrated experience using complex SQL queries to extract data from databases.
-Demonstrated ability to conduct basic statistical analyses using tools such as SPSS, Stata, SAS, Excel.
-Demonstrated experience creating database objects including views, tables, and indexes in an enterprise quality relational database system (e.g., SQL Server, Oracle, MySQL).
-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.

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.

Special InstructionsApplicants are required to submit a URL or PDF demonstrating a sample of their business intelligence or dashboard work products.

Quick Link Department Contact Information

Department Contact Name and TitleDepartment Contact Telephone or EmailOffice of Human Resources Contact InformationIf 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
Please note: The Office of Human Resources will not be able to provide specific updates regarding position or application status.

Applicant DocumentsRequired Documents
- Curriculum Vitae / Resume
- Cover Letter
- Other Document

Optional Documents
- List of References

Supplemental QuestionsRequired fields are indicated with an asterisk (*).

- * Do you require H1B sponsorship?
- Yes
- No

- * Please describe your experience using Business Intelligence to improve an organization. (Open Ended Question)

- * Describe your experience with query tools, business intelligence tools, and data visualization tools. (Open Ended Question)

- * Please select the education / experience that matches your background
- Master’s degree or higher and 1-2 years’ of experience
- Bachelors degree and 2-4 years of experience
- A combination of related education and experience
- None of the above

  • excel
  • mysql
  • oracle
  • spss
  • sql