The University of North Carolina Wilmington (UNCW) needs a technical subject matter expert to support its HR system (Banner) and downstream processes, ensuring accurate and timely processing of HR data, managing compliance initiatives, and providing data for reporting and decision-making.
Requirements
- Knowledge of relational databases and proficiency in development of both Oracle and SQL database queries.
- Experience managing and working with system data and various data sets.
- 1 year or more of experience working with higher education ERP systems, preferably Ellucian Banner.
- 1 year or more of experience with programming and knowledge of SQL.
- Ability to develop complex reports using SSDT or similar tool
- Knowledge of methods, techniques, and practices of data collection, data entry, and report writing.
- Advanced skills in Excel including the ability to perform v-lookups, create charts, and create pivot tables.
Responsibilities
- Implementation, documentation, and ongoing maintenance of HR reporting views and report design and development using tools such as SQL, SSDT and PowerBI.
- Managing the processes for several key compliance initiatives for UNCW, including, but not limited to, the monthly HR Datamart submissions and Affordable Care Act (ACA) process, ensuring that UNCW’s data submissions are accurate and error free.
- Serving as the main point of contact for Office of Institutional Research on mandatory annual reporting requirements including IPED’s and HERD.
- Preparing data for annual federal and state EEO reporting, and developing ad hoc reports as needed for both senior leadership and campus constituents.
- Acting as the data custodian for Human Resources and making determinations about data access, data views, and role assignments for Banner and SSRS.
- Maintaining data integrity in HR systems by running queries, analyzing data, and working with functional areas to educate and correct integrity issues through process improvement.
- Creates documentation and trains the functional users on data collection and/or changes to data collection processes.
Other
- A Bachelor’s degree in Computer Science, Computer Programming, Management Information Systems, Business, HR or closely related discipline and 2 or more years of relevant experience; or an Associate’s degree and 5 or more years of relevant experience.
- Possess a high degree of accuracy and acute attention to detail.
- Demonstrated experience with data management.
- Strong knowledge of MS Office.
- Ability to compile, analyze and synthesize data into clear formatted reports and presentation.
