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. Duties include the implementation, documentation, and ongoing maintenance of HR reporting views and report design and development using tools such as SQL, SSDT and PowerBI. The HRIM Data and Reporting Analyst manages 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. This position serves as the main point of contact for Office of Institutional Research on mandatory annual reporting requirements including IPED's and HERD. This position prepares data for annual federal and state EEO reporting, and develops ad hoc reports as needed for both senior leadership and campus constituents. The HRIM Data and Reporting Analyst acts as the data custodian for Human Resources and makes determinations about data access, data views, and role assignments for Banner and SSRS. The position is responsible for 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.
The HRIM Data and Reporting Analyst utilizes strong analytical and sound decision making skills in supporting the day-to-day operations and various processes related to HR systems, including Banner and PeopleAdmin. This position oversees the maintenance of HR data (employee, validation tables, database set up) in the HR systems and provides leadership, guidance, and direction to the HR team to ensure accurate and timely processing of HR data. When problems are reported, this position uses analysis to determine and correct the root cause of the problem. Creates documentation and trains the functional users on data collection and/or changes to data collection processes. As a key member of HRSPM team, this position collaborates with internal colleagues and with colleagues across campus to identify and implement process and system improvements, as well to ensure that data integrity and timeliness needs are met and that system interfaces are properly specified and tested. The position uses exceptional customer service skills and builds and maintains relationships with key constituents across the university. The HRIM Data and Reporting Analyst is also responsible for the development and maintenance of consistent and accurate written documentation of HR systems, including processes, system modifications, enhancements, problems, interfaces, data dictionary maintenance, etc.
Minimum Education and Experience Requirements:
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.
Knowledge of relational databases and proficiency in development of both Oracle and SQL database queries.
Demonstrated ability to manage and work with system data and various data sets.
Ability to compile, analyze and synthesize data into clear formatted reports and presentation.
Exemplary customer service skills and demonstrated ability to establish good professional working relationships with a wide range of internal/external constituents.
Ability to take initiative, problem solve, meet deadlines and provide accurate data and information.
Possess a high degree of accuracy and acute attention to detail.
Demonstrated organizational, project and time management skills.
Ability to follow directions, work productively and stay engaged with a minimum amount of oversight.
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.
Demonstrated experience with data management.
Strong knowledge of MS Office.
Advanced skills in Excel including the ability to perform v-lookups, create charts, and create pivot tables.
Demonstrated ability to effectively organize, plan and prioritize work/projects, manage time, meet deadlines and deliver outcomes.
Strong demonstrated quantitative, analytical, and critical thinking skills to problem solve independently.
Strong sense of initiative and urgency.
Ability to manage multiple tasks and competing priorities simultaneously.
Demonstrated ability to adapt quickly to new and upgraded systems.
Excellent written, verbal and interpersonal communication skills.
Strong understanding of HR business processes.
Ability to provide timely and positive customer service.
Ability to participate and collaborate in HR cross-functional projects and activities.
Required Certifications or Licensure:
Primary Purpose of Organizational Unit:
The Human Resources Department is organized as follows: Classification & Compensation, Employee Relation & Engagement, HR Systems and Project Management and Salary Administration, Benefits, Talent Acquisition and Title IX and Clery Compliance. Each core unit provides a full range of professional human resources services to meet a variety of faculty, staff, student, business and operational needs of the University of North Carolina at Wilmington.
PLEASENOTE: This position will remain open until filled. To receive full consideration, please be sure you have fully completed the entire application, including the 'Work History' section before you apply for this position. Applications must be submitted through the online application system to be considered.
At the University of North Carolina at Wilmington (UNCW), our culture reflects our values of inclusion, diversity, globalization, ethics and integrity and innovation and we are committed to providing equality of educational and employment opportunity for all persons without regard to race, sex (such as 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. UNCW believes that embracing the unique contributions of our faculty, staff and students is critical to our success and paramount in being recognized for our global mindset.
About The University of North Carolina at Wilmington
The University of North Carolina Wilmington, the state’s coastal university, is dedicated to the integration of teaching, mentoring, research and service. Widely acknowledged for its world-class faculty and staff and continuously recognized at a national level for scholarly excellence and affordability, UNCW offers a powerful academic experience that stimulates creative inquiry and critical thinking and a community rich in diversity, inclusion and global perspectives.A public institution with nearly 18,000 students, UNCW offers a full range of baccalaureate- and graduate-level programs, as well as doctoral degrees in educational leadership, marine biology, nursing practice and psychology; and many distance learning options, including clinical research, an accelerated RN-to-BSN program, an Executive M.B.A. program structured for working professionals, and the nation’s only bachelor’s degree program focused on coastal engineering.The university’s efforts to advance research and scholarly activities have earned UNCW the elevated designation of “Doctoral Universities: High Research Activity” institution (R2 University) by the Carnegie Classification of Institutions of Higher Education.UNCW has been part of the University of North Carolina System since 1969.