Business/Data Analyst
US-NJ-Princeton
Job ID: 2022-15235
Type: Full-Time
# of Openings: 1
Category: Information Technology
Princeton University
Overview
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.
Responsibilities
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
PI191305347