HRIM Reporting and Data Analyst

Description The HRIM Data and Reporting Analyst serves as a technical subject matter expert supporting the HR system (Banner) and downstream processes. This position requires a deep understanding of Banner HR data structure and dependencies, including security and setup tables in addition to transactional data. 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 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. Providing documentation and training to functional users on data collection and changes to data collection processes. Collaborating with internal colleagues and those across campus to identify and implement process and system improvements. Ensuring system interfaces are properly specified, tested, and that data integrity and timeliness needs are met. Using exceptional customer service skills to build and maintain relationships with key constituents across the university. Qualifications 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 Associate’s degree and 5 or more years of relevant experience. 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. Preferred Education, Knowledge, Skills & Experience Master’s degree in Computer Science, Computer Programming, Management Information Systems, Business, HR or closely related discipline. 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. Higher education experience and understanding of HR operations and business processes. Ability to develop complex reports using SSDT or similar tool. Knowledge of methods, techniques, and practices of data collection, data entry, and report writing. High degree of accuracy and acute attention to detail. Experience with data management. Strong knowledge of MS Office. Advanced skills in Excel including V‑lookups, charts, and pivot tables. Ability to compile, analyze and synthesize data into clear formatted reports and presentations. Exemplary customer service skills and ability to establish professional relationships with internal and external constituents. Ability to take initiative, problem‑solve, meet deadlines and provide accurate data and information. Demonstrated organizational, project and time management skills. Strong quantitative, analytical, and critical thinking skills to solve problems independently. Ability to follow directions, work productively, and stay engaged with minimal oversight. Ability to adapt quickly to new and upgraded systems. EEO Statement UNCW does not discriminate against any employee or applicant for employment because of his or her race, sex (including gender, gender identity, marital status, childbirth, and pregnancy), age, color, national origin (including ethnicity), religion, disability, sexual orientation, political affiliation, veteran status, military service member status, genetic information, or relationship to other university constituents – except where sex, age, or ability represent bona fide educational or occupational qualifications or where marital status is a statutorily established eligibility criterion for State funded employee benefit programs. #J-18808-Ljbffr University of North Carolina at Wilmington