Job OverviewBe a Tar Heel! A global higher education leader in innovative teaching, research and public service, the University of North Carolina at Chapel Hill consistently ranks as one of the nation's top public universities. Known for its beautiful campus, world‑class medical care, commitment to the arts and top athletic programs, Carolina is an ideal place to teach, work and learn. One of the best college towns and best places to live in the United States, Chapel Hill has diverse social, cultural, recreation and professional opportunities that span the campus and community. University employees can choose from a wide range of professional training opportunities for career growth, skill development and lifelong learning and enjoy exclusive perks for numerous retail, restaurant and performing arts discounts, savings on local child care centers and special rates on select campus events. UNC‑Chapel Hill offers full‑time employees a comprehensive benefits package, paid leave, and a variety of health, life and retirement plans and additional programs that support a healthy work/life balance.Primary Purpose Of Organizational UnitThe Division of Finance and Operations at UNC‑Chapel Hill encompasses a broad range of departments (Facilities Services, Finance, Budget & Data Analysis, Real Estate & Campus Enterprises, Human Resources, and Organizational Strategy and Performance) that serve and support the University's teaching, research and public service mission through dedicated, innovative work processes and high‑quality customer service. The HR Information Management Department is a sub‑unit of the division and works collaboratively with HR managers, HR staff, Information Technology Services, other central offices, and customers to help improve HR related processes and systems. This ranges from determining business needs, analyzing and identifying solutions, configuring the system, specifying system/integration changes, testing and educating end users about using the functionality. The team supports the University's ConnectCarolina HR/Payroll (PeopleSoft) system which is used for Human Resources, Benefits, and Payroll activities and a variety of other HR related systems such as the Recruiting system, the Background Check system, the I‑9/eVerify system and the Talent Management System (for Learning and Performance Management). The unit also develops and maintains several small to medium scale departmental databases. The unit provides level 2 support for customer issues and ongoing functional support of the systems such as applying bundles and patches and implementing changes and enhancements requested to support new or changed business processes. The team handles HR reporting and data analytics including assessing, developing and producing necessary management reporting products and producing metrics and analytics to support a data‑driven approach to HR service delivery.Position SummaryThis position is a 100% remote work arrangement, consistent with System Office policy. UNC Chapel Hill employees are generally required to reside in North Carolina, within a reasonable commuting distance of their assigned duty station. The primary purpose of this position is to provide reporting solutions and analytical support to stakeholders internal and external to the division.ResponsibilitiesIdentifies reporting needs, communicates with stakeholders, and delivers sustainable reporting solutions.Evaluates technical designs and communicates recommendations when potential hazards exist or impacts to other systems were not described in the document.Proactively and independently identifies data issues through extensive data analysis and communicates achievable solutions to the relevant audience.Mentors and influences other Business Analysts and technical staff through training to ensure that high quality coding strategies are applied consistently across campus.Communicates with internal and external stakeholders to develop complicated reporting solutions that rely on data from multiple sources and are necessary to achieve compliance across the University.Develops and provides complex reporting solutions using PS Query and/or SQL.Troubleshoots and resolves tickets and reporting issues, provides support for report testing.Minimum Education And Experience RequirementsMaster'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.Required Qualifications, Competencies, And ExperienceExcellent verbal and written communication skills.Ability to multi‑task, manage competing priorities and thrive in a highly dynamic environment.1‑3 years' experience with writing SQL and/or PS Query.Preferred Qualifications, Competencies, And Experience3‑5 years' experience with SQL and/or PeopleSoft Query technology.1‑3 years' experience in a Higher Education Environment strongly preferred.1‑3 years' experience with reporting or data analysis in Human Resources, Payroll or Benefits preferred.1‑3 years' experience with PeopleSoft or similar ERP system strongly preferred.1‑3 years' experience with Informatica.Campus Security Authority ResponsibilitiesNot Applicable.#J-18808-Ljbffr