Senior Analyst, Systems Development

Columbia University
New York, NY, United States
7 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
5 years minimum
Compensation
$105,000.0 - $120,000.0
Working hours
Regular working hours
Job source

Tech stack

Microsoft Excel Data Analysis Software Documentation Information Systems Databases System Configuration Data Warehousing Human Resources Information System (HRIS) Microsoft Office Pivot Tables Systems Development Life Cycle Software Engineering
+14 more
SQL Databases System Testing Systems Integration Test Execution Engine Web Navigation Workday HCM Application Engine HR Software Information Technology People Soft Conditional Formatting Tools for Reporting Oracle HCM Workday

Job description

Reporting to the Senior Director of Systems Development, the Senior Analyst, Systems Development is a key member of the Human Resources Information Services (HRIS) team. This position serves as a technical and functional resource for the University’s enterprise Human Capital Management (HCM) system, preferably PeopleSoft., This role requires experience throughout the software development lifecycle, including gathering business requirements, developing functional specifications, creating and executing test plans, conducting regression and user acceptance testing, and supporting system upgrades, updates, customizations, integrations, and new module implementations., * Serve as the primary liaison between Human Resources, university-wide system users, and Information Technology to facilitate system enhancements, programming changes, and implementation of business requirements.

  • Analyze business needs and recommend system solutions that improve efficiency, functionality, and user experience.
  • Collaborate with HR and IT stakeholders to gather requirements and develop detailed functional specifications for enhancements, projects, and service requests.
  • Participate in system upgrades, patches, module implementations, integrations, and other HRIS-related projects.
  • Develop, execute, and document functional, technical, interface, regression, and user acceptance test plans to validate system functionality.
  • Utilize SQL, Query Manager, and other reporting tools to extract, analyze, validate, and report HR data in support of operational and strategic decision-making.
  • Identify, research, and resolve system issues and data discrepancies to ensure the accuracy, integrity, and confidentiality of HR data.
  • Support system configuration, process improvements, and ongoing maintenance of HR applications.
  • Provide guidance to Training and Communications teams in the development of user documentation, training materials, and presentations.
  • Deliver end-user training and system demonstrations through virtual or in-person sessions.
  • Maintain current knowledge of HRIS technologies, system functionality, and industry best practices.

Requirements

The incumbent possesses in-depth knowledge of core HCM functionality, including Human Resources, Payroll, Commitment Accounting, Manager Self Service, and Employee Self Service. The Senior Analyst combines strong analytical and technical skills with functional expertise to support business operations, system enhancements, reporting, testing, and implementation activities., * Bachelor’s degree or equivalent experience required; a degree in Information Systems, Computer Science, Human Resources, Business Administration, or a related field is preferred.

  • Minimum of five (5) years of experience supporting enterprise Human Capital Management (HCM) systems and Human Resources business processes.
  • Minimum of five (5) years of experience supporting PeopleSoft, Workday, Oracle HCM or a comparable enterprise Human Capital Management (HCM) system.
  • Demonstrated experience supporting enterprise HR systems through analysis, testing, implementation, and ongoing system maintenance.
  • Strong analytical, organizational, problem-solving, and interpersonal skills.
  • Ability to manage multiple priorities while maintaining a high level of accuracy and attention to detail.
  • Ability to handle confidential and sensitive information with discretion.

Preferred Knowledge, Skills and Abilities

  • Subject matter expertise in core HCM functionality, including system navigation, data maintenance, troubleshooting, and user support.
  • Functional expertise in one or more of the following areas:
  • Payroll
  • Workforce Administration
  • Manager Self Service
  • Employee Self Service
  • Experience with HR data reporting, analytics, and data warehousing solutions.
  • Working knowledge of PeopleSoft development and administrative tools, including:
  • Query Manager
  • SQL Developer
  • Application Designer
  • Application Engine
  • Component Interface
  • Process Scheduler
  • Application Workflow Engine
  • Experience with software development lifecycle (SDLC) methodologies, change management, and system testing best practices.
  • Advanced proficiency in Microsoft Office applications, particularly Excel, including pivot tables, logical and statistical formulas, lookups, conditional formatting, and data analysis tools.
  • Excellent written and verbal communication skills with the ability to translate technical concepts into business-friendly language.
  • Demonstrated ability to work collaboratively with cross-functional teams and stakeholders at all levels of the organization.

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on www.indeed.com

Good distractions

Talks and stories from around this role — technically off-topic, practically not.

1:21 min

Establishing employee experience as an independent strategic discipline

Rudi Bauer Rudi Bauer +1 · Cappuccino with HR

6:22 min

Eliminating HR bureaucracy and trusting employees

Rudi Bauer Rudi Bauer +1 · Cappuccino with HR

3:04 min

Database evolution and the funding behind vector databases

Erik Bamberg · LIVE

5:06 min

Primary reasons for capability gaps in modern recruitment systems

Rudi Bauer Rudi Bauer +1 · Cappuccino with HR

4:01 min

Managing application isolation via pluggable database models

Wei Hu Wei Hu · WWC 2022

2:55 min

Analyzing developer feedback on systemic human resources issues

Sibila Erdei Sibila Erdei · WWC 2025

Videos

See all

Related articles

See all