{"21976391":{"jobPath":"/jobs/21976391/finance-program-management-associate-digital-health","source":"naylor","job":"21976391","jobTitle":"Finance & Program Management Associate, Digital Health"},"21979864":{"jobPath":"/jobs/21979864/assistant-vice-president-of-finance","source":"naylor","job":"21979864","jobTitle":"Assistant Vice President of Finance"},"21959813":{"jobPath":"/jobs/21959813/associate-head-for-finance-and-operations-chief-financial-officer","source":"naylor","job":"21959813","jobTitle":"Associate Head for Finance and Operations/Chief Financial Officer"},"21976630":{"jobPath":"/jobs/21976630/postdoctoral-research-associate-the-julis-rabinowitz-center-for-public-policy-and-finance-jrcppf","source":"naylor","job":"21976630","jobTitle":"Postdoctoral Research Associate/The Julis-Rabinowitz Center for Public Policy and Finance (JRCPPF)"},"21932410":{"jobPath":"/jobs/21932410/senior-analyst-hr-finance-ops","source":"naylor","job":"21932410","jobTitle":"Senior Analyst, HR/Finance Ops"},"21976434":{"jobPath":"/jobs/21976434/finance-director-regional","source":"naylor","job":"21976434","jobTitle":"Finance Director, Regional"},"21977248":{"jobPath":"/jobs/21977248/director-of-finance-and-operations","source":"naylor","job":"21977248","jobTitle":"Director of Finance and Operations "},"21976831":{"jobPath":"/jobs/21976831/finance-operations-analyst-community-network-finance-operations-ft-days","source":"naylor","job":"21976831","jobTitle":"Finance Operations Analyst, Community Network - Finance Operations - FT Days"},"21976966":{"jobPath":"/jobs/21976966/senior-director-transaction-finance-attorney","source":"naylor","job":"21976966","jobTitle":"Senior Director, Transaction Finance Attorney"},"21956737":{"jobPath":"/jobs/21956737/cfo-vice-president-of-finance","source":"naylor","job":"21956737","jobTitle":"CFO & Vice President of Finance"},"21984649":{"jobPath":"/jobs/21984649/manager-finance-enterprise-applications","source":"naylor","job":"21984649","jobTitle":"Manager, Finance Enterprise Applications"},"21982405":{"jobPath":"/jobs/21982405/head-of-finance","source":"naylor","job":"21982405","jobTitle":"Head of Finance"},"21981736":{"jobPath":"/jobs/21981736/product-manager-hr-finance-supply-chain","source":"naylor","job":"21981736","jobTitle":"Product Manager - HR/Finance/Supply Chain"},"21980068":{"jobPath":"/jobs/21980068/director-of-finance","source":"naylor","job":"21980068","jobTitle":"Director of Finance"},"21980544":{"jobPath":"/jobs/21980544/manager-finance","source":"naylor","job":"21980544","jobTitle":"Manager Finance"},"21982187":{"jobPath":"/jobs/21982187/lead-finance","source":"naylor","job":"21982187","jobTitle":"Lead - Finance"},"21979795":{"jobPath":"/jobs/21979795/financial-quantitative-analyst","source":"naylor","job":"21979795","jobTitle":"Financial Quantitative Analyst"},"21978483":{"jobPath":"/jobs/21978483/director-of-finance-and-administration","source":"naylor","job":"21978483","jobTitle":"Director of Finance and Administration"},"21977355":{"jobPath":"/jobs/21977355/financial-operations-lead","source":"naylor","job":"21977355","jobTitle":"Financial Operations Lead"},"21978006":{"jobPath":"/jobs/21978006/sr-business-intelligence-analyst-x28-school-of-medicine-central-finance-x29","source":"naylor","job":"21978006","jobTitle":"Sr. Business Intelligence Analyst (School of Medicine - Central Finance)"},"21959887":{"jobPath":"/jobs/21959887/chief-financial-officer-co-chief-executive-officer","source":"naylor","job":"21959887","jobTitle":"Chief Financial Officer/Co-Chief Executive Officer"},"21936782":{"jobPath":"/jobs/21936782/director-esg","source":"naylor","job":"21936782","jobTitle":"Director, ESG"},"21973921":{"jobPath":"/jobs/21973921/associate-head-of-school-for-finance-and-operations-st-stephen-s-episcopal-school-austin-tx","source":"naylor","job":"21973921","jobTitle":"Associate Head of School for Finance and Operations - St. Stephen’s Episcopal School, Austin, TX"},"21945640":{"jobPath":"/jobs/21945640/finance-director-harris-county-emergency-services-district-no-48-tx","source":"naylor","job":"21945640","jobTitle":"Finance Director - Harris County Emergency Services District No. 48, TX"},"21980753":{"jobPath":"/jobs/21980753/associate-director-of-finance-administration","source":"naylor","job":"21980753","jobTitle":"Associate Director of Finance & Administration"}}
The salary of the finalist selected for this role will be set based on a variety of factors, including but not limited to departmental budgets, qualifications, experience, education, licenses, specialty, and training. The above hiring range represents the University's good faith and reasonable estimate of the range of possible compensation at the time of posting.
Position Summary
Reporting to the Assistant Director of Budget & Finance with a dual reporting line to Manager of HR & Faculty Affairs, the Senior Analyst position includes ensuring the coordination of finance and human resources processing including payroll, salary transitions and funding changes, and other adjustments for all compensation components in accordance with school and university policies and procedures.
Responsibilities
Finance Operations 60%
Performs reconciliation of salaries between the University's financial system (ARC) and CDM payroll budget.
Completes salary projections, including prorating salaries as needed.
Interprets and process allocation updates to ensure alignment with effort allocations.
Collaborates with the Research Team to monitor salary spending on grant projects in accordance with grant budgets, keeps track of subsequent changes, and makes necessary adjustments to funding profiles.
Assist in the preparation and completion of the annual rosters.
Works with Central Payroll to process and reconcile overpayment recovery entries and any other payment issues.
Lead special projects related to improving efficiencies in payroll processing and process improvement.
Collaborate with finance leadership to validate and refine revenue and expense budget baselines and targets
Meets regularly with the finance team and reports any issues, problems, or potential problems that could affect employee's salaries and/or salary accounts.
Special projects, reports, and ad hoc analyses, as needed
Human Resources 40%
Assists with onboarding efforts including creating new hire profiles in Kronos, provide training to staff regarding payroll process and protocols.
Reviews and approves bi-weekly payroll for the SEIU 1199 staff.
Responds to employee inquiries regarding payroll and resolves problem (e.g. over/under payments).
Troubleshoots and solve complex payroll problems and analyze information in multiple campus systems.
Monitors and processes casual and work-study payroll timekeeping in accordance with policies.
Tracks and clears payroll suspense reports.
Processes additional compensation payments for faculty and staff.
Provides data management uploads for the University & Service Corp Roster submission.
Assists in the preparation of salary surveys, reviewing and updating salary reports for CDM sections, maintaining payroll data, and preparing reports associated with compensation as needed.
Coordinate financial transactions required for HR processes such as leaves, new hires, terminations and compensation changes.
Works collaboratively with administrative leadership, business office personnel and other external partners including central payroll, controllers office as needed.
Performs Other duties as assigned.
Minimum Qualifications
Requires a Bachelor's degree or equivalent in education and experience, plus three years of related experience.
Preferred Qualifications
Must have experience in payroll and accounting; advanced skills in Microsoft Excel required; excellent organizational, interpersonal, and communication skills (written and oral) required.
Must have discretion in compensation communications and must have the ability to take initiative and interact effectively with others.
Must be detail-oriented and able to work in a fast-paced environment with minimal supervision.
Experience working within a large healthcare system.
Knowledge of financial and administrative systems preferred, such as PAC and ARC systems.
Familiarity with Kronos electronic timekeeping.
Equal Opportunity Employer / Disability / Veteran
Columbia University is committed to the hiring of qualified local residents.
Columbia University is one of the world's most important centers of research and at the same time a distinctive and distinguished learning environment for undergraduates and graduate students in many scholarly and professional fields. The University recognizes the importance of its location in New York City and seeks to link its research and teaching to the vast resources of a great metropolis. It seeks to attract a diverse and international faculty and student body, to support research and teaching on global issues, and to create academic relationships with many countries and regions. It expects all areas of the university to advance knowledge and learning at the highest level and to convey the products of its efforts to the world.