The Office of the University Registrar (OUR) is seeking aReporting and Business Analyst who will report to the Senior Programmer Analyst. In alignment with the mission and values of the Johns Hopkins University, the OUR maintains the integrity of student records, ensures institutional policy compliance, provides guidance and support to the divisional records/registrar offices, collaborates with university-wide stakeholders, and enhances the service capability of student systems in support of faculty teaching and student learning.
The Reporting and Business Analyst will be responsible for:
Assisting with university-wide reporting.
Fulfilling ad-hoc requests for data from both internal and external constituents.
Assisting with data validation for any system implementation, maintenance and support (including installation, modification, and testing of new and/or upgraded applications and productivity tools).
Assisting with creating and maintaining relevant system and process documentation.
Contributing to the success of technical and functional projects related to the advancement of institutional strategic initiatives, compliance and data governance, institutional integrity, and the modernization of student information solutions across all JHU divisions.
Specific Duties & Responsibilities
Assist the Senior Programmer Analyst with university-wide external reporting for the State of Maryland and the Department of Education by compiling information and coordinating data validation.
Assist with reporting for the Integrated Postsecondary Education Data System (IPEDS), the Maryland Higher Education Commission (MHEC), and the National Collegiate Athletics Association (NCAA); assist with Common Data Set (CDS) report validation.
Assist with custom reports for specific data requests made by internal and external constituents.
Assure quality and validity of institutional reports by maintaining records in support of summary data reports and outlines of methodology implemented such that reports are replicable.
Under the direction of the Senior Programmer Analyst, develop and improve university-wide reporting protocols; maintain data dictionary; and provide training across all JHU divisions.
Coordinate with all university divisions regarding data integrity prior to freezing extracts used for university-wide reporting.
Coordinate the submission of multiple student data files from the JHU student information system (SIS) to the National Student Clearinghouse; review and correct errors generated by the Clearinghouse for each submission; initiate changes to the data files as mandated by the Clearinghouse or JHU offices for accurate reporting.
Participate in professional development opportunities to keep informed of trends, issues and best practices pertaining to institutional reporting.
Research and resolve discrepancies in reports; recommend reporting improvements.
Ensure data integrity and monitor data entry, data analysis, and report generation for adherence to established policies, procedures, and deadlines.
Retrieve data from system of record or point-in-time saved extracts using SQL queries and analyze the data with Access, Excel, SPSS, Tableau or other statistical software packages as warranted.
Assist in the diagnosis and solution of program or data errors and inconsistencies.
Under the direction of the University Registrar and the Senior Programmer Analyst, work with internal auditors concerning data submissions to the State of Maryland.
Maintain updated program inventory, Higher Education General Information Survey (HEGIS) codes and IPEDS Classification of Instructional Programs (CIP) codes from the Maryland Higher Education Commission Research and resolve discrepancies in reports; recommend reporting improvements.
Run scheduled audit reports and provide support for data clean-up of student records.
Assist in the development and clarification of specifications for data extracts and reports for internal and external use.
Other Systems & Data
Provide technical support for university databases, including SIS, the University Data Warehouse (UDW), scheduling software, course evaluation software, and others.
Serve as a resource on records, systems and data and provide records-related functional systems and data support to the OUR and across all divisions as required.
Ensure processes and practices actively safeguard student data (in accordance with university policies).
Develop documentation for reporting, systems and data resources; and conduct on-going and ad-hoc training for internal and external users.
Other duties as assigned.
Assist the OUR team with project elements such as research/benchmarking, requirements gathering, user acceptance testing, and post-implementation evaluation.
Assist the OUR team with creating and organizing project documentation, including project charters, files, and other project resources.
Bachelor's Degree in Data Analytics, Information Systems, Computer Science or related field required.
Four years of related work experience with reporting and/or computer systems and applications.
Database programming experience with a major RDBMS (preferably SQL server).
Experience with reporting software tools such as SQL Reporting Services or Tableau.
Experience with SQL Server Integration Services (SSIS), Microsoft Access, Visual Basic, and XML.
Experience with student information systems and applications.
Experience with OnBase or other document imaging software.
Experience with Microsoft Office Suite of programs (Word, Excel, SharePoint, Visio, etc.).
Experience with project management software (i.e., Asana, Microsoft Project).
Experience using Microsoft BI or Cognos BI.
Experience working with cross-functional teams and processes.
Experience with conducting user-acceptance testing, including developing test cases and scripts.
Special Knowledge, Skills & Abilities
Ability to make informed decisions database management, systems performance, and reporting integrity
Ability to independently analyze business requirements obtained from functional users in support of process improvement
Ability to determine the most advantageous combination of available tools, languages, and technologies to provide the best mix of back-end flexibility and end-user functionality
Ability to work with flexibility, efficiency, enthusiasm, and diplomacy both individually and as part of a complex team effort
Accuracy and attention to detail in all aspects of the position
Ability to collaborate and problem-solve regarding business process improvements and innovative solutions, and to oversee implementation of new solutions or systems
Ability to demonstrate discretion when working with sensitive issues
Ability to train functional users by developing manuals and presenting workshops
Effective communication skills, including the ability to present complex technical information clearly to technical and nontechnical audiences
Strong organizational skills and the ability to support multiple projects/assignments simultaneously in a fast-past work environment
Strong attention to detail
Classified Title: Business Analyst Working Title: Reporting and Business Analyst Role/Level/Range: ATP/04/PD Starting Salary Range: Commensurate with experience Employee group: Full Time Schedule: Monday-Friday, 8:30-5:00 Exempt Status: Exempt Location: Mount Washington Campus Department name: University Registrar Personnel area: University Student Services
Please refer to the job description above to see which forms of equivalency are permitted for this position. If permitted, equivalencies will follow these guidelines:
30 undergraduate degree credits (semester hours) or 18 graduate degree credits may substitute for one year of experience. Additional related experience may substitute for required education on the same basis. For jobs where equivalency is permitted, up to two years of non-related college course work may be applied towards the total minimum education/experience required for the respective job.
The successful candidate(s) for this position will be subject to a pre-employment background check.
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran.
If you are interested in applying for employment with The Johns Hopkins University and require special assistance or accommodation during any part of the pre-employment process, please contact the Talent Acquisition Office at [email protected]. For TTY users, call via Maryland Relay or dial 711. For more information about workplace accommodations or accessibility at Johns Hopkins University, please visit accessibility.jhu.edu.
The following additional provisions may apply, depending on campus. Your recruiter will advise accordingly.
The pre-employment physical for positions in clinical areas, laboratories, working with research subjects, or involving community contact requires documentation of immune status against Rubella (German measles), Rubeola (Measles), Mumps, Varicella (chickenpox), Hepatitis B and documentation of having received the Tdap (Tetanus, diphtheria, pertussis) vaccination. This may include documentation of having two (2) MMR vaccines; two (2) Varicella vaccines; or antibody status to these diseases from laboratory testing. Blood tests for immunities to these diseases are ordinarily included in the pre-employment physical exam except for those employees who provide results of blood tests or immunization documentation from their own health care providers. Any vaccinations required for these diseases will be given at no cost in our Occupational Health office.
Note: Job Postings are updated daily and remain online until filled.
Johns Hopkins University remains committed to its founding principle, that education for all students should be grounded in exploration and discovery. Hopkins students are challenged not just to learn but also to advance learning itself. Critical thinking, problem solving, creativity, and entrepreneurship are all encouraged and nourished in this unique educational environment. After more than 130 years, Johns Hopkins remains a world leader in both teaching and research. Faculty members and their research colleagues at the university's Applied Physics Laboratory have each year since 1979 won Johns Hopkins more federal research and development funding than any other university. The university has nine academic divisions and campuses throughout the Baltimore-Washington area. The Krieger School of Arts and Sciences, the Whiting School of Engineering, the School of Education and the Carey Business School are based at the Homewood campus in northern Baltimore. The schools of Medicine, Public Health, and Nursing share a campus in east Baltimore with The Johns Hopkins Hospital. The Peabody Institute, a leading professional school of music, is located on Mount Vernon Place in downtown Bal...timore. The Paul H. Nitze School of Advanced International Studies is located in Washington's Dupont Circle area.