This job has expired

Business/Data Analyst

Princeton University
New Jersey, United States
Salary Not specified
Posted Date
Sep 13, 2022
You need to sign in or create an account to save a job.

Business/Data Analyst


Job ID: 2022-15235
Type: Full-Time
# of Openings: 1
Category: Information Technology

Princeton University


Reporting to the Director of Data Management and Operations, the Business Systems Analyst supports key technology and system-related activities in the Office of the Dean of the Faculty (ODoF). This position will provide leadership across business processes, engaging in other functional areas and offering knowledge transfer and guidance for cross-functional designs and issue resolution. They will deliver innovative business consulting, business process design, systems integration, application design, and project management. The successful candidate will need to provide leadership in coordinating complex projects across the team. The position requires a high level of analytical and technical skills, and competitive applicants must be comfortable working independently on projects that draw upon data from multiple applications and sources. The position may undertake other responsibilities as may arise to support the operations of ODoF.


Data Analysis and Reporting

  • Ensure user requirements are captured accurately to define report scope and objectives.
  • Write SQL queries to support the operational needs of the office such as assisting in reconciling PeopleSoft HCM data through monthly data validations.
  • Design and build standard, intuitive BI reports/dashboards to meet the faculty information needs of ODoF, academic units, administrative departments, and University leadership.
  • Understand and interpret database schemas to extract data from relational and dimensional data marts for analysis and reporting.
  • Document and follow best practices and methodologies for development standards, version control, deployment checklists and change management.
  • Systems Support, Maintenance and Operations

  • Test applications using manual or automated testing techniques.
  • Troubleshoot any issues reported across various ODoF applications.
  • Conduct system testing of enhancements, modifications and updates of OODoF systems.
  • Create and maintain queries to support reporting and troubleshooting needs.
  • Process job and salary actions in PeopleSoft HCM.
  • Manage personnel files in OnBase.
  • Assist with data entry in other ODoF systems as needed.
  • Provide functional and technical support for applications owned by the office by working collaboratively with the subject matter experts and the Office of Information Technology (OIT).
  • Update content on Drupal websites owned by ODoF as requested and provide additional support as needed.
  • Manage the configuration of ODoF LISTSERV lists and provide custom reports/lists as needed.
  • Maintain various ODoF SharePoint sites.
  • Systems Projects and Process Improvements

  • Document functional specifications in such a way as to facilitate the creation of technical specifications for coding or selection of purchased solutions.
  • Clearly translate business requirements into technology and process terms.
  • Works with internal ODoF staff and other campus partners to document and analyze functional requirements, identify gaps and alternative approaches to meet requirements (adhering to approved methodology and documentation standards).
  • Responsibility for a complex range of business processes and engagement with cross-functional areas, providing coordination, guidance, and support for other staff.
  • Facilitates status, business alignment, issue, and prioritization meetings.
  • Provides leadership in identifying and defining enhancement opportunities for assigned business areas.
  • Collaborates closely with business owners to ensure enhancements satisfy the required needs of the business and campus.
  • Coordinates with Office of Information Technology (OIT) personnel on addressing technical requirements impacting the overall solution design.
  • Supports organizational readiness by contributing to the planning for communications and training materials to facilitate the introduction of new capabilities impacting the designated functional areas.
  • Plays a key role in leading and executing functional user acceptance testing with guidance from the project teams. Writes test scripts and performs detailed testing to ensure that software and reports function correctly.

  • Qualifications

    Essential Qualifications

  • A Bachelor’s Degree is required.
  • Five years relevant work experience.
  • Exceptional proficiency with MS Excel.
  • Data analytics experience with strong technical skills (Cognos Analytics 11.x, Oracle, SQL Server, Tableau), including the ability to read/write basic SQL statements.
  • Strong analytical skills, ability to conduct research, analyze data and use software tools effectively to develop reports.
  • Ability to read, create, interpret, and understand database schemas, requirements, specifications, user guides, sequences of operation, and other technical data; ability to understand and analyze the complexities of software applications.
  • Two or more years of experience using large-scale ERP systems such as PeopleSoft HCM or Workday.
  • Understanding of IT system concepts and ability to communicate with technical staff. Specifically: Data warehousing design / development, ERP design, configuration and customization.
  • Ability to balance attention to detail while maintaining focus on the big picture.
  • Excellent problem-solving and analytical skills.
  • Excellent customer service skills.
  • Collaborative work style, team-player orientation. Able to interact effectively with multiple levels/personalities, and ability to learn and adapt quickly.
  • When provided access to personal, proprietary and/or otherwise confidential data, maintains such data in the strictest confidence and follows procedures to ensure the privacy, security and proper use of data.
  • Work collaboratively with the Office of Information Technology (OIT), Human Resources, Finance & Treasury and any associated offices to ensure ongoing integration to / from systems that they support on behalf of the Office of the Dean of the Faculty.
  • Preferred Qualifications

  • Previous experience working in higher education.
  • Working knowledge of PeopleSoft HCM.
  • Experience using standard testing techniques.
  • Master's or advanced degree preferred
  • Princeton University is an Equal Opportunity/Affirmative Action Employer and all qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity or expression, national origin, disability status, protected veteran status, or any other characteristic protected by law. EEO IS THE LAW


    You need to sign in or create an account to save a job.

    Get job alerts

    Create a job alert and receive personalized job recommendations straight to your inbox.

    Create alert